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.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on WSH_TRIP_STOPS

Line 379: from wsh_trip_stops wts_tmp where actual_departure_date > g_global_start_date) idl,

375: wts.stop_sequence_number STOP_SEQUENCE_NUMBER,
376: wt.trip_id TRIP_ID,
377: max(wts.stop_sequence_number) over (partition by wt.trip_id) ULTIMATE_STOP_SEQUENCE_NUMBER
378: FROM (select /*+ PARALLEL(wts_tmp) */ distinct trip_id
379: from wsh_trip_stops wts_tmp where actual_departure_date > g_global_start_date) idl,
380: wsh_trips wt,
381: wsh_trip_stops wts
382: WHERE idl.trip_id = wt.trip_id
383: AND wt.trip_id = wts.trip_id

Line 381: wsh_trip_stops wts

377: max(wts.stop_sequence_number) over (partition by wt.trip_id) ULTIMATE_STOP_SEQUENCE_NUMBER
378: FROM (select /*+ PARALLEL(wts_tmp) */ distinct trip_id
379: from wsh_trip_stops wts_tmp where actual_departure_date > g_global_start_date) idl,
380: wsh_trips wt,
381: wsh_trip_stops wts
382: WHERE idl.trip_id = wt.trip_id
383: AND wt.trip_id = wts.trip_id
384: AND wt.status_code IN ('IT', 'CL')
385: AND wts.physical_stop_id IS NULL

Line 820: WHERE NOT EXISTS (select '1' from wsh_trip_stops wts, wsh_trips wt

816:
817: DELETE FROM isc_dbi_trip_stops_f
818: WHERE stop_id IN (SELECT DISTINCT log.stop_id
819: FROM isc_dbi_tmp_wts_log log
820: WHERE NOT EXISTS (select '1' from wsh_trip_stops wts, wsh_trips wt
821: where log.stop_id = wts.stop_id
822: and wts.trip_id = wt.trip_id
823: and wt.status_code IN ('IT', 'CL')));
824:

Line 865: from isc_dbi_tmp_wts_log tmp, wsh_trip_stops tr

861: wts.stop_sequence_number STOP_SEQUENCE_NUMBER,
862: wt.trip_id TRIP_ID,
863: max(wts.stop_sequence_number) over (partition by wt.trip_id) ULTIMATE_STOP_SEQUENCE_NUMBER
864: FROM (select /*+ no_merge index(tr) */ distinct tr.trip_id
865: from isc_dbi_tmp_wts_log tmp, wsh_trip_stops tr
866: where tmp.stop_id = tr.stop_id) log,
867: wsh_trips wt,
868: wsh_trip_stops wts
869: WHERE log.trip_id = wt.trip_id

Line 868: wsh_trip_stops wts

864: FROM (select /*+ no_merge index(tr) */ distinct tr.trip_id
865: from isc_dbi_tmp_wts_log tmp, wsh_trip_stops tr
866: where tmp.stop_id = tr.stop_id) log,
867: wsh_trips wt,
868: wsh_trip_stops wts
869: WHERE log.trip_id = wt.trip_id
870: AND wt.trip_id = wts.trip_id
871: AND wt.status_code IN ('IT', 'CL')
872: AND wts.physical_stop_id IS NULL