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_CONV_PKG dependencies on JTF_PF_SESSION_SUMM

Line 329: SELECT max(day) AS day FROM JTF_PF_SESSION_SUMM

325: SELECT max(day) AS day FROM JTF_PF_HOST_SUMM
326: UNION ALL
327: SELECT max(day) AS day FROM JTF_PF_PAGE_SUMM
328: UNION ALL
329: SELECT max(day) AS day FROM JTF_PF_SESSION_SUMM
330: UNION ALL
331: SELECT max(day) AS day FROM JTF_PF_USER_SUMM
332: ) x;
333: END IF;

Line 340: DELETE FROM JTF_PF_SESSION_SUMM WHERE (sessionid IS NULL and day >= last_migrate_day)

336: --DELETE FROM JTF_PF_SES_ACTIVITY WHERE day < last_migrate_day;
337: DELETE FROM JTF_PF_APP_SUMM WHERE day >= last_migrate_day;
338: DELETE FROM JTF_PF_HOST_SUMM WHERE day >= last_migrate_day;
339: DELETE FROM JTF_PF_PAGE_SUMM WHERE day >= last_migrate_day;
340: DELETE FROM JTF_PF_SESSION_SUMM WHERE (sessionid IS NULL and day >= last_migrate_day)
341: or (sessionid IS NOT NULL and sessionid IN
342: (select distinct sessionid from JTF_PF_SES_ACTIVITY where day >= last_migrate_day OR last_migrate_day IS NULL));
343: DELETE FROM JTF_PF_USER_SUMM WHERE day >= last_migrate_day;
344: END IF;

Line 362: INSERT INTO JTF_PF_SESSION_SUMM (day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,

358: (SELECT day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,
359: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward
360: FROM JTF_PF_PAGE_SUMMARY_VL
361: );
362: INSERT INTO JTF_PF_SESSION_SUMM (day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
363: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail)
364: (SELECT day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
365: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
366: FROM JTF_PF_SESSION_SUMMARY_VL

Line 366: FROM JTF_PF_SESSION_SUMMARY_VL

362: INSERT INTO JTF_PF_SESSION_SUMM (day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
363: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail)
364: (SELECT day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
365: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
366: FROM JTF_PF_SESSION_SUMMARY_VL
367: WHERE (sessionid IS NULL )
368: or (sessionid IS NOT NULL and sessionid IN
369: (select distinct sessionid from JTF_PF_SES_ACTIVITY))
370: );

Line 397: INSERT INTO JTF_PF_SESSION_SUMM (day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,

393: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward
394: FROM JTF_PF_PAGE_SUMMARY_VL
395: WHERE day >= last_migrate_day
396: );
397: INSERT INTO JTF_PF_SESSION_SUMM (day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
398: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail)
399: (SELECT day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
400: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
401: FROM JTF_PF_SESSION_SUMMARY_VL

Line 401: FROM JTF_PF_SESSION_SUMMARY_VL

397: INSERT INTO JTF_PF_SESSION_SUMM (day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
398: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_all, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail)
399: (SELECT day, seqid, sessionid, user_name, userid, sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf, sum_thinkt_form,
400: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
401: FROM JTF_PF_SESSION_SUMMARY_VL
402: WHERE (sessionid IS NULL and day >= last_migrate_day)
403: or (sessionid IS NOT NULL and sessionid IN
404: (select distinct sessionid from JTF_PF_SES_ACTIVITY where day >= last_migrate_day ))
405: );

Line 767: DELETE FROM JTF_PF_SESSION_SUMM WHERE DAY <= START_DATE;

763: DELETE FROM JTF_PF_ANON_ACTIVITY WHERE DAY <= START_DATE;
764: DELETE FROM JTF_PF_APP_SUMM WHERE DAY <= START_DATE;
765: DELETE FROM JTF_PF_HOST_SUMM WHERE DAY <= START_DATE;
766: DELETE FROM JTF_PF_PAGE_SUMM WHERE DAY <= START_DATE;
767: DELETE FROM JTF_PF_SESSION_SUMM WHERE DAY <= START_DATE;
768: DELETE FROM JTF_PF_USER_SUMM WHERE DAY <= START_DATE;
769: COMMIT;
770: END;
771: