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.IMC_REPORTS_SUMMARY_PKG dependencies on FND_TERRITORIES_TL

Line 272: -- 1) Use FND_TERRITORIES_TL instead of VL

268:
269: -- INSERT all the countries for ORGANIZATION and PERSON
270:
271: -- Fix perf bug 3659367.
272: -- 1) Use FND_TERRITORIES_TL instead of VL
273: -- 2) Count the number of parties which has country set
274: -- 3) By deducting the total number of parties by the total number of parites
275: -- having country information, we will get the number of parties which do
276: -- not have country information

Line 300: fnd_territories_tl terr

296: WHERE pty.party_type IN ('ORGANIZATION','PERSON')
297: AND pty.status = 'A'
298: GROUP BY pty.country, pty.party_type )
299: GROUP BY country ) pty ,
300: fnd_territories_tl terr
301: WHERE pty.country = terr.territory_code
302: AND terr.language = userenv('LANG')
303: ORDER BY country, country_code;
304: