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.AMS_EVENTSCHEDULE_COPY_PVT dependencies on AMS_AGENDAS_TL

Line 560: FROM ams_agendas_b b, ams_agendas_tl tl--ams_agendas_v SQL Rep perf fix

556: l_new_ev_duration NUMBER;
557:
558: CURSOR c_track_cur IS
559: SELECT coordinator_id, parent_type,parent_id,agenda_name,description,agenda_type, b.agenda_id --* perf fix
560: FROM ams_agendas_b b, ams_agendas_tl tl--ams_agendas_v SQL Rep perf fix
561: WHERE b.agenda_id = tl.agenda_id
562: AND tl.language = USERENV('LANG')
563: AND parent_id = p_src_act_id
564: AND agenda_type = 'TRACK'

Line 570: FROM ams_agendas_b b, ams_agendas_tl tl --ams_agendas_v SQL Rep Perf Fix

566:
567: CURSOR c_session_cur(p_track_id NUMBER) IS
568: SELECT coordinator_id,parent_type,parent_id,agenda_name,description,agenda_type,b.agenda_id,
569: start_date_time, end_date_time
570: FROM ams_agendas_b b, ams_agendas_tl tl --ams_agendas_v SQL Rep Perf Fix
571: WHERE b.agenda_id = tl.agenda_id
572: AND tl.language = USERENV('LANG')
573: AND parent_id = p_track_id
574: AND agenda_type = 'SESSION'