825: , ibe_msites_b sites2
826: , ams_source_codes camptab
827: , fnd_user usertab1
828: , fnd_user usertab2
829: , hz_relationships rel2
830: , hz_relationships rel1
831: WHERE pat.last_update_date > l_pat_date -- Consider only records logged after the last puged date
832: AND pat.attribute11 = 'true' -- Consider only display pages
833: AND sites1.msite_id(+) = DECODE(pat.attribute16,'I',pat.attribute7,-1)
826: , ams_source_codes camptab
827: , fnd_user usertab1
828: , fnd_user usertab2
829: , hz_relationships rel2
830: , hz_relationships rel1
831: WHERE pat.last_update_date > l_pat_date -- Consider only records logged after the last puged date
832: AND pat.attribute11 = 'true' -- Consider only display pages
833: AND sites1.msite_id(+) = DECODE(pat.attribute16,'I',pat.attribute7,-1)
834: AND sites2.access_name(+) = DECODE(pat.attribute16,'E',pat.attribute7,NULL)
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
1137: WHERE pat.attribute11 = 'false'
1138: AND pat.last_update_date > l_pat_date
1139: AND sites1.msite_id(+) = DECODE(pat.attribute16,'I',pat.attribute7,-1)
1132: , ibe_msites_b sites2
1133: , fnd_user usertab1
1134: , fnd_user usertab2
1135: , hz_relationships rel1
1136: , hz_relationships rel2
1137: WHERE pat.attribute11 = 'false'
1138: AND pat.last_update_date > l_pat_date
1139: AND sites1.msite_id(+) = DECODE(pat.attribute16,'I',pat.attribute7,-1)
1140: AND sites2.access_name(+) = DECODE(pat.attribute16,'E',pat.attribute7,NULL)