APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_HOST_SUMMARY_VL

Line 354: FROM JTF_PF_HOST_SUMMARY_VL

350: FROM JTF_PF_APP_SUMMARY_VL
351: );
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,

Line 387: FROM JTF_PF_HOST_SUMMARY_VL

383: WHERE day >= last_migrate_day
384: );
385: 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)
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)