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_CUSTOMER_PROFILES

Line 100: FROM hz_customer_profiles cp_site,

96:
97: SELECT nvl( cp_site.tax_printing_option,
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

Line 101: hz_customer_profiles cp_cust,

97: SELECT nvl( cp_site.tax_printing_option,
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