1406: decode(hrl.postal_code, null, '', hrl.postal_code || ', ')
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