View: WSH_CONTAINER_CONTENTS_V

Product:	OE - Order Entry
Description:	Container contents
Implementation/DBA Data:	APPS.WSH_CONTAINER_CONTENTS_V

View Text

SELECT PC.CONTAINER_ID
, PC.DELIVERY_ID
, SPLA.INVENTORY_ITEM_ID
, MSI.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
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

Columns