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.ARP_TRX_DEFAULTS_3 dependencies on HZ_CUST_ACCT_SITES

Line 80: hz_cust_acct_sites acct_site,

76: loc.province, loc.postal_code,
77: loc.country
78: INTO pg_remit_to_address_rec
79: FROM ra_remit_tos rt,
80: hz_cust_acct_sites acct_site,
81: hz_party_sites party_site,
82: hz_locations loc
83: WHERE rt.state = 'DEFAULT'
84: AND rt.country = 'DEFAULT'

Line 192: FROM hz_cust_acct_sites acct_site,

188: loc.address3, loc.address4,
189: loc.city, loc.state,
190: loc.province, loc.postal_code,
191: territory.territory_short_name --loc.country
192: FROM hz_cust_acct_sites acct_site,
193: hz_party_sites party_site,
194: hz_locations loc,
195: fnd_territories_vl territory,
196: ra_remit_tos rt

Line 301: FROM hz_cust_acct_sites acct_site,

297: loc.postal_code
298: INTO l_match_state,
299: l_match_country,
300: l_match_postal_code
301: FROM hz_cust_acct_sites acct_site,
302: hz_party_sites party_site,
303: hz_locations loc
304: WHERE acct_site.cust_acct_site_id = p_match_address_id
305: AND acct_site.party_site_id = party_site.party_site_id

Line 328: FROM hz_cust_acct_sites acct_site,

324: loc.postal_code
325: INTO l_match_state,
326: l_match_country,
327: l_match_postal_code
328: FROM hz_cust_acct_sites acct_site,
329: hz_party_sites party_site,
330: hz_locations loc,
331: hz_cust_site_uses su
332: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id