View: POR_RCV_SHIP_DISP_HEADERS_V

Product:	ICX - Oracle iProcurement
Description:	The view queries the information which is used to display the shipment header level information on the Shipment details page.
Implementation/DBA Data:	APPS.POR_RCV_SHIP_DISP_HEADERS_V

View Text

SELECT RSH.SHIPPED_DATE
, RSH.EXPECTED_RECEIPT_DATE
, RSH.FREIGHT_TERMS
, RSH.FREIGHT_CARRIER_CODE
, RSH.NUM_OF_CONTAINERS
, RSH.WAYBILL_AIRBILL_NUM
, RSH.PACKAGING_CODE
, RSH.SHIPMENT_NUM
, RSH.SHIPMENT_HEADER_ID
, 'REQ'
, PORL.REQUISITION_LINE_ID
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_REQUISITION_LINES PORL
WHERE PORL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID
AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID UNION ALL SELECT RSH.SHIPPED_DATE
, RSH.EXPECTED_RECEIPT_DATE
, RSH.FREIGHT_TERMS
, RSH.FREIGHT_CARRIER_CODE
, RSH.NUM_OF_CONTAINERS
, RSH.WAYBILL_AIRBILL_NUM
, RSH.PACKAGING_CODE
, RSH.SHIPMENT_NUM
, RSH.SHIPMENT_HEADER_ID
, 'PO'
, POLL.LINE_LOCATION_ID
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_LINE_LOCATIONS POLL
WHERE POLL.LINE_LOCATION_ID = RSL.PO_LINE_LOCATION_ID
AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RSH.ASN_TYPE IS NOT NULL

Columns