View: WSH_DSNO_PACKED_QUANTITY_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.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