APPS.IBW_OE_PVT dependencies on JTF_PF_WA_INFO_VL

Line 66: FROM jtf_pf_wa_info_vl pat

62:
63:
64: CURSOR pat_cursor IS
65: SELECT MAX (pat.last_update_date) AS patdate, pat.track_purpose
66: FROM jtf_pf_wa_info_vl pat
67: GROUP BY pat.track_purpose;
68:
69:
70: CURSOR tmp_page_views_instances IS

Line 823: FROM jtf_pf_wa_info_vl pat

819: , NVL ( pat.userid, l_guest_user_id ) AS user_id -- Make all numm user id value as guest user id
820: , pat.attribute3 AS guid
821: , pat.attribute10 AS attribute10
822: ,pat.last_update_date as pat_last_update_date
823: FROM jtf_pf_wa_info_vl pat
824: , ibe_msites_b sites1
825: , ibe_msites_b sites2
826: , ams_source_codes camptab
827: , fnd_user usertab1

Line 1130: FROM jtf_pf_wa_info_vl pat

1126: , l_guest_party_id ) AS party_id -- Get correct party id for b2b or b2c user if he is not guest user.
1127: , DECODE(pat.attribute16,'I',usertab1.customer_id,usertab2.customer_id) AS customer_id
1128: , pat.attribute3 guid
1129: ,pat.last_update_date as pat_last_update_date
1130: FROM jtf_pf_wa_info_vl pat
1131: , ibe_msites_b sites1
1132: , ibe_msites_b sites2
1133: , fnd_user usertab1
1134: , fnd_user usertab2

Line 1750: FROM jtf_pf_wa_info_vl;

1746:
1747: IF l_pat_date IS NULL THEN
1748: SELECT Min(last_update_date)
1749: INTO l_pat_date
1750: FROM jtf_pf_wa_info_vl;
1751: printLog('Got Pat date from Pat'||l_pat_date);
1752: END IF;
1753:
1754: IF l_pat_date IS NOT NULL THEN