1840: x_telephone_3,
1841: x_partner_id_x
1842: FROM hr_locations_all hrl,
1843: --fnd_territories_vl ftv,
1844: fnd_lookup_values_vl flv1,
1845: fnd_lookup_values_vl flv2,
1846: fnd_lookup_values_vl flv3
1847: where
1848: hrl.region_1 = flv1.lookup_code (+) and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
1841: x_partner_id_x
1842: FROM hr_locations_all hrl,
1843: --fnd_territories_vl ftv,
1844: fnd_lookup_values_vl flv1,
1845: fnd_lookup_values_vl flv2,
1846: fnd_lookup_values_vl flv3
1847: where
1848: hrl.region_1 = flv1.lookup_code (+) and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
1849: and hrl.region_2 = flv2.lookup_code (+) and hrl.country || '_STATE' = flv2.lookup_type (+)
1842: FROM hr_locations_all hrl,
1843: --fnd_territories_vl ftv,
1844: fnd_lookup_values_vl flv1,
1845: fnd_lookup_values_vl flv2,
1846: fnd_lookup_values_vl flv3
1847: where
1848: hrl.region_1 = flv1.lookup_code (+) and hrl.country || '_PROVINCE' = flv1.lookup_type (+)
1849: and hrl.region_2 = flv2.lookup_code (+) and hrl.country || '_STATE' = flv2.lookup_type (+)
1850: and hrl.region_1 = flv3.lookup_code (+) and hrl.country || '_COUNTY' = flv3.lookup_type (+)