APPS.RRS_SITE_INFO dependencies on FND_TERRITORIES_VL

Line 183: country_name fnd_territories_vl.territory_short_name%Type,

179: state hz_locations.state%TYPE,
180: province hz_locations.province%TYPE,
181: postal_code hz_locations.postal_code%TYPE,
182: country hz_locations.country%TYPE,
183: country_name fnd_territories_vl.territory_short_name%Type,
184: address varchar2(1000),
185: identifying_address_flag hz_party_sites.identifying_address_flag%Type
186: );
187: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;

Line 307: ,FND_TERRITORIES_VL FTV

303: 'Y' as IDENTIFYING_ADDRESS_FLAG
304: Bulk Collect
305: INTO l_site_address_details
306: FROM HZ_LOCATIONS
307: ,FND_TERRITORIES_VL FTV
308: WHERE COUNTRY = FTV.TERRITORY_CODE
309: AND LOCATION_ID = l_location_id;
310: */
311:

Line 328: ,FND_TERRITORIES_VL FTV

324: 'Y' as IDENTIFYING_ADDRESS_FLAG
325: Bulk Collect
326: INTO l_site_address_details
327: FROM HZ_LOCATIONS
328: ,FND_TERRITORIES_VL FTV
329: WHERE COUNTRY = FTV.TERRITORY_CODE
330: AND LOCATION_ID = l_location_id;
331:
332:

Line 1579: country_name fnd_territories_vl.territory_short_name%Type,

1575: state hz_locations.state%TYPE,
1576: province hz_locations.province%TYPE,
1577: postal_code hz_locations.postal_code%TYPE,
1578: country hz_locations.country%TYPE,
1579: country_name fnd_territories_vl.territory_short_name%Type,
1580: address varchar2(1000),
1581: identifying_address_flag hz_party_sites.identifying_address_flag%Type
1582: );
1583: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;

Line 1727: ,FND_TERRITORIES_VL FTV

1723: HPS.IDENTIFYING_ADDRESS_FLAG
1724: BULK COLLECT
1725: INTO l_site_party_dets
1726: FROM HZ_LOCATIONS HL
1727: ,FND_TERRITORIES_VL FTV
1728: ,HZ_PARTY_SITES HPS
1729: WHERE COUNTRY = FTV.TERRITORY_CODE
1730: AND HL.LOCATION_ID = HPS.LOCATION_ID
1731: AND HPS.PARTY_ID = l_site_party_id;

Line 1751: ,FND_TERRITORIES_VL FTV

1747: HPS.IDENTIFYING_ADDRESS_FLAG
1748: BULK COLLECT
1749: INTO l_site_party_dets
1750: FROM HZ_LOCATIONS HL
1751: ,FND_TERRITORIES_VL FTV
1752: ,HZ_PARTY_SITES HPS
1753: WHERE COUNTRY = FTV.TERRITORY_CODE
1754: AND HL.LOCATION_ID = HPS.LOCATION_ID
1755: AND HPS.PARTY_ID = l_site_party_id;