APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_PAGE_SUMM

Line 423: FROM JTF_PF_PAGE_SUMM

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
425: SELECT max(day) AS day
426: FROM JTF_PF_SESSION_SUMM
427: UNION ALL

Line 441: DELETE FROM JTF_PF_PAGE_SUMM

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;
443:
444: DELETE FROM JTF_PF_SESSION_SUMM
445: WHERE (sessionid IS NULL and day >= last_migrate_day)

Line 476: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages,

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)
479: (SELECT day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses,
480: ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, sum_exect, sum_thinkt,

Line 482: FROM JTF_PF_PAGE_SUMMARY_VL);

478: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward)
479: (SELECT day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses,
480: ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, sum_exect, sum_thinkt,
481: cnt_thinkt, startt, endt, cnt_fail, cnt_forward
482: FROM JTF_PF_PAGE_SUMMARY_VL);
483:
484: INSERT INTO JTF_PF_SESSION_SUMM (day, seqid, sessionid, user_name, userid,
485: sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf,
486: sum_thinkt_oaf, sum_thinkt_form, cnt_pages_jtf, cnt_pages_oaf,

Line 533: INSERT INTO JTF_PF_PAGE_SUMM (day, pagename, tech_stack, cnt_pages,

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,
535: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward)
536: (SELECT day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses,
537: ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, sum_exect, sum_thinkt,

Line 539: FROM JTF_PF_PAGE_SUMMARY_VL

535: sum_exect, sum_thinkt, cnt_thinkt, startt, endt, cnt_fail, cnt_forward)
536: (SELECT day, pagename, tech_stack, cnt_pages, cnt_ses, ucnt_ses,
537: ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, sum_exect, sum_thinkt,
538: cnt_thinkt, startt, endt, cnt_fail, cnt_forward
539: FROM JTF_PF_PAGE_SUMMARY_VL
540: WHERE day >= last_migrate_day);
541:
542: INSERT INTO JTF_PF_SESSION_SUMM (day, seqid, sessionid, user_name, userid,
543: sum_exect_jtf, sum_exect_oaf, sum_exect_form, sum_thinkt_jtf,

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

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;
1027: END;