Oracle Flex Fields

Value Set Usage by KeyFlexfields
select flex_value_set_name "Value Set",
descriptive_flexfield_name "Flexfield",
descriptive_flex_context_code "Structure",
end_user_column_name "Column"
from apps.fnd_descr_flex_column_usages a,
apps.fnd_flex_value_sets b
where a.flex_value_set_id = b.flex_value_set_id
and descriptive_flexfield_name not like '$SRS$%'
order by flex_value_set_name,
descriptive_flexfield_name,
descriptive_flex_context_code;

Value Set Usage by DescriptiveFlexfields
select d.flex_value_set_name "Value Set",
a.id_flex_name "Flexfield",
e.id_flex_structure_name "Structure",
c.segment_name "Segment"
from apps.fnd_id_flexsa,
apps.fnd_id_flex_structures b,
apps.fnd_id_flex_segments c,
apps.fnd_flex_value_sets d,
apps.fnd_id_flex_structures_tle
where a.application_id = b.application_id
and a.id_flex_code = b.id_flex_code
and b.application_id = c.application_id
and b.id_flex_code = c.id_flex_code
and b.id_flex_num = c.id_flex_num
and c.flex_value_set_id = d.flex_value_set_id
and c.application_id = e.application_id
and c.id_flex_code = e.id_flex_code
order by d.flex_value_set_name, a.id_flex_name,
e.id_flex_structure_name;