eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_SITE_INFO dependencies on FND_TERRITORIES_VL

Line 187: country_name fnd_territories_vl.territory_short_name%Type,

183: state hz_locations.state%TYPE,
184: province hz_locations.province%TYPE,
185: postal_code hz_locations.postal_code%TYPE,
186: country hz_locations.country%TYPE,
187: country_name fnd_territories_vl.territory_short_name%Type,
188: address varchar2(1000),
189: identifying_address_flag hz_party_sites.identifying_address_flag%Type,
190: geometry_source hz_locations.geometry_source%Type,
191: geometry_source_meaning rrs_lookups_v.meaning%Type,

Line 315: ,FND_TERRITORIES_VL FTV

311: 'Y' as IDENTIFYING_ADDRESS_FLAG
312: Bulk Collect
313: INTO l_site_address_details
314: FROM HZ_LOCATIONS
315: ,FND_TERRITORIES_VL FTV
316: WHERE COUNTRY = FTV.TERRITORY_CODE
317: AND LOCATION_ID = l_location_id;
318: */
319:

Line 341: ,FND_TERRITORIES_VL FTV

337: ROUND(HL.geometry.SDO_POINT.Y,8) Latitude
338: Bulk Collect
339: INTO l_site_address_details
340: FROM HZ_LOCATIONS HL
341: ,FND_TERRITORIES_VL FTV
342: WHERE HL.COUNTRY = FTV.TERRITORY_CODE
343: AND HL.LOCATION_ID = l_location_id;
344:
345:

Line 1646: country_name fnd_territories_vl.territory_short_name%Type,

1642: state hz_locations.state%TYPE,
1643: province hz_locations.province%TYPE,
1644: postal_code hz_locations.postal_code%TYPE,
1645: country hz_locations.country%TYPE,
1646: country_name fnd_territories_vl.territory_short_name%Type,
1647: address varchar2(1000),
1648: identifying_address_flag hz_party_sites.identifying_address_flag%Type,
1649: site_purpose ar_lookups.meaning%type --Bug 7871825
1650: );

Line 1796: ,FND_TERRITORIES_VL FTV

1792: HPS.IDENTIFYING_ADDRESS_FLAG
1793: BULK COLLECT
1794: INTO l_site_party_dets
1795: FROM HZ_LOCATIONS HL
1796: ,FND_TERRITORIES_VL FTV
1797: ,HZ_PARTY_SITES HPS
1798: WHERE COUNTRY = FTV.TERRITORY_CODE
1799: AND HL.LOCATION_ID = HPS.LOCATION_ID
1800: AND HPS.PARTY_ID = l_site_party_id;

Line 1823: ,FND_TERRITORIES_VL FTV

1819: AND AL.LOOKUP_CODE = PSU.SITE_USE_TYPE ) site_purpose
1820: BULK COLLECT
1821: INTO l_site_party_dets
1822: FROM HZ_LOCATIONS HL
1823: ,FND_TERRITORIES_VL FTV
1824: ,HZ_PARTY_SITES HPS
1825: , HZ_PARTY_SITE_USES PSU
1826: WHERE COUNTRY = FTV.TERRITORY_CODE
1827: AND HL.LOCATION_ID = HPS.LOCATION_ID