APPS.ENI_VALUESET_CATEGORY dependencies on MTL_CATEGORY_SETS

Line 78: from fnd_id_flex_structures a, mtl_category_sets_b b

74:
75: -- Check to see if the structure asscociated with the category set is PRODUCT_CATEGORIES --
76: begin
77: select id_flex_num into l_struct_code
78: from fnd_id_flex_structures a, mtl_category_sets_b b
79: where a.id_flex_num=b.structure_id
80: and b.category_set_id = l_vbh_catset_id
81: and id_flex_structure_code='PRODUCT_CATEGORIES';
82:

Line 148: from mtl_category_sets_b

144: l_count_segments NUMBER;
145: begin
146:
147: select structure_id into l_struct_id
148: from mtl_category_sets_b
149: where category_set_id = p_vbh_catset_id;
150:
151: select count(flex_value_set_id)
152: into l_count_segments

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 246: MTL_CATEGORY_SETS cat

242: to_number(null),
243: cat.STRUCTURE_ID l_structure_id,
244: 0 -- Insert Flag to indicate a new node
245: from FND_FLEX_VALUES_VL val,-- FND_ID_FLEX_SEGMENTS seg,
246: MTL_CATEGORY_SETS cat
247: where val.FLEX_VALUE_SET_ID = l_value_set_id -- seg.FLEX_VALUE_SET_ID
248: -- and seg.ID_FLEX_CODE='MCAT'
249: -- and seg.APPLICATION_ID = '401'
250: -- and seg.APPLICATION_COLUMN_NAME ='SEGMENT1'

Line 270: from MTL_CATEGORY_SETS_B

266: where APPLICATION_ID = '401'
267: and ID_FLEX_CODE = 'MCAT'
268: and APPLICATION_COLUMN_NAME = 'SEGMENT1'
269: and ID_FLEX_NUM = (select STRUCTURE_ID
270: from MTL_CATEGORY_SETS_B
271: where CATEGORY_SET_ID = l_vbh_catset_id)
272: and ENABLED_FLAG = 'Y';
273:
274: exception