VIEW: APPS.WSHFV_CONTAINER_CONTENT

Source

View Text - Preformatted

SELECT PC.CONTAINER_ID , PC.DELIVERY_ID , WDL.NAME DELIVERY_NAME , SPLA.INVENTORY_ITEM_ID , MSI.DESCRIPTION ITEM_DESCRIPTION , SPLD.PICKING_LINE_DETAIL_ID , SPLA.ORDER_LINE_ID , SPLD.SHIPPED_QUANTITY PACKED_QUANTITY , MSI.PRIMARY_UOM_CODE UOM_CODE , SOLA.LINE_NUMBER ORDER_LINE_NUMBER , SOHA.ORDER_NUMBER ORDER_NUMBER FROM WSH_PACKED_CONTAINERS PC, SO_PICKING_LINES_ALL SPLA, SO_PICKING_LINE_DETAILS SPLD, SO_LINES_ALL SOLA, SO_HEADERS_ALL SOHA, MTL_SYSTEM_ITEMS MSI , WSH_DELIVERIES WDL WHERE SPLD.CONTAINER_ID = PC.CONTAINER_ID AND SPLD.PICKING_LINE_ID = SPLA.PICKING_LINE_ID AND SPLA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND SPLA.ORDER_LINE_ID = SOLA.LINE_ID AND SOLA.HEADER_ID = SOHA.HEADER_ID AND MSI.ORGANIZATION_ID = PC.ORGANIZATION_ID AND SPLA.PICKING_HEADER_ID + 0 > 0 AND WDL.DELIVERY_ID (+) = PC.DELIVERY_ID

View Text - HTML Formatted

SELECT PC.CONTAINER_ID
, PC.DELIVERY_ID
, WDL.NAME DELIVERY_NAME
, SPLA.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, SPLD.PICKING_LINE_DETAIL_ID
, SPLA.ORDER_LINE_ID
, SPLD.SHIPPED_QUANTITY PACKED_QUANTITY
, MSI.PRIMARY_UOM_CODE UOM_CODE
, SOLA.LINE_NUMBER ORDER_LINE_NUMBER
, SOHA.ORDER_NUMBER ORDER_NUMBER
FROM WSH_PACKED_CONTAINERS PC
, SO_PICKING_LINES_ALL SPLA
, SO_PICKING_LINE_DETAILS SPLD
, SO_LINES_ALL SOLA
, SO_HEADERS_ALL SOHA
, MTL_SYSTEM_ITEMS MSI
, WSH_DELIVERIES WDL
WHERE SPLD.CONTAINER_ID = PC.CONTAINER_ID
AND SPLD.PICKING_LINE_ID = SPLA.PICKING_LINE_ID
AND SPLA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND SPLA.ORDER_LINE_ID = SOLA.LINE_ID
AND SOLA.HEADER_ID = SOHA.HEADER_ID
AND MSI.ORGANIZATION_ID = PC.ORGANIZATION_ID
AND SPLA.PICKING_HEADER_ID + 0 > 0
AND WDL.DELIVERY_ID (+) = PC.DELIVERY_ID