View: WSHFV_CONTAINER_CONTENT

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	APPS.WSHFV_CONTAINER_CONTENT

View Text

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

Columns