[Home] [Help]
847: l.postal_code,
848: l.inactive_date
849: FROM
850: wsh_locations l,
851: fnd_territories_tl t
852: WHERE
853: t.territory_code = l.country and
854: t.language = userenv('LANG') and
855: l.wsh_location_id between p_from_location and p_to_location and
868: l.postal_code,
869: l.inactive_date
870: FROM
871: wsh_locations l,
872: fnd_territories_tl t
873: WHERE
874: t.territory_code = l.country and
875: t.language = userenv('LANG') and
876: l.wsh_location_id between p_from_location and p_to_location and
890: l.location_source_code source,
891: l.inactive_date
892: FROM
893: wsh_locations l,
894: fnd_territories_tl t
895: WHERE
896: t.territory_code = l.country and
897: t.language = userenv('LANG') and
898: l.wsh_location_id between p_from_location and p_to_location and
2449: l_location_id NUMBER;
2450: l_wsh_location_id NUMBER;
2451: l_organization_id NUMBER;
2452: map_region BOOLEAN := FALSE;
2453: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2454: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2455: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2456: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2457: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2450: l_wsh_location_id NUMBER;
2451: l_organization_id NUMBER;
2452: map_region BOOLEAN := FALSE;
2453: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2454: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2455: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2456: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2457: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2458: l_location_source VARCHAR2(4);
2472: l.postal_code,
2473: l.inactive_date
2474: FROM
2475: hr_locations_all l,
2476: fnd_territories_tl t
2477: WHERE
2478: t.territory_code = l.country and
2479: t.language = userenv('LANG') and
2480: l.location_id = p_location_id;