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_RELATED_CATEGORIES_PUB dependencies on MTL_CATEGORIES_KFV

Line 32: from mtl_categories_kfv mck,

28:
29: cursor l_category_csr(l_cat_name in varchar2,
30: l_cat_set_id in number) is
31: select mck.category_id
32: from mtl_categories_kfv mck,
33: mtl_category_sets mcs
34: where (mcs.validate_flag = 'Y' and
35: mck.category_id in (
36: select mcsv.category_id

Line 213: from mtl_categories_kfv mck,

209:
210: -- check category id if it was not looked up previously
211: if p_category_id is not null then
212: select count(*) into l_count
213: from mtl_categories_kfv mck,
214: mtl_category_sets mcs
215: where (mcs.validate_flag = 'Y' and
216: mck.category_id in (
217: select mcsv.category_id

Line 240: from mtl_categories_kfv mck,

236:
237: -- check related category id if it was not looked up previously
238: if p_related_category_id is not null then
239: select count(*) into l_count
240: from mtl_categories_kfv mck,
241: mtl_category_sets mcs
242: where (mcs.validate_flag = 'Y' and
243: mck.category_id in (
244: select mcsv.category_id

Line 466: from mtl_categories_kfv mck,

462:
463: cursor l_category_csr(l_cat_name in varchar2,
464: l_cat_set_id in number) is
465: select mck.category_id
466: from mtl_categories_kfv mck,
467: mtl_category_sets mcs
468: where (mcs.validate_flag = 'Y' and
469: mck.category_id in (
470: select mcsv.category_id