DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on HZ_CUST_ACCT_SITES

Line 3766: hz_cust_acct_sites cas,hz_cust_site_uses_all sua

3762: cursor c_bankruptcies is
3763: select sua.site_use_id,
3764: COUNT(1) number_of_bankruptcies
3765: FROM iex_bankruptcies bkr,hz_cust_accounts ca,
3766: hz_cust_acct_sites cas,hz_cust_site_uses_all sua
3767: where sua.site_use_id in (select object_id from iex_pop_uwq_summ_gt)
3768: and bkr.party_id=ca.party_id
3769: and ca.cust_account_id=cas.cust_account_id
3770: and cas.cust_acct_site_id=sua.cust_acct_site_id