1407: || ftv.territory_short_name
1408: AS part3
1409: FROM hr_locations hrl,
1410: fnd_territories_vl ftv,
1411: fnd_lookup_values_vl flv1,
1412: fnd_lookup_values_vl flv2,
1413: fnd_lookup_values_vl flv3
1414: WHERE hrl.region_1 = flv1.lookup_code (+) and
1415: hrl.country || '_PROVINCE' = flv1.lookup_type (+) and
1408: AS part3
1409: FROM hr_locations hrl,
1410: fnd_territories_vl ftv,
1411: fnd_lookup_values_vl flv1,
1412: fnd_lookup_values_vl flv2,
1413: fnd_lookup_values_vl flv3
1414: WHERE hrl.region_1 = flv1.lookup_code (+) and
1415: hrl.country || '_PROVINCE' = flv1.lookup_type (+) and
1416: hrl.region_2 = flv2.lookup_code (+) and
1409: FROM hr_locations hrl,
1410: fnd_territories_vl ftv,
1411: fnd_lookup_values_vl flv1,
1412: fnd_lookup_values_vl flv2,
1413: fnd_lookup_values_vl flv3
1414: WHERE hrl.region_1 = flv1.lookup_code (+) and
1415: hrl.country || '_PROVINCE' = flv1.lookup_type (+) and
1416: hrl.region_2 = flv2.lookup_code (+) and
1417: hrl.country || '_STATE' = flv2.lookup_type (+) and