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_SITE_USES

Line 102: hz_cust_site_uses site

98: nvl(cp_cust.tax_printing_option,p_tax_printing_option) )
99: INTO l_tax_printing_option
100: FROM hz_customer_profiles cp_site,
101: hz_customer_profiles cp_cust,
102: hz_cust_site_uses site
103: WHERE cp_site.site_use_id(+) = site.site_use_id
104: AND site.site_use_id = p_bill_to_site_use_id
105: AND cp_cust.cust_account_id = p_bill_to_customer_id
106: AND cp_cust.site_use_id is null;

Line 611: hz_cust_site_uses site_uses

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
615: and loc.location_id = party_site.location_id;