View: WSH_DELIVERIES_DPW_LOV_V

Product:	OE - Order Entry
Description:	Open or planned deliveries created using Departure Planning Workbench
Implementation/DBA Data:	APPS.WSH_DELIVERIES_DPW_LOV_V

View Text

SELECT DEL.DELIVERY_ID
, DEL.NAME
, DEL.ORGANIZATION_ID
, DEL.STATUS_CODE
, DEL.SOURCE_CODE
, DEL.EXPECTED_ARRIVAL_DATE
, DEL.ACTUAL_DEPARTURE_ID
, DEP.NAME
, DEL.CUSTOMER_ID
, DEL.ULTIMATE_SHIP_TO_ID
, DEL.INTERMEDIATE_SHIP_TO_ID
, DEL.FOB_CODE
, DEL.FREIGHT_TERMS_CODE
, DEL.FREIGHT_CARRIER_CODE
, DEL.CURRENCY_CODE
FROM WSH_DEPARTURES DEP
, WSH_DELIVERIES DEL
WHERE DEL.SOURCE_CODE = 'D'
AND DEL.STATUS_CODE IN ('OP'
, 'PL')
AND DEL.ACTUAL_DEPARTURE_ID = DEP.DEPARTURE_ID(+)

Columns