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

Line 1151: hz_cust_site_uses_all site_uses,

1147: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
1148: jtf_objects_b objb,
1149: hz_contact_points phone,
1150: fnd_territories_tl fnd_terr,
1151: hz_cust_site_uses_all site_uses,
1152: hz_customer_profiles prf,
1153: ar_collectors ac,
1154: GL_SETS_OF_BOOKS gl,
1155: AR_SYSTEM_PARAMETERS_all sys,

Line 1409: hz_cust_site_uses_all site_uses,

1405: hz_cust_accounts acc,
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

Line 1769: hz_cust_site_uses_all site_uses,

1765: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
1766: jtf_objects_b objb,
1767: hz_contact_points phone,
1768: fnd_territories_tl fnd_terr,
1769: hz_cust_site_uses_all site_uses,
1770: hz_customer_profiles prf,
1771: ar_collectors ac,
1772: GL_SETS_OF_BOOKS gl,
1773: AR_SYSTEM_PARAMETERS_all sys,

Line 2046: hz_cust_site_uses_all site_uses,

2042: hz_cust_accounts acc,
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

Line 4821: hz_cust_site_uses_all hcsua,

4817: loc.country country,
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

Line 9627: hz_cust_site_uses_all site_uses,

9623: hz_cust_accounts acc,
9624: hz_parties party,
9625: jtf_objects_b objb,
9626: fnd_territories_tl fnd_terr,
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

Line 9953: hz_cust_site_uses_all sua

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
9957: and cas.cust_acct_site_id=sua.cust_acct_site_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