Query to get values of the Independent/Dependent Value Set

The query will provide the value set values entered from the front-end. For query-based value sets, we need to use direct queries.

SELECT ffvs.flex_value_set_id

     , ffvs.flex_value_set_name

     , ffvs.description 
     , ffvs.validation_type

     , ffv.flex_value

     , ffvt.description

     , ffv.enabled_flag
     , ffv.last_update_date

     , ffv.last_updated_by
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 = 'US'
  and flex_value_set_name in ('PROJECT_TYPE')
ORDER BY flex_value_set_name, flex_value asc