APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 299: hz_cust_site_uses_all site_uses,

295: hz_parties party,
296: jtf_objects_b objb,
297: hz_contact_points phone,
298: fnd_territories_tl fnd_terr,
299: hz_cust_site_uses_all site_uses,
300: hz_customer_profiles prf,
301: ar_collectors ac,
302: GL_SETS_OF_BOOKS gl,
303: AR_SYSTEM_PARAMETERS_all sys

Line 561: hz_cust_site_uses_all site_uses,

557: hz_parties party,
558: jtf_objects_b objb,
559: hz_contact_points phone,
560: fnd_territories_tl fnd_terr,
561: hz_cust_site_uses_all site_uses,
562: hz_customer_profiles prf,
563: ar_collectors ac,
564: GL_SETS_OF_BOOKS gl,
565: AR_SYSTEM_PARAMETERS_all sys

Line 3489: hz_cust_site_uses_all site_uses,

3485: hz_cust_accounts acc,
3486: hz_parties party,
3487: jtf_objects_b objb,
3488: fnd_territories_tl fnd_terr,
3489: hz_cust_site_uses_all site_uses,
3490: GL_SETS_OF_BOOKS gl,
3491: AR_SYSTEM_PARAMETERS_all sys
3492: WHERE trx_summ.reference_1 = '1'
3493: AND trx_summ.site_use_id = site_uses.site_use_id

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