View: WSH_PACKED_CONTAINERS_DPW_V

Product:	OE - Order Entry
Description:	Containers for Departure Planning Workbench
Implementation/DBA Data:	APPS.WSH_PACKED_CONTAINERS_DPW_V

View Text

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

Columns