DBA Data[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_HOST_SUMMARY_VL

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 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,