DBA Data[Home] [Help]

VIEW: APPS.WSHBV_CONTAINER_CONTENT

Source

View Text - Preformatted

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
View Text - HTML Formatted

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