APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_SESSION_SUMMARY_VL

Line 366: FROM JTF_PF_SESSION_SUMMARY_VL

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,
365: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
366: FROM JTF_PF_SESSION_SUMMARY_VL
367: WHERE (sessionid IS NULL )
368: or (sessionid IS NOT NULL and sessionid IN
369: (select distinct sessionid from JTF_PF_SES_ACTIVITY))
370: );

Line 401: FROM JTF_PF_SESSION_SUMMARY_VL

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)
399: (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,
400: cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form, cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows, ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
401: FROM JTF_PF_SESSION_SUMMARY_VL
402: WHERE (sessionid IS NULL and day >= last_migrate_day)
403: or (sessionid IS NOT NULL and sessionid IN
404: (select distinct sessionid from JTF_PF_SES_ACTIVITY where day >= last_migrate_day ))
405: );