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_PAGE_SUMM

Line 327: SELECT max(day) AS day FROM JTF_PF_PAGE_SUMM

323: (SELECT max(day) AS day FROM JTF_PF_APP_SUMM
324: UNION ALL
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

Line 339: DELETE FROM JTF_PF_PAGE_SUMM WHERE day >= last_migrate_day;

335: --DELETE FROM JTF_PF_ANON_ACTIVITY WHERE 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;

Line 356: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,

352: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs, sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_all, fails, pages, badpages)
353: (SELECT day, NVL(servername, 'N/A'), NVL(serverport, -1), jservs, sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_jtf+pagehits_oaf, fails, pages, badpages
354: FROM JTF_PF_HOST_SUMMARY_VL
355: );
356: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,
357: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward)
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

Line 360: FROM JTF_PF_PAGE_SUMMARY_VL

356: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,
357: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward)
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,

Line 390: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,

386: (SELECT day, NVL(servername, 'N/A'), NVL(serverport, -1), jservs, sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_jtf+pagehits_oaf, fails, pages, badpages
387: FROM JTF_PF_HOST_SUMMARY_VL
388: WHERE day >= last_migrate_day
389: );
390: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,
391: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward)
392: (SELECT day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,
393: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward
394: FROM JTF_PF_PAGE_SUMMARY_VL

Line 394: FROM JTF_PF_PAGE_SUMMARY_VL

390: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,
391: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward)
392: (SELECT day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,
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)

Line 766: DELETE FROM JTF_PF_PAGE_SUMM WHERE DAY <= START_DATE;

762: DELETE FROM JTF_PF_SES_ACTIVITY 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;