[Home] [Help]
View: 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
CONTAINER_ID |
DELIVERY_ID |
INVENTORY_ITEM_ID |
DESCRIPTION |
PICKING_LINE_DETAIL_ID |
ORDER_LINE_ID |
PACKED_QUANTITY |
UOM_CODE |
ORDER_LINE_NUMBER |
ORDER_NUMBER |
Name |