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.JTF_TERR_RPT dependencies on ICX_SESSIONS

Line 33: where session_id in (select session_id from APPS.icx_sessions

29: PROCEDURE cleanup
30: as
31: begin
32: delete from jtf.jtf_tae_rpt_staging_out
33: where session_id in (select session_id from APPS.icx_sessions
34: where disabled_flag <> 'N');
35:
36: delete from APPS.jtf_tae_rpt_staging_out
37: where session_id not in (select session_id from APPS.icx_sessions);

Line 37: where session_id not in (select session_id from APPS.icx_sessions);

33: where session_id in (select session_id from APPS.icx_sessions
34: where disabled_flag <> 'N');
35:
36: delete from APPS.jtf_tae_rpt_staging_out
37: where session_id not in (select session_id from APPS.icx_sessions);
38:
39: commit;
40:
41: end cleanup;