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

Line 580: hz_locations loc,

576:
577: SELECT rt.address_id
578: FROM hz_cust_acct_sites acct_site,
579: hz_party_sites party_site,
580: hz_locations loc,
581: ra_remit_tos rt
582: WHERE acct_site.cust_acct_site_id = rt.address_id
583: AND acct_site.party_site_id = party_site.party_site_id
584: AND loc.location_id = party_site.location_id

Line 610: hz_locations loc,

606: loc.country,
607: loc.postal_code
608: FROM hz_cust_acct_sites acct_site,
609: hz_party_sites party_site,
610: hz_locations loc,
611: hz_cust_site_uses site_uses
612: WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
613: AND site_uses.site_use_id = bill_site_use_id
614: and acct_site.party_site_id = party_site.party_site_id