View: WSHBV_DEPARTURE

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	APPS.WSHBV_DEPARTURE

View Text

SELECT DEP.ORGANIZATION_ID
, DEP.DEPARTURE_ID DEPARTURE_ID
, DEP.NAME DEPARTURE_NAME
, DEP.SOURCE_CODE
, DEP.ARRIVE_AFTER_DEPARTURE_ID ARRIVE_AFTER_DEPARTURE_ID
, DEP.STATUS_CODE STATUS_CODE
, DEP.REPORT_SET_ID REPORT_SET_ID
, DEP.DATE_CLOSED
, DEP.VEHICLE_ITEM_ID
, DEP.VEHICLE_NUMBER
, DEP.FREIGHT_CARRIER_CODE
, DEP.PLANNED_DEPARTURE_DATE
, DEP.ACTUAL_DEPARTURE_DATE
, DEP.BILL_OF_LADING
, DEP.GROSS_WEIGHT
, DEP.NET_WEIGHT
, DEP.WEIGHT_UOM_CODE
, DEP.VOLUME
, DEP.VOLUME_UOM_CODE
, DEP.FILL_PERCENT
, DEP.SEAL_CODE
, DEP.ROUTING_INSTRUCTIONS
, DEP.CREATION_DATE
, DEP.CREATED_BY
, DEP.LAST_UPDATE_DATE
, DEP.LAST_UPDATED_BY
, DEP.LAST_UPDATE_LOGIN
, DEP.PROGRAM_APPLICATION_ID
, DEP.PROGRAM_ID
, DEP.PROGRAM_UPDATE_DATE
, DEP.REQUEST_ID
FROM WSH_DEPARTURES DEP -- MTL_PARAMETERS ORG --
WHERE -- ORG.ORGANIZATION_ID (+) = DEP.ORGANIZATION_ID

Columns