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
828: , fnd_user usertab2
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
828: , fnd_user usertab2
829: , hz_relationships rel2
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
1135: , hz_relationships rel1
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
1135: , hz_relationships rel1
1136: , hz_relationships rel2