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.ARPT_SQL_FUNC_UTIL dependencies on HZ_LOCATIONS

Line 1447: hz_locations loc

1443: select ft.territory_short_name
1444: from fnd_territories_vl ft,
1445: hz_cust_acct_sites acct_site,
1446: hz_party_sites party_site,
1447: hz_locations loc
1448: where loc.country = ft.territory_code
1449: and acct_site.party_site_id = party_site.party_site_id
1450: and loc.location_id = party_site.location_id
1451: and acct_site.cust_acct_site_id = p_address_id;

Line 1501: hz_locations loc

1497: select ft.rowid
1498: from fnd_territories_vl ft,
1499: hz_cust_acct_sites acct_site,
1500: hz_party_sites party_site,
1501: hz_locations loc
1502: where loc.country = ft.territory_code
1503: and acct_site.party_site_id = party_site.party_site_id
1504: and loc.location_id = party_site.location_id
1505: and acct_site.cust_acct_site_id = p_address_id;

Line 2059: hz_locations loc

2055: l_city, l_state,l_province, l_postal_code, l_country,
2056: l_status
2057: FROM hz_cust_acct_sites acct_site,
2058: hz_party_sites party_site,
2059: hz_locations loc
2060: WHERE acct_site.party_site_id = party_site.party_site_id
2061: AND loc.location_id = party_site.location_id
2062: AND acct_site.cust_acct_site_id = p_address_id;
2063: