APPS.ENI_VALUESET_CATEGORY dependencies on MTL_CATEGORY_SETS_B

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 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