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 HZ_LOCATIONS

Line 177: address1 hz_locations.address1%TYPE,

173: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
174: l_site_header_details local_rrs_site_header_tab;
175:
176: TYPE local_rrs_site_address_rec is RECORD (
177: address1 hz_locations.address1%TYPE,
178: address2 hz_locations.address2%TYPE,
179: address3 hz_locations.address3%TYPE,
180: address4 hz_locations.address4%TYPE,
181: city hz_locations.city%TYPE,

Line 178: address2 hz_locations.address2%TYPE,

174: l_site_header_details local_rrs_site_header_tab;
175:
176: TYPE local_rrs_site_address_rec is RECORD (
177: address1 hz_locations.address1%TYPE,
178: address2 hz_locations.address2%TYPE,
179: address3 hz_locations.address3%TYPE,
180: address4 hz_locations.address4%TYPE,
181: city hz_locations.city%TYPE,
182: county hz_locations.county%TYPE,

Line 179: address3 hz_locations.address3%TYPE,

175:
176: TYPE local_rrs_site_address_rec is RECORD (
177: address1 hz_locations.address1%TYPE,
178: address2 hz_locations.address2%TYPE,
179: address3 hz_locations.address3%TYPE,
180: address4 hz_locations.address4%TYPE,
181: city hz_locations.city%TYPE,
182: county hz_locations.county%TYPE,
183: state hz_locations.state%TYPE,

Line 180: address4 hz_locations.address4%TYPE,

176: TYPE local_rrs_site_address_rec is RECORD (
177: address1 hz_locations.address1%TYPE,
178: address2 hz_locations.address2%TYPE,
179: address3 hz_locations.address3%TYPE,
180: address4 hz_locations.address4%TYPE,
181: city hz_locations.city%TYPE,
182: county hz_locations.county%TYPE,
183: state hz_locations.state%TYPE,
184: province hz_locations.province%TYPE,

Line 181: city hz_locations.city%TYPE,

177: address1 hz_locations.address1%TYPE,
178: address2 hz_locations.address2%TYPE,
179: address3 hz_locations.address3%TYPE,
180: address4 hz_locations.address4%TYPE,
181: city hz_locations.city%TYPE,
182: county hz_locations.county%TYPE,
183: state hz_locations.state%TYPE,
184: province hz_locations.province%TYPE,
185: postal_code hz_locations.postal_code%TYPE,

Line 182: county hz_locations.county%TYPE,

178: address2 hz_locations.address2%TYPE,
179: address3 hz_locations.address3%TYPE,
180: address4 hz_locations.address4%TYPE,
181: city hz_locations.city%TYPE,
182: county hz_locations.county%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,

Line 183: state hz_locations.state%TYPE,

179: address3 hz_locations.address3%TYPE,
180: address4 hz_locations.address4%TYPE,
181: city hz_locations.city%TYPE,
182: county hz_locations.county%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,

Line 184: province hz_locations.province%TYPE,

180: address4 hz_locations.address4%TYPE,
181: city hz_locations.city%TYPE,
182: county hz_locations.county%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),

Line 185: postal_code hz_locations.postal_code%TYPE,

181: city hz_locations.city%TYPE,
182: county hz_locations.county%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,

Line 186: country hz_locations.country%TYPE,

182: county hz_locations.county%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,

Line 190: geometry_source hz_locations.geometry_source%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,
192: longitude number,
193: latitude number
194: );

Line 314: FROM HZ_LOCATIONS

310: HZ_FORMAT_PUB.format_address(location_id, null, null, ',' , null) as Address,
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: */

Line 340: FROM HZ_LOCATIONS HL

336: ROUND(HL.geometry.SDO_POINT.X,8) Longitude,
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:

Line 1636: address1 hz_locations.address1%TYPE,

1632: l_site_party_id number;
1633:
1634:
1635: TYPE local_rrs_site_address_rec is RECORD (
1636: address1 hz_locations.address1%TYPE,
1637: address2 hz_locations.address2%TYPE,
1638: address3 hz_locations.address3%TYPE,
1639: address4 hz_locations.address4%TYPE,
1640: city hz_locations.city%TYPE,

Line 1637: address2 hz_locations.address2%TYPE,

1633:
1634:
1635: TYPE local_rrs_site_address_rec is RECORD (
1636: address1 hz_locations.address1%TYPE,
1637: address2 hz_locations.address2%TYPE,
1638: address3 hz_locations.address3%TYPE,
1639: address4 hz_locations.address4%TYPE,
1640: city hz_locations.city%TYPE,
1641: county hz_locations.county%TYPE,

Line 1638: address3 hz_locations.address3%TYPE,

1634:
1635: TYPE local_rrs_site_address_rec is RECORD (
1636: address1 hz_locations.address1%TYPE,
1637: address2 hz_locations.address2%TYPE,
1638: address3 hz_locations.address3%TYPE,
1639: address4 hz_locations.address4%TYPE,
1640: city hz_locations.city%TYPE,
1641: county hz_locations.county%TYPE,
1642: state hz_locations.state%TYPE,

Line 1639: address4 hz_locations.address4%TYPE,

1635: TYPE local_rrs_site_address_rec is RECORD (
1636: address1 hz_locations.address1%TYPE,
1637: address2 hz_locations.address2%TYPE,
1638: address3 hz_locations.address3%TYPE,
1639: address4 hz_locations.address4%TYPE,
1640: city hz_locations.city%TYPE,
1641: county hz_locations.county%TYPE,
1642: state hz_locations.state%TYPE,
1643: province hz_locations.province%TYPE,

Line 1640: city hz_locations.city%TYPE,

1636: address1 hz_locations.address1%TYPE,
1637: address2 hz_locations.address2%TYPE,
1638: address3 hz_locations.address3%TYPE,
1639: address4 hz_locations.address4%TYPE,
1640: city hz_locations.city%TYPE,
1641: county hz_locations.county%TYPE,
1642: state hz_locations.state%TYPE,
1643: province hz_locations.province%TYPE,
1644: postal_code hz_locations.postal_code%TYPE,

Line 1641: county hz_locations.county%TYPE,

1637: address2 hz_locations.address2%TYPE,
1638: address3 hz_locations.address3%TYPE,
1639: address4 hz_locations.address4%TYPE,
1640: city hz_locations.city%TYPE,
1641: county hz_locations.county%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,

Line 1642: state hz_locations.state%TYPE,

1638: address3 hz_locations.address3%TYPE,
1639: address4 hz_locations.address4%TYPE,
1640: city hz_locations.city%TYPE,
1641: county hz_locations.county%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,

Line 1643: province hz_locations.province%TYPE,

1639: address4 hz_locations.address4%TYPE,
1640: city hz_locations.city%TYPE,
1641: county hz_locations.county%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),

Line 1644: postal_code hz_locations.postal_code%TYPE,

1640: city hz_locations.city%TYPE,
1641: county hz_locations.county%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,

Line 1645: country hz_locations.country%TYPE,

1641: county hz_locations.county%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

Line 1795: FROM HZ_LOCATIONS HL

1791: HZ_FORMAT_PUB.format_address(HL.location_id, null, null, ',' , null) as Address,
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

Line 1822: FROM HZ_LOCATIONS HL

1818: where AL.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
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