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.ENI_VALUESET_CATEGORY dependencies on MTL_CATEGORIES_B

Line 222: MTL_CATEGORY_SETS cat, MTL_CATEGORIES_B mtb, MTL_CATEGORIES_TL mtl

218: mtb.category_id category_id,
219: cat.STRUCTURE_ID l_structure_id,
220: 1 update_flag -- Update Flag to indicate updateable records
221: from FND_FLEX_VALUES_VL val, --FND_ID_FLEX_SEGMENTS seg,
222: MTL_CATEGORY_SETS cat, MTL_CATEGORIES_B mtb, MTL_CATEGORIES_TL mtl
223: where val.FLEX_VALUE_SET_ID = l_value_set_id -- seg.FLEX_VALUE_SET_ID
224: -- and seg.ID_FLEX_CODE='MCAT'
225: -- and seg.APPLICATION_ID = '401'
226: -- and seg.APPLICATION_COLUMN_NAME ='SEGMENT1'

Line 253: and not exists(select category_id from mtl_categories_b

249: -- and seg.APPLICATION_ID = '401'
250: -- and seg.APPLICATION_COLUMN_NAME ='SEGMENT1'
251: -- and seg.ID_FLEX_NUM=cat.STRUCTURE_ID
252: and cat.CATEGORY_SET_ID = l_vbh_catset_id
253: and not exists(select category_id from mtl_categories_b
254: where structure_id = cat.structure_id
255: and segment1 = val.flex_value_meaning);
256:
257: begin