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 2709: from hz_cust_site_uses

2705: select site_use_id
2706: into l_site_with_profile
2707: from hz_customer_profiles
2708: where site_use_id in ( select site_use_id
2709: from hz_cust_site_uses
2710: where cust_acct_site_id =
2711: ( SELECT cust_acct_site_id
2712: FROM hz_cust_site_uses
2713: WHERE site_use_id = p_site_use_id)

Line 2712: FROM hz_cust_site_uses

2708: where site_use_id in ( select site_use_id
2709: from hz_cust_site_uses
2710: where cust_acct_site_id =
2711: ( SELECT cust_acct_site_id
2712: FROM hz_cust_site_uses
2713: WHERE site_use_id = p_site_use_id)
2714: and status = 'A'
2715: and site_use_code in ('BILL_TO','DUN','STMTS'));
2716:

Line 2736: from hz_cust_site_uses

2732: select site_use_id
2733: into l_site_with_profile
2734: from hz_customer_profiles
2735: where site_use_id in ( select site_use_id
2736: from hz_cust_site_uses
2737: where cust_acct_site_id =
2738: ( SELECT cust_acct_site_id
2739: FROM hz_cust_site_uses
2740: WHERE site_use_id = p_site_use_id)

Line 2739: FROM hz_cust_site_uses

2735: where site_use_id in ( select site_use_id
2736: from hz_cust_site_uses
2737: where cust_acct_site_id =
2738: ( SELECT cust_acct_site_id
2739: FROM hz_cust_site_uses
2740: WHERE site_use_id = p_site_use_id)
2741: and status = 'A'
2742: and site_use_code = 'BILL_TO');
2743: return l_site_with_profile; /*4913217 */