Value Set Table Based

This Query gives details of a value set that is based on a oracle 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'
                             */
      , ffvt.value_column_name
      , ffvt.meaning_column_name
      , ffvt.id_column_name
      , ffvt.application_table_name
      , ffvt.additional_where_clause
   FROM fnd_flex_value_sets ffvs
      , fnd_flex_validation_tables ffvt
  WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id