AOL: Query to get values of a Flex Field

The query lists all the values of a particular Flex structure:

 SELECT ffvs.flex_value_set_id,

       ffvs.flex_value_set_name,

       ffvs.description         set_description,

       ffvs.validation_type,

       ffv.flex_value           program,

       ffvt.description         pg_description,

       ffv.enabled_flag,

       ffv.last_update_date,

       ffv.last_updated_by,

       ffv.attribute1,

       ffv.attribute2,

       ffv.attribute3

  FROM fnd_flex_value_sets ffvs,

       fnd_flex_values     ffv,

       fnd_flex_values_tl  ffvt

 WHERE ffvs.flex_value_set_id = ffv.flex_value_set_id

   AND ffv.flex_value_id = ffvt.flex_value_id

   AND ffvt.language = userenv('lang')

   AND flex_value_set_name LIKE '%YOUR VALUE SET NAME%'

;