[Home] [Help]
View: WSHBV_CONTAINER_CONTENT
View Text
SELECT WCCV.CONTAINER_ID
, WCCV.DELIVERY_ID
, DEL.NAME
, WCCV.INVENTORY_ITEM_ID
, WCCV.DESCRIPTION
, WCCV.ORDER_LINE_ID
, WCCV.ORDER_LINE_NUMBER
, WCCV.ORDER_NUMBER
, WCCV.PICKING_LINE_DETAIL_ID
, WCCV.UOM_CODE
, WCCV.PACKED_QUANTITY
FROM WSH_CONTAINER_CONTENTS_V WCCV
, WSH_DELIVERIES DEL
WHERE WCCV.DELIVERY_ID = DEL.DELIVERY_ID
Columns
Name |
CONTAINER_ID |
DELIVERY_ID |
NAME |
INVENTORY_ITEM_ID |
DESCRIPTION |
ORDER_LINE_ID |
ORDER_LINE_NUMBER |
ORDER_NUMBER |
PICKING_LINE_DETAIL_ID |
UOM_CODE |
PACKED_QUANTITY |