VIEW: APPS.WSHBV_DEPARTURE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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