View: WSH_DEPARTURES_V

Product:	OE - Order Entry
Description:	Departures for departure planning or ship confirm
Implementation/DBA Data:	APPS.WSH_DEPARTURES_V

View Text

SELECT DEP1.ORGANIZATION_ID
, DEP1.ROWID ROW_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
, SU.MEANING STATUS
, 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
, DEP1.GROSS_WEIGHT - DEP1.NET_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.ATTRIBUTE_CATEGORY
, DEP1.ATTRIBUTE1
, DEP1.ATTRIBUTE2
, DEP1.ATTRIBUTE3
, DEP1.ATTRIBUTE4
, DEP1.ATTRIBUTE5
, DEP1.ATTRIBUTE6
, DEP1.ATTRIBUTE7
, DEP1.ATTRIBUTE8
, DEP1.ATTRIBUTE9
, DEP1.ATTRIBUTE10
, DEP1.ATTRIBUTE11
, DEP1.ATTRIBUTE12
, DEP1.ATTRIBUTE13
, DEP1.ATTRIBUTE14
, DEP1.ATTRIBUTE15
, 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_LOOKUPS SU
, SO_REPORT_SETS SRS
, MTL_SYSTEM_ITEMS MSI
WHERE DEP2.DEPARTURE_ID (+) = DEP1.ARRIVE_AFTER_DEPARTURE_ID
AND SU.LOOKUP_TYPE (+) = 'SHIPPING_STATUS'
AND SU.LOOKUP_CODE (+) = DEP1.STATUS_CODE
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