Configuration – Extract Table based value set information

Use below query to extract table based value set information from backend tables:

SELECT ffvs.flex_value_set_name
      ,ffvs.description vale_set_desc
      ,ffvs.validation_type
      ,ffvs.format_type
      ,ffvs.maximum_size
      ,ffvs.number_precision
      ,ffvs.alphanumeric_allowed_flag
      ,ffvs.uppercase_only_flag
      ,ffvt.value_column_name	  
      ,ffvt.value_column_type
      ,ffvt.value_column_size
      ,ffvt.meaning_column_name
      ,ffvt.meaning_column_type
      ,ffvt.meaning_column_size
      ,ffvt.id_column_name
      ,ffvt.id_column_type
      ,ffvt.id_column_size
      ,ffvt.enabled_column_name
      ,ffvt.start_date_column_name
      ,ffvt.end_date_column_name
      ,ffvt.summary_column_name
      ,ffvt.application_table_name
      ,ffvt.additional_where_clause
      ,ffvt.additional_quickpick_columns
  FROM fnd_flex_value_sets ffvs
      ,fnd_flex_validation_tables ffvt
 WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id
   AND ffvs.flex_value_set_name LIKE 'XX%'