DBA Data[Home] [Help]

APPS.ENI_VALUESET_CATEGORY dependencies on FND_FLEX_VALUES_VL

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'