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_HOST_SUMM

Line 420: FROM JTF_PF_HOST_SUMM

416: FROM (SELECT max(day) AS day
417: FROM JTF_PF_APP_SUMM
418: UNION ALL
419: SELECT max(day) AS day
420: FROM JTF_PF_HOST_SUMM
421: UNION ALL
422: SELECT max(day) AS day
423: FROM JTF_PF_PAGE_SUMM
424: UNION ALL

Line 438: DELETE FROM JTF_PF_HOST_SUMM

434: --DELETE FROM JTF_PF_SES_ACTIVITY WHERE day < last_migrate_day;
435: DELETE FROM JTF_PF_APP_SUMM
436: WHERE day >= last_migrate_day;
437:
438: DELETE FROM JTF_PF_HOST_SUMM
439: WHERE day >= last_migrate_day;
440:
441: DELETE FROM JTF_PF_PAGE_SUMM
442: WHERE day >= last_migrate_day;

Line 468: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs,

464: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, cnt_flows, cnt_users,
465: cnt_apps, cnt_resps, cnt_sessions, cnt_langs
466: FROM JTF_PF_APP_SUMMARY_VL);
467:
468: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs,
469: sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_all,
470: fails, pages, badpages)
471: (SELECT day, NVL(servername, 'N/A'), NVL(serverport, -1), jservs,
472: sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf,

Line 474: FROM JTF_PF_HOST_SUMMARY_VL);

470: fails, pages, badpages)
471: (SELECT day, NVL(servername, 'N/A'), NVL(serverport, -1), jservs,
472: sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf,
473: pagehits_jtf+pagehits_oaf, fails, pages, badpages
474: FROM JTF_PF_HOST_SUMMARY_VL);
475:
476: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages,
477: cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,
478: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward)

Line 524: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs,

520: cnt_apps, cnt_resps, cnt_sessions, cnt_langs
521: FROM JTF_PF_APP_SUMMARY_VL
522: WHERE day >= last_migrate_day);
523:
524: INSERT INTO JTF_PF_HOST_SUMM (day, servername, serverport, jservs,
525: sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf, pagehits_all,
526: fails, pages, badpages)
527: (SELECT day, NVL(servername, 'N/A'), NVL(serverport, -1), jservs,
528: sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf,

Line 530: FROM JTF_PF_HOST_SUMMARY_VL

526: fails, pages, badpages)
527: (SELECT day, NVL(servername, 'N/A'), NVL(serverport, -1), jservs,
528: sum_exect_jtf, sum_exect_oaf, pagehits_jtf, pagehits_oaf,
529: pagehits_jtf+pagehits_oaf, fails, pages, badpages
530: FROM JTF_PF_HOST_SUMMARY_VL
531: WHERE day >= last_migrate_day);
532:
533: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages,
534: cnt_ses, ucnt_ses, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs,

Line 1022: DELETE FROM JTF_PF_HOST_SUMM WHERE DAY <= START_DATE;

1018:
1019: DELETE FROM JTF_PF_SES_ACTIVITY WHERE DAY <= START_DATE;
1020: DELETE FROM JTF_PF_ANON_ACTIVITY WHERE DAY <= START_DATE;
1021: DELETE FROM JTF_PF_APP_SUMM WHERE DAY <= START_DATE;
1022: DELETE FROM JTF_PF_HOST_SUMM WHERE DAY <= START_DATE;
1023: DELETE FROM JTF_PF_PAGE_SUMM WHERE DAY <= START_DATE;
1024: DELETE FROM JTF_PF_SESSION_SUMM WHERE DAY <= START_DATE;
1025: DELETE FROM JTF_PF_USER_SUMM WHERE DAY <= START_DATE;
1026: COMMIT;