POR_TRANSFER_ORDERS_V

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name
DOCUMENT_NUM HEADER_ID REQUISITION_HEADER_ID

Query

SQL_Statement
SELECT distinct InvTransferOrderHeaderPEO.HEADER_NUMBER DOCUMENT_NUM, InvTransferOrderHeaderPEO.HEADER_ID, RequisitionLineEO.REQUISITION_HEADER_ID from POR_REQUISITION_LINES_ALL RequisitionLineEO, INV_TRANSFER_ORDER_HEADERS InvTransferOrderHeaderPEO where RequisitionLineEO.TO_HEADER_ID = InvTransferOrderHeaderPEO.HEADER_ID