View: WSH_SS2_SHIPITEMS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_SS2_SHIPITEMS_V

View Text

SELECT WDD.SHIPMENT_BATCH_ID SHIPMENT_BATCH_ID
, WDD.SHIPMENT_LINE_NUMBER SHIPMENT_LINE_NUMBER
, WDD.SOURCE_HEADER_NUMBER SALES_ORDER_NUMBER
, WDD.REFERENCE_LINE_ID REFERENCE_LINE_ID
, WDD.REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM
, SUM(WDD.REQUESTED_QUANTITY) REQUESTED_QUANTITY
FROM WSH_DELIVERY_DETAILS WDD
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE WDD.SOURCE_CODE = 'OE'
AND WDD.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND WDD.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND WDD.SHIPMENT_BATCH_ID IS NOT NULL GROUP BY WDD.SHIPMENT_BATCH_ID
, WDD.SHIPMENT_LINE_NUMBER
, WDD.SOURCE_HEADER_NUMBER
, WDD.REFERENCE_LINE_ID
, WDD.REQUESTED_QUANTITY_UOM

Columns