40: rownum pos,
41: 'LOCATION_ID_SEGMENT_'||to_char(seg.segment_num) column_num
42: from fnd_flex_value_sets vs,
43: fnd_id_flex_segments_vl seg,
44: fnd_segment_attribute_values qual,
45: fnd_id_flex_structures struct
46: where seg.application_id = appl_id
47: and seg.id_flex_code = flex_code
48: and seg.flex_value_set_id = vs.flex_value_set_id