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_CATEGORY_SET_VALID_CATS

Line 37: from mtl_category_set_valid_cats mcsv

33: mtl_category_sets mcs
34: where (mcs.validate_flag = 'Y' and
35: mck.category_id in (
36: select mcsv.category_id
37: from mtl_category_set_valid_cats mcsv
38: where mcsv.category_set_id = l_cat_set_id) and
39: mck.concatenated_segments = l_cat_name)
40: or (mcs.validate_flag <> 'Y' and
41: mcs.structure_id = mck.structure_id and

Line 218: from mtl_category_set_valid_cats mcsv

214: mtl_category_sets mcs
215: where (mcs.validate_flag = 'Y' and
216: mck.category_id in (
217: select mcsv.category_id
218: from mtl_category_set_valid_cats mcsv
219: where mcsv.category_set_id = l_category_set_id) and
220: mck.category_id = l_category_id)
221: or (mcs.validate_flag <> 'Y' and
222: mcs.structure_id = mck.structure_id and

Line 245: from mtl_category_set_valid_cats mcsv

241: mtl_category_sets mcs
242: where (mcs.validate_flag = 'Y' and
243: mck.category_id in (
244: select mcsv.category_id
245: from mtl_category_set_valid_cats mcsv
246: where mcsv.category_set_id = l_category_set_id) and
247: mck.category_id = l_related_category_id)
248: or (mcs.validate_flag <> 'Y' and
249: mcs.structure_id = mck.structure_id and

Line 471: from mtl_category_set_valid_cats mcsv

467: mtl_category_sets mcs
468: where (mcs.validate_flag = 'Y' and
469: mck.category_id in (
470: select mcsv.category_id
471: from mtl_category_set_valid_cats mcsv
472: where mcsv.category_set_id = l_cat_set_id) and
473: mck.concatenated_segments = l_cat_name)
474: or (mcs.validate_flag <> 'Y' and
475: mcs.structure_id = mck.structure_id and