eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSH_SS2_SHIPITEMS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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