Independent Value set Details

This query gives details of independent FND Value sets i.e. Values are static and these are not derived from any application table

 SELECT ffvs.flex_value_set_id
      , ffvs.flex_value_set_name
      , ffvs.description set_description
      , ffvs.validation_type /* This is a lookup code for type 'SEG_VAL_TYPES'
                             */
      , ffv.flex_value_id
      , ffv.flex_value
      , ffvt.flex_value_meaning
      , ffvt.description value_description
   FROM fnd_flex_value_sets ffvs
      , fnd_flex_values     ffv
      , fnd_flex_values_tl  ffvt
  WHERE ffvs.flex_value_set_name = 'BIS_YES_NO'
    AND ffvs.flex_value_set_id = ffv.flex_value_set_id
    AND ffv.flex_value_id      = ffvt.flex_value_id
    AND ffvt.language          = USERENV('LANG')