VIEW: APPS.WSHFV_DEPARTURE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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