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 86: ( NOT EXISTS (SELECT 1 FROM hz_cust_acct_sites cas, hz_cust_site_uses_all csu

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

Line 93: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses_all csu

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