VIEW: APPS.WSH_DEPARTURES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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