VIEW: APPS.WSH_DELIVERIES_DPW_LOV_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)