APPS.ENI_VALUESET_CATEGORY dependencies on FND_ID_FLEX_SEGMENTS

Line 96: from fnd_id_flex_segments

92: -- Check to see if segment1 associated with the structure is valid --
93:
94: select application_column_name, enabled_flag, to_number(flex_value_set_id)
95: into l_application_column, l_enabled_flag, l_flex_value_set_id
96: from fnd_id_flex_segments
97: where application_id = 401
98: and id_flex_code = 'MCAT'
99: and enabled_flag = 'Y'
100: and id_flex_num = l_struct_code;

Line 153: from fnd_id_flex_segments

149: where category_set_id = p_vbh_catset_id;
150:
151: select count(flex_value_set_id)
152: into l_count_segments
153: from fnd_id_flex_segments
154: where application_id = p_appl_id
155: and id_flex_code = p_id_flex_code
156: and enabled_flag = 'Y'
157: and id_flex_num = l_struct_id;

Line 163: from fnd_id_flex_segments

159:
160: if l_count_segments = 1 then
161:
162: select flex_value_set_id into l_flex_value_set_id
163: from fnd_id_flex_segments
164: where application_id = p_appl_id
165: and id_flex_code = p_id_flex_code
166: and enabled_flag = 'Y'
167: and id_flex_num = l_struct_id;

Line 221: from FND_FLEX_VALUES_VL val, --FND_ID_FLEX_SEGMENTS seg,

217: val.END_DATE_ACTIVE l_end_date_active,
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'

Line 245: from FND_FLEX_VALUES_VL val,-- FND_ID_FLEX_SEGMENTS seg,

241: val.END_DATE_ACTIVE l_end_date_active,
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'

Line 265: from FND_ID_FLEX_SEGMENTS

261:
262: begin
263: select FLEX_VALUE_SET_ID
264: into l_value_set_id
265: from FND_ID_FLEX_SEGMENTS
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