1175: || ftv.territory_short_name
1176: AS part3
1177: FROM hr_locations hrl,
1178: fnd_territories_vl ftv,
1179: fnd_lookup_values_vl flv1,
1180: fnd_lookup_values_vl flv2,
1181: fnd_lookup_values_vl flv3
1182: WHERE hrl.region_1 = flv1.lookup_code (+) and
1183: hrl.country || '_PROVINCE' = flv1.lookup_type (+) and
1176: AS part3
1177: FROM hr_locations hrl,
1178: fnd_territories_vl ftv,
1179: fnd_lookup_values_vl flv1,
1180: fnd_lookup_values_vl flv2,
1181: fnd_lookup_values_vl flv3
1182: WHERE hrl.region_1 = flv1.lookup_code (+) and
1183: hrl.country || '_PROVINCE' = flv1.lookup_type (+) and
1184: hrl.region_2 = flv2.lookup_code (+) and
1177: FROM hr_locations hrl,
1178: fnd_territories_vl ftv,
1179: fnd_lookup_values_vl flv1,
1180: fnd_lookup_values_vl flv2,
1181: fnd_lookup_values_vl flv3
1182: WHERE hrl.region_1 = flv1.lookup_code (+) and
1183: hrl.country || '_PROVINCE' = flv1.lookup_type (+) and
1184: hrl.region_2 = flv2.lookup_code (+) and
1185: hrl.country || '_STATE' = flv2.lookup_type (+) and