193: l_parent_value_set_id
194: FROM fnd_id_flex_segments seg,
195: FND_SEGMENT_ATTRIBUTE_VALUES fsav,
196: FA_SYSTEM_CONTROLS sys,
197: fnd_flex_value_sets fv
198: WHERE fsav.application_id = 140
199: AND fsav.id_flex_code = 'CAT#'
200: AND fsav.id_flex_num = sys.category_flex_structure
201: AND fsav.segment_attribute_type = 'BASED_CATEGORY'
272: l_parent_value_set_id
273: FROM fnd_id_flex_segments seg,
274: FND_SEGMENT_ATTRIBUTE_VALUES fsav,
275: FA_SYSTEM_CONTROLS sys,
276: fnd_flex_value_sets fv
277: WHERE fsav.application_id = 140
278: AND fsav.id_flex_code = 'CAT#'
279: AND fsav.id_flex_num = sys.category_flex_structure
280: AND fsav.segment_attribute_type = 'MINOR_CATEGORY'