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.ICX_POR_CTX_DESC dependencies on ICX_CAT_CATEGORIES_TL

Line 271: FROM icx_cat_categories_tl cat

267: -- and has atleast one item loaded by the given job.
268:
269: CURSOR getCatWithSearchCur(p_lang IN VARCHAR2, p_jobNum IN INTEGER) is
270: SELECT cat.rt_category_id
271: FROM icx_cat_categories_tl cat
272: WHERE cat.language = p_lang
273: AND cat.rt_category_id <> 0
274: AND cat.type = 2
275: AND exists (select 'X'

Line 360: FROM icx_cat_categories_tl cat

356: -- and has atleast one item classified under it
357:
358: CURSOR getCatWithSearchCur(p_lang IN VARCHAR2) is
359: SELECT cat.rt_category_id
360: FROM icx_cat_categories_tl cat
361: WHERE cat.language = p_lang
362: AND cat.rt_category_id <> 0
363: AND cat.type = 2
364: AND exists (select 'X'