VIEW: APPS.POR_RCV_HOME_RECEIPTS_V

Source

View Text - Preformatted

SELECT RT.SHIPMENT_HEADER_ID, RT.TRANSACTION_ID, RT.CREATION_DATE, RT.TRANSACTION_DATE, RT.EMPLOYEE_ID, RSH.RECEIPT_NUM, RSL.ITEM_ID, RSL.ITEM_DESCRIPTION, POV.VENDOR_NAME, HRO.NAME FROM RCV_SHIPMENT_LINES RSL, RCV_SHIPMENT_HEADERS RSH, RCV_TRANSACTIONS RT, PO_VENDORS POV, PO_REQ_DISTRIBUTIONS PRD, PO_DISTRIBUTIONS_TRX_V POD, PO_LINE_LOCATIONS_TRX_V PLL, HR_ALL_ORGANIZATION_UNITS_TL HRO WHERE RT.TRANSACTION_TYPE = 'DELIVER' AND RT.SOURCE_DOCUMENT_CODE = 'PO' AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID AND RT.ROUTING_HEADER_ID = 3 AND RSH.VENDOR_ID = POV.VENDOR_ID AND POD.REQ_DISTRIBUTION_ID = PRD.DISTRIBUTION_ID AND POD.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID AND PLL.PAYMENT_TYPE IS NULL AND POD.ORG_ID = HRO.ORGANIZATION_ID AND HRO.LANGUAGE = USERENV('LANG') UNION ALL SELECT RT.SHIPMENT_HEADER_ID, RT.TRANSACTION_ID, RT.CREATION_DATE, RT.TRANSACTION_DATE, RT.EMPLOYEE_ID, RSH.RECEIPT_NUM, RSL.ITEM_ID, RSL.ITEM_DESCRIPTION, POV.VENDOR_NAME, HRO.NAME FROM RCV_SHIPMENT_LINES RSL, RCV_SHIPMENT_HEADERS RSH, RCV_TRANSACTIONS RT, PO_VENDORS POV, PO_DISTRIBUTIONS_TRX_V POD, PO_LINE_LOCATIONS_TRX_V PLL, HR_ALL_ORGANIZATION_UNITS_TL HRO WHERE RT.TRANSACTION_TYPE = 'DELIVER' AND RT.SOURCE_DOCUMENT_CODE = 'PO' AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID AND RT.ROUTING_HEADER_ID = 3 AND RSH.VENDOR_ID = POV.VENDOR_ID AND POD.REQ_DISTRIBUTION_ID IS NULL AND POD.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID AND PLL.LINE_LOCATION_ID= POD.LINE_LOCATION_ID AND PLL.PAYMENT_TYPE IS NULL AND POD.ORG_ID = HRO.ORGANIZATION_ID AND HRO.LANGUAGE = USERENV('LANG') UNION ALL SELECT RT.SHIPMENT_HEADER_ID, RT.TRANSACTION_ID, RT.CREATION_DATE, RT.TRANSACTION_DATE, RT.EMPLOYEE_ID, RSH.RECEIPT_NUM, RSL.ITEM_ID, RSL.ITEM_DESCRIPTION, OOD.NAME VENDOR, NULL FROM RCV_SHIPMENT_LINES RSL, RCV_SHIPMENT_HEADERS RSH, RCV_TRANSACTIONS RT, HR_ALL_ORGANIZATION_UNITS_TL OOD, PO_REQUISITION_LINES PRL WHERE RT.TRANSACTION_TYPE = 'DELIVER' AND RT.SOURCE_DOCUMENT_CODE = 'REQ' AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID AND RT.ROUTING_HEADER_ID = 3 AND OOD.ORGANIZATION_ID(+) = RSL.FROM_ORGANIZATION_ID AND OOD.LANGUAGE(+) = USERENV('LANG') AND RT.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID

View Text - HTML Formatted

SELECT RT.SHIPMENT_HEADER_ID
, RT.TRANSACTION_ID
, RT.CREATION_DATE
, RT.TRANSACTION_DATE
, RT.EMPLOYEE_ID
, RSH.RECEIPT_NUM
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, POV.VENDOR_NAME
, HRO.NAME
FROM RCV_SHIPMENT_LINES RSL
, RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, PO_VENDORS POV
, PO_REQ_DISTRIBUTIONS PRD
, PO_DISTRIBUTIONS_TRX_V POD
, PO_LINE_LOCATIONS_TRX_V PLL
, HR_ALL_ORGANIZATION_UNITS_TL HRO
WHERE RT.TRANSACTION_TYPE = 'DELIVER'
AND RT.SOURCE_DOCUMENT_CODE = 'PO'
AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID
AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RT.ROUTING_HEADER_ID = 3
AND RSH.VENDOR_ID = POV.VENDOR_ID
AND POD.REQ_DISTRIBUTION_ID = PRD.DISTRIBUTION_ID
AND POD.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND PLL.PAYMENT_TYPE IS NULL
AND POD.ORG_ID = HRO.ORGANIZATION_ID
AND HRO.LANGUAGE = USERENV('LANG') UNION ALL SELECT RT.SHIPMENT_HEADER_ID
, RT.TRANSACTION_ID
, RT.CREATION_DATE
, RT.TRANSACTION_DATE
, RT.EMPLOYEE_ID
, RSH.RECEIPT_NUM
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, POV.VENDOR_NAME
, HRO.NAME
FROM RCV_SHIPMENT_LINES RSL
, RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, PO_VENDORS POV
, PO_DISTRIBUTIONS_TRX_V POD
, PO_LINE_LOCATIONS_TRX_V PLL
, HR_ALL_ORGANIZATION_UNITS_TL HRO
WHERE RT.TRANSACTION_TYPE = 'DELIVER'
AND RT.SOURCE_DOCUMENT_CODE = 'PO'
AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID
AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RT.ROUTING_HEADER_ID = 3
AND RSH.VENDOR_ID = POV.VENDOR_ID
AND POD.REQ_DISTRIBUTION_ID IS NULL
AND POD.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID
AND PLL.LINE_LOCATION_ID= POD.LINE_LOCATION_ID
AND PLL.PAYMENT_TYPE IS NULL
AND POD.ORG_ID = HRO.ORGANIZATION_ID
AND HRO.LANGUAGE = USERENV('LANG') UNION ALL SELECT RT.SHIPMENT_HEADER_ID
, RT.TRANSACTION_ID
, RT.CREATION_DATE
, RT.TRANSACTION_DATE
, RT.EMPLOYEE_ID
, RSH.RECEIPT_NUM
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, OOD.NAME VENDOR
, NULL
FROM RCV_SHIPMENT_LINES RSL
, RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, HR_ALL_ORGANIZATION_UNITS_TL OOD
, PO_REQUISITION_LINES PRL
WHERE RT.TRANSACTION_TYPE = 'DELIVER'
AND RT.SOURCE_DOCUMENT_CODE = 'REQ'
AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID
AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RT.ROUTING_HEADER_ID = 3
AND OOD.ORGANIZATION_ID(+) = RSL.FROM_ORGANIZATION_ID
AND OOD.LANGUAGE(+) = USERENV('LANG')
AND RT.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID