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_ACT_DEAD_STOPS_V

Source

View Text - Preformatted


SELECT mt.plan_id , mt.trip_id , mt.planned_flag , mts.stop_id , mir.in_request_id , mt.trip_number , mt.mode_of_transport , flp.facility_code , wl.address1 , wl.city , wl.state , wl.postal_code , wl.country , mts.stop_sequence_number from mst_trips mt, mst_trip_stops mts, mst_out_requests mor, mst_in_requests mir, fte_location_parameters flp, wsh_locations wl WHERE mir.in_request_id = mor.in_request_id and mir.plan_id = mt.plan_id and mir.trip_id = mt.trip_id and mts.stop_id = mor.trip_stop_id and mts.plan_id = mir.plan_id and mts.trip_id = mir.trip_id and mts.stop_location_id = wl.wsh_location_id and wl.wsh_location_id = flp.location_id

View Text - HTML Formatted

SELECT MT.PLAN_ID
, MT.TRIP_ID
, MT.PLANNED_FLAG
, MTS.STOP_ID
, MIR.IN_REQUEST_ID
, MT.TRIP_NUMBER
, MT.MODE_OF_TRANSPORT
, FLP.FACILITY_CODE
, WL.ADDRESS1
, WL.CITY
, WL.STATE
, WL.POSTAL_CODE
, WL.COUNTRY
, MTS.STOP_SEQUENCE_NUMBER
FROM MST_TRIPS MT
, MST_TRIP_STOPS MTS
, MST_OUT_REQUESTS MOR
, MST_IN_REQUESTS MIR
, FTE_LOCATION_PARAMETERS FLP
, WSH_LOCATIONS WL
WHERE MIR.IN_REQUEST_ID = MOR.IN_REQUEST_ID
AND MIR.PLAN_ID = MT.PLAN_ID
AND MIR.TRIP_ID = MT.TRIP_ID
AND MTS.STOP_ID = MOR.TRIP_STOP_ID
AND MTS.PLAN_ID = MIR.PLAN_ID
AND MTS.TRIP_ID = MIR.TRIP_ID
AND MTS.STOP_LOCATION_ID = WL.WSH_LOCATION_ID
AND WL.WSH_LOCATION_ID = FLP.LOCATION_ID