View: WSHFV_DEPARTURE

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

View Text

SELECT DEP1.ORGANIZATION_ID
, DEP1.DEPARTURE_ID DEPARTURE_ID
, DEP1.NAME DEPARTURE_NAME
, DEP1.SOURCE_CODE
, DEP1.ARRIVE_AFTER_DEPARTURE_ID ARRIVE_AFTER_DEPARTURE_ID
, DEP2.NAME ARRIVE_AFTER_DEPARTURE_NAME
, DEP2.PLANNED_DEPARTURE_DATE ARR_PLANNED_DEPARTURE_DATE
, DEP2.ACTUAL_DEPARTURE_DATE ARR_ACTUAL_DEPARTURE_DATE
, DEP1.STATUS_CODE STATUS_CODE
, DEP1.REPORT_SET_ID REPORT_SET_ID
, SRS.NAME REPORT_SET_NAME
, DEP1.DATE_CLOSED
, DEP1.VEHICLE_ITEM_ID
, DEP1.VEHICLE_NUMBER
, DEP1.FREIGHT_CARRIER_CODE
, DEP1.PLANNED_DEPARTURE_DATE
, DEP1.ACTUAL_DEPARTURE_DATE
, DEP1.BILL_OF_LADING
, DEP1.GROSS_WEIGHT
, DEP1.NET_WEIGHT
, DEP1.WEIGHT_UOM_CODE
, MSI.DESCRIPTION VEHICLE_DESCRIPTION
, MSI.PRIMARY_UOM_CODE VEHICLE_PRIMARY_UOM_CODE
, MSI.UNIT_WEIGHT TARE_WEIGHT
, MSI.MAXIMUM_LOAD_WEIGHT MAXIMUM_LOAD_WEIGHT
, MSI.INTERNAL_VOLUME MAXIMUM_VOLUME
, MSI.MINIMUM_FILL_PERCENT MINIMUM_FILL_PERCENT
, DEP1.VOLUME
, DEP1.VOLUME_UOM_CODE
, DEP1.FILL_PERCENT
, DEP1.SEAL_CODE
, DEP1.ROUTING_INSTRUCTIONS
, DEP1.CREATION_DATE
, DEP1.CREATED_BY
, DEP1.LAST_UPDATE_DATE
, DEP1.LAST_UPDATED_BY
, DEP1.LAST_UPDATE_LOGIN
, DEP1.PROGRAM_APPLICATION_ID
, DEP1.PROGRAM_ID
, DEP1.PROGRAM_UPDATE_DATE
, DEP1.REQUEST_ID
FROM WSH_DEPARTURES DEP1
, WSH_DEPARTURES DEP2
, SO_REPORT_SETS SRS
, MTL_SYSTEM_ITEMS MSI
WHERE DEP2.DEPARTURE_ID (+) = DEP1.ARRIVE_AFTER_DEPARTURE_ID
AND SRS.REPORT_SET_ID(+) = DEP1.REPORT_SET_ID
AND MSI.INVENTORY_ITEM_ID(+) = DEP1.VEHICLE_ITEM_ID
AND MSI.ORGANIZATION_ID(+) = DEP1.ORGANIZATION_ID

Columns