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.

APPS.FTE_MLS_UTIL dependencies on FTE_WSH_TRIPS

Line 176: FROM fte_wsh_trips a, wsh_trips b

172: --{
173: CURSOR check_other_segments_cur
174: IS
175: SELECT 1
176: FROM fte_wsh_trips a, wsh_trips b
177: WHERE a.fte_trip_id = p_trip_id
178: AND a.wsh_trip_id <> p_trip_segment_id
179: AND a.wsh_trip_id = b.trip_id
180: AND b.status_code IN ('OP','IT');

Line 225: FROM fte_wsh_trips

221: --
222: CURSOR get_next_segment_cur
223: IS
224: SELECT wsh_trip_id
225: FROM fte_wsh_trips
226: WHERE fte_trip_id = p_trip_id
227: AND sequence_number = ( select min(sequence_number)
228: from fte_wsh_trips
229: where fte_trip_id = p_trip_id

Line 228: from fte_wsh_trips

224: SELECT wsh_trip_id
225: FROM fte_wsh_trips
226: WHERE fte_trip_id = p_trip_id
227: AND sequence_number = ( select min(sequence_number)
228: from fte_wsh_trips
229: where fte_trip_id = p_trip_id
230: and sequence_number > p_sequence_number );
231: --}
232: BEGIN

Line 338: FROM fte_wsh_trips

334: --
335: CURSOR get_previous_segment_cur
336: IS
337: SELECT wsh_trip_id
338: FROM fte_wsh_trips
339: WHERE fte_trip_id = p_trip_id
340: AND sequence_number = ( select max(sequence_number)
341: from fte_wsh_trips
342: where fte_trip_id = p_trip_id

Line 341: from fte_wsh_trips

337: SELECT wsh_trip_id
338: FROM fte_wsh_trips
339: WHERE fte_trip_id = p_trip_id
340: AND sequence_number = ( select max(sequence_number)
341: from fte_wsh_trips
342: where fte_trip_id = p_trip_id
343: and sequence_number < p_sequence_number );
344: --}
345: BEGIN