View: POR_RCV_SHIP_DISP_LINES_V

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

View Text

SELECT RSL.LINE_NUM
, RSL.SHIPMENT_HEADER_ID
, PO_INQ_SV.GET_SO_NUMBER(PORL.REQUISITION_HEADER_ID
, PORL.REQUISITION_LINE_ID)
, PORL.ITEM_DESCRIPTION
, PORL.SUGGESTED_VENDOR_PRODUCT_CODE
, HRLT.LOCATION_CODE
, RSL.QUANTITY_SHIPPED
, RSL.PACKING_SLIP
, RSL.CONTAINER_NUM
, FTV.NLS_TERRITORY
, RSL.COMMENTS
, 'REQ'
, PORL.REQUISITION_LINE_ID
FROM RCV_SHIPMENT_LINES RSL
, PO_REQUISITION_LINES PORL
, HR_LOCATIONS_ALL_TL HRLT
, FND_TERRITORIES_VL FTV
WHERE PORL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID
AND RSL.SHIP_TO_LOCATION_ID = HRLT.LOCATION_ID (+)
AND HRLT.LANGUAGE (+) = USERENV('LANG')
AND RSL.COUNTRY_OF_ORIGIN_CODE = FTV.TERRITORY_CODE(+) UNION ALL SELECT RSL.LINE_NUM
, RSL.SHIPMENT_HEADER_ID
, POH.SEGMENT1
, POL.ITEM_DESCRIPTION
, POL.VENDOR_PRODUCT_NUM
, HRLT.LOCATION_CODE
, RSL.QUANTITY_SHIPPED
, RSL.PACKING_SLIP
, RSL.CONTAINER_NUM
, FTV.NLS_TERRITORY
, RSL.COMMENTS
, 'PO'
, POLL.LINE_LOCATION_ID
FROM RCV_SHIPMENT_LINES RSL
, PO_LINE_LOCATIONS POLL
, PO_HEADERS POH
, PO_LINES POL
, HR_LOCATIONS_ALL_TL HRLT
, FND_TERRITORIES_VL FTV
WHERE POLL.LINE_LOCATION_ID = RSL.PO_LINE_LOCATION_ID
AND POLL.PO_LINE_ID = POL.PO_LINE_ID
AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND RSL.SHIP_TO_LOCATION_ID = HRLT.LOCATION_ID (+)
AND HRLT.LANGUAGE (+) = USERENV('LANG')
AND RSL.COUNTRY_OF_ORIGIN_CODE = FTV.TERRITORY_CODE(+)

Columns