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.ARPT_SQL_FUNC_UTIL dependencies on HZ_CUST_SITE_USES

Line 2828: from hz_cust_site_uses

2824: select site_use_id
2825: into l_site_with_profile
2826: from hz_customer_profiles
2827: where site_use_id in ( select site_use_id
2828: from hz_cust_site_uses
2829: where cust_acct_site_id =
2830: ( SELECT cust_acct_site_id
2831: FROM hz_cust_site_uses
2832: WHERE site_use_id = p_site_use_id)

Line 2831: FROM hz_cust_site_uses

2827: where site_use_id in ( select site_use_id
2828: from hz_cust_site_uses
2829: where cust_acct_site_id =
2830: ( SELECT cust_acct_site_id
2831: FROM hz_cust_site_uses
2832: WHERE site_use_id = p_site_use_id)
2833: and status = 'A'
2834: and site_use_code in ('BILL_TO','DUN','STMTS'));
2835:

Line 2855: from hz_cust_site_uses

2851: select site_use_id
2852: into l_site_with_profile
2853: from hz_customer_profiles
2854: where site_use_id in ( select site_use_id
2855: from hz_cust_site_uses
2856: where cust_acct_site_id =
2857: ( SELECT cust_acct_site_id
2858: FROM hz_cust_site_uses
2859: WHERE site_use_id = p_site_use_id)

Line 2858: FROM hz_cust_site_uses

2854: where site_use_id in ( select site_use_id
2855: from hz_cust_site_uses
2856: where cust_acct_site_id =
2857: ( SELECT cust_acct_site_id
2858: FROM hz_cust_site_uses
2859: WHERE site_use_id = p_site_use_id)
2860: and status = 'A'
2861: and site_use_code = 'BILL_TO');
2862: return l_site_with_profile; /*4913217 */