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_CUST_ACCT_SITES

Line 578: FROM hz_cust_acct_sites acct_site,

574: inv_state IN varchar2 ,
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

Line 608: FROM hz_cust_acct_sites acct_site,

604: CURSOR address( bill_site_use_id IN number ) is
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