eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MST_LOAD_STOPS_V

Source

View Text - Preformatted


SELECT TS.PLAN_ID, TS.TRIP_ID, TS.STOP_ID, TS.STOP_SEQUENCE_NUMBER STOP_NUMBER, TS.STOP_LOCATION_ID, TS.ROWID ROW_ID, SUBSTR(MST_WB_UTIL.GET_NAME (WL.WSH_LOCATION_ID), 1,80) COMPANY, LP.FACILITY_ID, LP.FACILITY_CODE FACILITY, LP.DESCRIPTION DESCRIPTION, WL.CITY CITY, WL.STATE STATE, WL.POSTAL_CODE ZIP, WL.COUNTRY, SUBSTR(MST_WB_UTIL.get_local_chardtzone (WL.WSH_LOCATION_ID, TS.PLANNED_ARRIVAL_DATE),1,80) ARRIVAL_DATE_TIME, MST_GEOCODING.Get_local_time (WL.WSH_LOCATION_ID, TS.PLANNED_ARRIVAL_DATE) ARR_DATETIME_HIDDEN, SUBSTR(MST_GEOCODING.Get_timezone_code (WL.WSH_LOCATION_ID, MST_GEOCODING.Get_local_time (WL.WSH_LOCATION_ID, TS.PLANNED_ARRIVAL_DATE)),1,10) ARRIVAL_TIME_ZONE, SUBSTR(MST_WB_UTIL.get_local_chardtzone (WL.WSH_LOCATION_ID, TS.PLANNED_DEPARTURE_DATE),1,80) DEPARTURE_DATE_TIME, MST_GEOCODING.Get_local_time (WL.WSH_LOCATION_ID, TS.PLANNED_DEPARTURE_DATE) DEP_DATETIME_HIDDEN, SUBSTR(MST_GEOCODING.Get_timezone_code (WL.WSH_LOCATION_ID, MST_GEOCODING.Get_local_time (WL.WSH_LOCATION_ID, TS.PLANNED_DEPARTURE_DATE)),1,10) DEPARTURE_TIME_ZONE, SUBSTR(MST_WB_UTIL.ELAPSED_TIME (TS.PLANNED_ARRIVAL_DATE, TS.PLANNED_DEPARTURE_DATE), 1,12) STOP_TIME, TS.DEPARTURE_GROSS_WEIGHT LOAD_WEIGHT, TS.DEPARTURE_VOLUME LOAD_CUBE, TS.DEPARTURE_PALLETS PALLETS, TS.DEPARTURE_PIECES PIECES, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID, TS.TRIP_ID,TS.STOP_ID,'D','W') WEIGHT_UNLOADED, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID, TS.TRIP_ID,TS.STOP_ID,'D','V') CUBE_UNLOADED, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID, TS.TRIP_ID,TS.STOP_ID,'D','P') PALLETS_UNLOADED, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID, TS.TRIP_ID,TS.STOP_ID,'D','PC') PIECES_UNLOADED, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID, TS.TRIP_ID,TS.STOP_ID,'O','W') WEIGHT_LOADED, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID, TS.TRIP_ID,TS.STOP_ID,'O','V') CUBE_LOADED, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID, TS.TRIP_ID,TS.STOP_ID,'O','P') PALLETS_LOADED, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID, TS.TRIP_ID,TS.STOP_ID,'O','PC') PIECES_LOADED, MP.WEIGHT_UOM, MP.VOLUME_UOM FROM MST_PLANS MP, MST_TRIPS T, MST_TRIP_STOPS TS, WSH_LOCATIONS WL, FTE_LOCATION_PARAMETERS LP WHERE MP.PLAN_iD = T.PLAN_ID AND T.PLAN_ID = TS.PLAN_ID AND T.TRIP_ID = TS.TRIP_ID AND T.MODE_OF_TRANSPORT = 'TRUCK' AND WL.WSH_LOCATION_ID = TS.STOP_LOCATION_ID AND WL.WSH_LOCATION_ID = LP.LOCATION_ID

View Text - HTML Formatted

SELECT TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, TS.STOP_SEQUENCE_NUMBER STOP_NUMBER
, TS.STOP_LOCATION_ID
, TS.ROWID ROW_ID
, SUBSTR(MST_WB_UTIL.GET_NAME (WL.WSH_LOCATION_ID)
, 1
, 80) COMPANY
, LP.FACILITY_ID
, LP.FACILITY_CODE FACILITY
, LP.DESCRIPTION DESCRIPTION
, WL.CITY CITY
, WL.STATE STATE
, WL.POSTAL_CODE ZIP
, WL.COUNTRY
, SUBSTR(MST_WB_UTIL.GET_LOCAL_CHARDTZONE (WL.WSH_LOCATION_ID
, TS.PLANNED_ARRIVAL_DATE)
, 1
, 80) ARRIVAL_DATE_TIME
, MST_GEOCODING.GET_LOCAL_TIME (WL.WSH_LOCATION_ID
, TS.PLANNED_ARRIVAL_DATE) ARR_DATETIME_HIDDEN
, SUBSTR(MST_GEOCODING.GET_TIMEZONE_CODE (WL.WSH_LOCATION_ID
, MST_GEOCODING.GET_LOCAL_TIME (WL.WSH_LOCATION_ID
, TS.PLANNED_ARRIVAL_DATE))
, 1
, 10) ARRIVAL_TIME_ZONE
, SUBSTR(MST_WB_UTIL.GET_LOCAL_CHARDTZONE (WL.WSH_LOCATION_ID
, TS.PLANNED_DEPARTURE_DATE)
, 1
, 80) DEPARTURE_DATE_TIME
, MST_GEOCODING.GET_LOCAL_TIME (WL.WSH_LOCATION_ID
, TS.PLANNED_DEPARTURE_DATE) DEP_DATETIME_HIDDEN
, SUBSTR(MST_GEOCODING.GET_TIMEZONE_CODE (WL.WSH_LOCATION_ID
, MST_GEOCODING.GET_LOCAL_TIME (WL.WSH_LOCATION_ID
, TS.PLANNED_DEPARTURE_DATE))
, 1
, 10) DEPARTURE_TIME_ZONE
, SUBSTR(MST_WB_UTIL.ELAPSED_TIME (TS.PLANNED_ARRIVAL_DATE
, TS.PLANNED_DEPARTURE_DATE)
, 1
, 12) STOP_TIME
, TS.DEPARTURE_GROSS_WEIGHT LOAD_WEIGHT
, TS.DEPARTURE_VOLUME LOAD_CUBE
, TS.DEPARTURE_PALLETS PALLETS
, TS.DEPARTURE_PIECES PIECES
, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, 'D'
, 'W') WEIGHT_UNLOADED
, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, 'D'
, 'V') CUBE_UNLOADED
, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, 'D'
, 'P') PALLETS_UNLOADED
, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, 'D'
, 'PC') PIECES_UNLOADED
, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, 'O'
, 'W') WEIGHT_LOADED
, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, 'O'
, 'V') CUBE_LOADED
, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, 'O'
, 'P') PALLETS_LOADED
, MST_WB_UTIL.GET_TRIP_DET (TS.PLAN_ID
, TS.TRIP_ID
, TS.STOP_ID
, 'O'
, 'PC') PIECES_LOADED
, MP.WEIGHT_UOM
, MP.VOLUME_UOM
FROM MST_PLANS MP
, MST_TRIPS T
, MST_TRIP_STOPS TS
, WSH_LOCATIONS WL
, FTE_LOCATION_PARAMETERS LP
WHERE MP.PLAN_ID = T.PLAN_ID
AND T.PLAN_ID = TS.PLAN_ID
AND T.TRIP_ID = TS.TRIP_ID
AND T.MODE_OF_TRANSPORT = 'TRUCK'
AND WL.WSH_LOCATION_ID = TS.STOP_LOCATION_ID
AND WL.WSH_LOCATION_ID = LP.LOCATION_ID