APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1157: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr

1153: ar_collectors ac,
1154: GL_SETS_OF_BOOKS gl,
1155: AR_SYSTEM_PARAMETERS_all sys,
1156: -- Added for the bug#8538945 by PNAVEENK
1157: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
1158: HZ_PARTY_SITES PARTY_SITE,
1159: HZ_LOCATIONS LOC
1160: -- end for the bug#8538945
1161: WHERE

Line 1410: hz_cust_acct_sites_all acct_site,

1406: hz_parties party,
1407: -- hz_party_preferences party_pref, -- Commented for bug13452739
1408: fnd_territories_tl fnd_terr,
1409: hz_cust_site_uses_all site_uses,
1410: hz_cust_acct_sites_all acct_site,
1411: hz_party_sites party_site,
1412: hz_locations loc
1413: WHERE
1414: party_site.location_id = loc.location_id

Line 1775: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr

1771: ar_collectors ac,
1772: GL_SETS_OF_BOOKS gl,
1773: AR_SYSTEM_PARAMETERS_all sys,
1774: -- Added for the bug#8538945 by PNAVEENK
1775: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
1776: HZ_PARTY_SITES PARTY_SITE,
1777: HZ_LOCATIONS LOC
1778: -- end for the bug#8538945
1779: WHERE

Line 2047: hz_cust_acct_sites_all acct_site,

2043: hz_parties party,
2044: hz_party_preferences party_pref,
2045: fnd_territories_tl fnd_terr,
2046: hz_cust_site_uses_all site_uses,
2047: hz_cust_acct_sites_all acct_site,
2048: hz_party_sites party_site,
2049: hz_locations loc
2050: WHERE
2051: party_site.location_id = loc.location_id

Line 4822: hz_cust_acct_sites_all hcasa,

4818: loc.province province,
4819: loc.postal_code postal_code
4820: FROM
4821: hz_cust_site_uses_all hcsua,
4822: hz_cust_acct_sites_all hcasa,
4823: hz_party_sites hps,
4824: hz_locations loc
4825: WHERE
4826: hcsua.cust_acct_site_id=hcasa.cust_acct_site_id

Line 9631: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr

9627: hz_cust_site_uses_all site_uses,
9628: GL_SETS_OF_BOOKS gl,
9629: AR_SYSTEM_PARAMETERS_all sys,
9630: -- Added for the bug#8538945 by PNAVEENK
9631: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
9632: HZ_PARTY_SITES PARTY_SITE,
9633: HZ_LOCATIONS LOC
9634: -- end for the bug#8538945
9635: WHERE trx_summ.reference_1 = '1'

Line 9952: hz_cust_acct_sites_all cas,--Modified for Bug 9487600 23-Mar-2010 barathsr

9948: cursor c_bankruptcies is
9949: select sua.site_use_id,
9950: COUNT(1) number_of_bankruptcies
9951: FROM iex_bankruptcies bkr,hz_cust_accounts ca,
9952: hz_cust_acct_sites_all cas,--Modified for Bug 9487600 23-Mar-2010 barathsr
9953: hz_cust_site_uses_all sua
9954: where sua.site_use_id in (select object_id from iex_pop_uwq_summ_gt)
9955: and bkr.party_id=ca.party_id
9956: and ca.cust_account_id=cas.cust_account_id

Line 10073: from iex_pop_uwq_summ_gt gt,hz_cust_site_uses_all hcsua,hz_cust_acct_sites_all hcasa,hz_cust_accounts hca

10069: end if;
10070:
10071: delete from iex_dln_uwq_summary summ
10072: where exists(select 1
10073: from iex_pop_uwq_summ_gt gt,hz_cust_site_uses_all hcsua,hz_cust_acct_sites_all hcasa,hz_cust_accounts hca
10074: where gt.object_id=hcsua.site_use_id
10075: and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id
10076: and hcasa.cust_account_id=hca.cust_account_id
10077: and hca.party_id=summ.party_id