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.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 83: ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas, hz_cust_site_uses_all csu

79: (EXISTS (SELECT 1 FROM hz_cust_acct_sites cas
80: where cas.party_site_id = o.party_site_id
81: and cas.status = 'A')
82: AND
83: ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas, hz_cust_site_uses_all csu
84: WHERE csu.cust_acct_site_id = cas.cust_acct_site_id
85: AND cas.party_site_id = o.party_site_id
86: AND cas.org_id = csu.org_id
87: AND csu.site_use_code = o.site_use_type)

Line 90: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses_all csu

86: AND cas.org_id = csu.org_id
87: AND csu.site_use_code = o.site_use_type)
88: OR
89: EXISTS ( SELECT 1
90: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses_all csu
91: WHERE cas.party_site_id = o.party_site_id
92: AND cas.org_id = csu.org_id
93: AND csu.cust_acct_site_id = cas.cust_acct_site_id
94: AND csu.status = 'A'