View: WSH_DLS_UNASSIGNED_SC_V

View Text

SELECT PLD.ROWID ROW_ID
, PLD.PICKING_LINE_DETAIL_ID PICKING_LINE_DETAIL_ID
, PLD.PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, PLD.REQUESTED_QUANTITY REQUESTED_QUANTITY
, PLD.WAREHOUSE_ID ORGANIZATION_ID
, PL.UNIT_CODE UNIT_CODE
, PL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PLD.CONTAINER_ID CONTAINER_ID
, PC.CONTAINER_INVENTORY_ITEM_ID CONTAINER_INVENTORY_ITEM_ID
, MSI.DESCRIPTION CONTAINER_DESCRIPTION
, NVL(PL.SHIP_METHOD_CODE
, H.SHIP_METHOD_CODE) FREIGHT_CARRIER_CODE
, PL.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, H.ORDER_NUMBER ORDER_NUMBER
, L.LINE_NUMBER LINE_NUMBER
, H.FOB_CODE FOB_CODE
, H.CUSTOMER_ID CUSTOMER_ID
, RC.CUSTOMER_NAME CUSTOMER_NAME
, NVL(PL.SHIP_TO_SITE_USE_ID
, NVL(PH.SHIP_TO_SITE_USE_ID
, NVL(L.SHIP_TO_SITE_USE_ID
, H.SHIP_TO_SITE_USE_ID))) ULTIMATE_SHIP_TO_ID
, L.INTERMEDIATE_SHIP_TO_ID INTERMEDIATE_SHIP_TO_ID
, H.CURRENCY_CODE CURRENCY_CODE
, PL.SCHEDULE_DATE SCHEDULE_DATE
, PL.DATE_REQUESTED REQUEST_DATE
, L.PLANNING_PROD_SEQ_NUMBER PLANNING_PROD_SEQ_NUMBER
, L.CUSTOMER_DOCK_CODE DOCK_CODE
, L.CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, H.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, H.HEADER_ID ORDER_HEADER_ID
, PH.BATCH_ID BATCH_ID
, WIP.WIP_ENTITY_NAME WIP_NUMBER
FROM SO_PICKING_LINE_DETAILS PLD
, SO_PICKING_HEADERS_ALL PH
, SO_LINES_ALL L
, SO_HEADERS_ALL H
, WSH_PACKED_CONTAINERS PC
, MTL_SYSTEM_ITEMS MSI
, WIP_ENTITIES WIP
, RA_CUSTOMERS RC
, SO_PICKING_LINES_ALL PL
WHERE PLD.PICKING_LINE_ID = PL.PICKING_LINE_ID
AND PL.ORDER_LINE_ID+0 = L.LINE_ID
AND PL.PICKING_HEADER_ID = PH.PICKING_HEADER_ID
AND L.HEADER_ID+0 = H.HEADER_ID
AND RC.CUSTOMER_ID = H.CUSTOMER_ID
AND PLD.CONTAINER_ID = PC.CONTAINER_ID (+)
AND PC.CONTAINER_INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND PC.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND PH.PICKING_HEADER_ID + 0 > 0
AND PH.STATUS_CODE = 'OPEN'
AND PLD.DELIVERY_ID IS NULL
AND WIP.WIP_ENTITY_ID (+) = PLD.SUPPLY_SOURCE_HEADER_ID

Columns