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 173: address1 hz_locations.address1%TYPE,

169: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
170: l_site_header_details local_rrs_site_header_tab;
171:
172: TYPE local_rrs_site_address_rec is RECORD (
173: address1 hz_locations.address1%TYPE,
174: address2 hz_locations.address2%TYPE,
175: address3 hz_locations.address3%TYPE,
176: address4 hz_locations.address4%TYPE,
177: city hz_locations.city%TYPE,

Line 174: address2 hz_locations.address2%TYPE,

170: l_site_header_details local_rrs_site_header_tab;
171:
172: TYPE local_rrs_site_address_rec is RECORD (
173: address1 hz_locations.address1%TYPE,
174: address2 hz_locations.address2%TYPE,
175: address3 hz_locations.address3%TYPE,
176: address4 hz_locations.address4%TYPE,
177: city hz_locations.city%TYPE,
178: county hz_locations.county%TYPE,

Line 175: address3 hz_locations.address3%TYPE,

171:
172: TYPE local_rrs_site_address_rec is RECORD (
173: address1 hz_locations.address1%TYPE,
174: address2 hz_locations.address2%TYPE,
175: address3 hz_locations.address3%TYPE,
176: address4 hz_locations.address4%TYPE,
177: city hz_locations.city%TYPE,
178: county hz_locations.county%TYPE,
179: state hz_locations.state%TYPE,

Line 176: address4 hz_locations.address4%TYPE,

172: TYPE local_rrs_site_address_rec is RECORD (
173: address1 hz_locations.address1%TYPE,
174: address2 hz_locations.address2%TYPE,
175: address3 hz_locations.address3%TYPE,
176: address4 hz_locations.address4%TYPE,
177: city hz_locations.city%TYPE,
178: county hz_locations.county%TYPE,
179: state hz_locations.state%TYPE,
180: province hz_locations.province%TYPE,

Line 177: city hz_locations.city%TYPE,

173: address1 hz_locations.address1%TYPE,
174: address2 hz_locations.address2%TYPE,
175: address3 hz_locations.address3%TYPE,
176: address4 hz_locations.address4%TYPE,
177: city hz_locations.city%TYPE,
178: county hz_locations.county%TYPE,
179: state hz_locations.state%TYPE,
180: province hz_locations.province%TYPE,
181: postal_code hz_locations.postal_code%TYPE,

Line 178: county hz_locations.county%TYPE,

174: address2 hz_locations.address2%TYPE,
175: address3 hz_locations.address3%TYPE,
176: address4 hz_locations.address4%TYPE,
177: city hz_locations.city%TYPE,
178: county hz_locations.county%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,

Line 179: state hz_locations.state%TYPE,

175: address3 hz_locations.address3%TYPE,
176: address4 hz_locations.address4%TYPE,
177: city hz_locations.city%TYPE,
178: county hz_locations.county%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,

Line 180: province hz_locations.province%TYPE,

176: address4 hz_locations.address4%TYPE,
177: city hz_locations.city%TYPE,
178: county hz_locations.county%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),

Line 181: postal_code hz_locations.postal_code%TYPE,

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

Line 182: country hz_locations.country%TYPE,

178: county hz_locations.county%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: );

Line 306: FROM HZ_LOCATIONS

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

Line 327: FROM HZ_LOCATIONS

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

Line 1569: address1 hz_locations.address1%TYPE,

1565: l_site_party_id number;
1566:
1567:
1568: TYPE local_rrs_site_address_rec is RECORD (
1569: address1 hz_locations.address1%TYPE,
1570: address2 hz_locations.address2%TYPE,
1571: address3 hz_locations.address3%TYPE,
1572: address4 hz_locations.address4%TYPE,
1573: city hz_locations.city%TYPE,

Line 1570: address2 hz_locations.address2%TYPE,

1566:
1567:
1568: TYPE local_rrs_site_address_rec is RECORD (
1569: address1 hz_locations.address1%TYPE,
1570: address2 hz_locations.address2%TYPE,
1571: address3 hz_locations.address3%TYPE,
1572: address4 hz_locations.address4%TYPE,
1573: city hz_locations.city%TYPE,
1574: county hz_locations.county%TYPE,

Line 1571: address3 hz_locations.address3%TYPE,

1567:
1568: TYPE local_rrs_site_address_rec is RECORD (
1569: address1 hz_locations.address1%TYPE,
1570: address2 hz_locations.address2%TYPE,
1571: address3 hz_locations.address3%TYPE,
1572: address4 hz_locations.address4%TYPE,
1573: city hz_locations.city%TYPE,
1574: county hz_locations.county%TYPE,
1575: state hz_locations.state%TYPE,

Line 1572: address4 hz_locations.address4%TYPE,

1568: TYPE local_rrs_site_address_rec is RECORD (
1569: address1 hz_locations.address1%TYPE,
1570: address2 hz_locations.address2%TYPE,
1571: address3 hz_locations.address3%TYPE,
1572: address4 hz_locations.address4%TYPE,
1573: city hz_locations.city%TYPE,
1574: county hz_locations.county%TYPE,
1575: state hz_locations.state%TYPE,
1576: province hz_locations.province%TYPE,

Line 1573: city hz_locations.city%TYPE,

1569: address1 hz_locations.address1%TYPE,
1570: address2 hz_locations.address2%TYPE,
1571: address3 hz_locations.address3%TYPE,
1572: address4 hz_locations.address4%TYPE,
1573: city hz_locations.city%TYPE,
1574: county hz_locations.county%TYPE,
1575: state hz_locations.state%TYPE,
1576: province hz_locations.province%TYPE,
1577: postal_code hz_locations.postal_code%TYPE,

Line 1574: county hz_locations.county%TYPE,

1570: address2 hz_locations.address2%TYPE,
1571: address3 hz_locations.address3%TYPE,
1572: address4 hz_locations.address4%TYPE,
1573: city hz_locations.city%TYPE,
1574: county hz_locations.county%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,

Line 1575: state hz_locations.state%TYPE,

1571: address3 hz_locations.address3%TYPE,
1572: address4 hz_locations.address4%TYPE,
1573: city hz_locations.city%TYPE,
1574: county hz_locations.county%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,

Line 1576: province hz_locations.province%TYPE,

1572: address4 hz_locations.address4%TYPE,
1573: city hz_locations.city%TYPE,
1574: county hz_locations.county%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),

Line 1577: postal_code hz_locations.postal_code%TYPE,

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

Line 1578: country hz_locations.country%TYPE,

1574: county hz_locations.county%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: );

Line 1726: FROM HZ_LOCATIONS HL

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

Line 1750: FROM HZ_LOCATIONS HL

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