[Home] [Help]
View: WSH_DSNO_PACKED_QUANTITY_V
View Text
SELECT WDA.DELIVERY_ID DELIVERY_ID
, WDA.PARENT_DELIVERY_DETAIL_ID CONTAINER_ID
, WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, WDD.SOURCE_CODE SOURCE_CODE
, WDD.SOURCE_HEADER_ID SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID SOURCE_LINE_ID
, DECODE(WDA.PARENT_DELIVERY_DETAIL_ID
, NULL
, 0
, SUM(NVL(WDD.SHIPPED_QUANTITY
, 0))) PACKED_QUANTITY
, DECODE(WDA.PARENT_DELIVERY_DETAIL_ID
, NULL
, 0
, SUM(NVL(WDD.SHIPPED_QUANTITY2
, 0))) PACKED_QUANTITY2
FROM WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_DELIVERY_DETAILS WDD
WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND WDD.CONTAINER_FLAG = 'N'
AND NVL(WDD.SHIPPED_QUANTITY
, 0) > 0 GROUP BY WDA.DELIVERY_ID
, WDA.PARENT_DELIVERY_DETAIL_ID
, WDD.INVENTORY_ITEM_ID
, WDD.SOURCE_CODE
, WDD.SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID
Columns
Name |
DELIVERY_ID |
CONTAINER_ID |
INVENTORY_ITEM_ID |
SOURCE_CODE |
SOURCE_HEADER_ID |
SOURCE_LINE_ID |
PACKED_QUANTITY |
PACKED_QUANTITY2 |