VIEW: APPS.POR_RCV_SHIP_DISP_HEADERS_V

Source

View Text - Preformatted

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_TRX_V 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 AND POLL.PAYMENT_TYPE IS NULL

View Text - HTML Formatted

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_TRX_V 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
AND POLL.PAYMENT_TYPE IS NULL