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.

[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on HZ_LOCATIONS

Line 1159: HZ_LOCATIONS LOC

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
1162: P_MODE = 'CP'
1163: AND trx_summ.reference_1 = '1'

Line 1412: hz_locations loc

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
1415: and acct_site.party_site_id = party_site.party_site_id
1416: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1777: HZ_LOCATIONS LOC

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
1780: trx_summ.reference_1 = '1'
1781: -- Added for the bug#8538945 by PNAVEENK

Line 2049: hz_locations loc

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
2052: and acct_site.party_site_id = party_site.party_site_id
2053: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id

Line 4824: hz_locations loc

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
4827: and hcasa.party_site_id=hps.party_site_id
4828: and hps.location_id=loc.location_id

Line 9633: HZ_LOCATIONS LOC

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'
9636: -- Added for the bug#8538945 by PNAVEENK
9637: and PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID