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_PF_SOA_MIGRATE_PKG dependencies on ICX_SESSIONS

Line 31: FROM fnd_logins f, icx_sessions i

27: NVL(i.responsibility_application_id, -1), NVL(i.responsibility_id, -1), NVL(i.language_code, -1), NVL(i.proxy_user_id, -1),
28: (trunc( (f.start_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
29: 'AUDIT', 'LOGIN', 200, 0, -1, 1, (f.end_time - f.start_time) * 86400 * 1000 thinkt,
30: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id, 'N/A', -1
31: FROM fnd_logins f, icx_sessions i
32: WHERE f.login_id = i.login_id
33: AND (maxstartt IS NULL
34: OR f.start_time > maxstartt
35: OR (f.start_time = maxstartt AND f.user_id NOT IN (SELECT userid FROM jtf_pf_ses_activity WHERE tech_stack='AUDIT' AND pagename='LOGIN' AND timestamp=maxstartt and day= maxstartt)))

Line 60: FROM fnd_logins f, icx_sessions i

56: NVL(i.responsibility_application_id, -1), NVL(i.responsibility_id, -1), NVL(i.language_code, -1), NVL(i.proxy_user_id, -1),
57: (trunc( (end_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
58: 'AUDIT', 'LOGOUT', 200, 0, -1, 1, fnd_global.user_id,
59: sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id
60: FROM fnd_logins f, icx_sessions i
61: WHERE f.login_id = i.login_id
62: AND f.end_time IS NOT NULL
63: AND (maxendt IS NULL
64: OR f.end_time > maxendt

Line 101: FROM fnd_login_responsibilities r, icx_sessions i

97: (trunc( (r.start_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
98: 'AUDIT', 'RESP_CHANGE', 200, 0, (r.end_time - r.start_time) * 86400 * 1000 thinkt,
99: -1, 1, fnd_global.user_id, sysdate, fnd_global.user_id,
100: sysdate, fnd_global.conc_login_id
101: FROM fnd_login_responsibilities r, icx_sessions i
102: WHERE r.login_id = i.login_id
103: AND (maxtimestamp IS NULL
104: OR r.start_time > maxtimestamp
105: OR (r.start_time = maxtimestamp AND r.responsibility_id NOT IN

Line 137: FROM fnd_login_resp_forms f, icx_sessions i, fnd_login_responsibilities r

133: i.session_id, i.user_id, f.form_appl_id, r.responsibility_id, NVL(i.language_code, -1),NVL(i.proxy_user_id, -1),
134: (trunc( (f.start_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
135: 'FORM', to_char(f.form_id), 200, 0, (f.end_time - f.start_time) * 86400 * 1000 thinkt, -1, 1,
136: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id
137: FROM fnd_login_resp_forms f, icx_sessions i, fnd_login_responsibilities r
138: WHERE f.login_id = i.login_id
139: AND r.login_resp_id = f.login_resp_id
140: AND (maxtimestamp IS NULL
141: OR f.start_time > maxtimestamp