View: POR_RCV_HOME_RECEIPTS_V

Product:	ICX - Oracle iProcurement
Description:	View to query receipts in receiving home page
Implementation/DBA Data:	APPS.POR_RCV_HOME_RECEIPTS_V

View Text

SELECT RT.TRANSACTION_ID
, RT.CREATION_DATE
, RT.TRANSACTION_DATE
, RT.EMPLOYEE_ID
, RSH.RECEIPT_NUM
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, NVL(POV.VENDOR_NAME
, HAOU.NAME) VENDOR
FROM RCV_SHIPMENT_LINES RSL
, RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, PO_VENDORS POV
, HR_ALL_ORGANIZATION_UNITS HAOU
, PO_LINE_LOCATIONS POLL
WHERE RT.TRANSACTION_TYPE = 'DELIVER'
AND (RT.SOURCE_DOCUMENT_CODE = 'PO' OR 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 RSH.VENDOR_ID = POV.VENDOR_ID (+)
AND RSL.FROM_ORGANIZATION_ID = HAOU.ORGANIZATION_ID (+)
AND POLL.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID UNION SELECT RT.TRANSACTION_ID
, RT.CREATION_DATE
, RT.TRANSACTION_DATE
, RT.EMPLOYEE_ID
, RSH.RECEIPT_NUM
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, NULL VENDOR
FROM RCV_SHIPMENT_LINES RSL
, RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, 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 RT.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID

Columns