[Home] [Help]
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
Name |
LINE_NUM |
SHIP_HEADER_ID |
ORDER_NUMBER |
ITEM_DESCRIPTION |
SUPPLIER_ITEM_NUMBER |
SHIP_TO_LOCATION |
QUANTITY_SHIPPED |
PACKING_SLIP |
CONTAINER_NUM |
COUNTRY_OF_ORIGIN_CODE |
COMMENTS |
ORDER_TYPE |
LINE_ID |