[Home] [Help]
View: ECE_DSNO_PACKED_QUANTITY_V
Product: | EC - e-Commerce Gateway |
Description: | No longer used |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SPLD.DEPARTURE_ID DEPARTURE_ID
, SPLD.DELIVERY_ID DELIVERY_ID
, SPLD.CONTAINER_ID CONTAINER_ID
, SPL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SPL.ORDER_LINE_ID ORDER_LINE_ID
, SPL.PICKING_LINE_ID PICKING_LINE_ID
, SUM(NVL(SPLD.SHIPPED_QUANTITY
, 0)) PACKED_QUANTITY
FROM SO_PICKING_LINES_ALL SPL
, SO_PICKING_LINE_DETAILS SPLD
WHERE SPL.PICKING_LINE_ID=SPLD.PICKING_LINE_ID
AND NVL(SPLD.SHIPPED_QUANTITY
, 0) > 0 GROUP BY DEPARTURE_ID
, DELIVERY_ID
, CONTAINER_ID
, INVENTORY_ITEM_ID
, ORDER_LINE_ID
, SPL.PICKING_LINE_ID
Columns
Name |
DEPARTURE_ID |
DELIVERY_ID |
CONTAINER_ID |
INVENTORY_ITEM_ID |
ORDER_LINE_ID |
PICKING_LINE_ID |
PACKED_QUANTITY |