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_PARTY_SITES

Line 579: hz_party_sites party_site,

575: inv_postal_code IN varchar2) IS
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

Line 609: hz_party_sites party_site,

605: SELECT loc.state,
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