VIEW: APPS.POR_RCV_SHIP_DISP_LINES_V

Source

View Text - Preformatted

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.CLM_DOCUMENT_NUMBER, 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_TRX_V POLL, PO_HEADERS POH, PO_LINES_TRX_V 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(+) AND POLL.PAYMENT_TYPE IS NULL

View Text - HTML Formatted

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.CLM_DOCUMENT_NUMBER
, 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_TRX_V POLL
, PO_HEADERS POH
, PO_LINES_TRX_V 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(+)
AND POLL.PAYMENT_TYPE IS NULL