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_CAT_FPI_UPGRADE dependencies on ICX_POR_EXT_CLASS

Line 343: AND cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE)

339: WHERE ci.rt_item_id = pRtItemId
340: AND EXISTS (SELECT 'primary category'
341: FROM icx_por_categories_tl cat
342: WHERE cat.rt_category_id = ci.rt_category_id
343: AND cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE)
344: AND ROWNUM = 1;
345: RETURN xRtCategoryId;
346: END getOldPrimaryCategoryId;
347:

Line 360: AND cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE)

356: WHERE ci.rt_item_id = pRtItemId
357: AND EXISTS (SELECT 'primary category'
358: FROM icx_cat_categories_tl cat
359: WHERE cat.rt_category_id = ci.rt_category_id
360: AND cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE)
361: AND ROWNUM = 1;
362: RETURN xRtCategoryId;
363: END getPrimaryCategoryId;
364:

Line 1613: WHERE cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE

1609: PROCEDURE updateExtItemsTLP IS
1610: CURSOR cAllCategories IS
1611: SELECT cat.rt_category_id
1612: FROM icx_cat_categories_tl cat
1613: WHERE cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE
1614: AND cat.language = (SELECT language_code
1615: FROM fnd_languages
1616: WHERE installed_flag = 'B')
1617: AND EXISTS (SELECT 'category attributes'