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_PACKED_CONTAINERS_DPW_V

Source

View Text - Preformatted


SELECT WPC.CONTAINER_ID , WDL.PLANNED_DEPARTURE_ID DEPARTURE_ID , WDP.NAME DEPARTURE_NAME , WPC.DELIVERY_ID , WDL.NAME DELIVERY_NAME , WPC.CONTAINER_INVENTORY_ITEM_ID , MSI.DESCRIPTION CONTAINER_DESCRIPTION , WPC.QUANTITY , MSI.PRIMARY_UOM_CODE UOM_CODE FROM WSH_DELIVERIES WDL, WSH_DEPARTURES WDP, WSH_PACKED_CONTAINERS WPC, MTL_SYSTEM_ITEMS MSI WHERE WDL.DELIVERY_ID = WPC.DELIVERY_ID AND MSI.INVENTORY_ITEM_ID = WPC.CONTAINER_INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = WPC.ORGANIZATION_ID AND WDP.DEPARTURE_ID (+) = WDL.PLANNED_DEPARTURE_ID

View Text - HTML Formatted

SELECT WPC.CONTAINER_ID
, WDL.PLANNED_DEPARTURE_ID DEPARTURE_ID
, WDP.NAME DEPARTURE_NAME
, WPC.DELIVERY_ID
, WDL.NAME DELIVERY_NAME
, WPC.CONTAINER_INVENTORY_ITEM_ID
, MSI.DESCRIPTION CONTAINER_DESCRIPTION
, WPC.QUANTITY
, MSI.PRIMARY_UOM_CODE UOM_CODE
FROM WSH_DELIVERIES WDL
, WSH_DEPARTURES WDP
, WSH_PACKED_CONTAINERS WPC
, MTL_SYSTEM_ITEMS MSI
WHERE WDL.DELIVERY_ID = WPC.DELIVERY_ID
AND MSI.INVENTORY_ITEM_ID = WPC.CONTAINER_INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = WPC.ORGANIZATION_ID
AND WDP.DEPARTURE_ID (+) = WDL.PLANNED_DEPARTURE_ID