DBA Data[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on JTF_PF_SESSION_SUMMARY_VL

Line 494: FROM JTF_PF_SESSION_SUMMARY_VL

490: sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf,
491: sum_thinkt_form, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
492: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows,
493: ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
494: FROM JTF_PF_SESSION_SUMMARY_VL
495: WHERE (sessionid IS NULL )
496: or (sessionid IS NOT NULL
497: and sessionid IN
498: (select distinct sessionid

Line 552: FROM JTF_PF_SESSION_SUMMARY_VL

548: sum_exect_oaf, sum_exect_form, sum_thinkt_jtf, sum_thinkt_oaf,
549: sum_thinkt_form, cnt_pages_jtf, cnt_pages_oaf, cnt_pages_form,
550: cnt_pages_jtf+cnt_pages_oaf+cnt_pages_form, ucnt_pages, ucnt_flows,
551: ucnt_users, ucnt_apps, ucnt_resps, ucnt_langs, startt, endt, cnt_fail
552: FROM JTF_PF_SESSION_SUMMARY_VL
553: WHERE (sessionid IS NULL and day >= last_migrate_day)
554: or (sessionid IS NOT NULL
555: and sessionid IN
556: (select distinct sessionid