Query to find details of Flex value sets

•By Amol Jadhav
Query to find details of Flex value sets
Oracle Apps sql query to find of value set values

Query to find list of values of Independent value set

SQL Querysql
1SELECT ffvs.flex_value_set_id,
2       ffvs.flex_value_set_name,
3       ffvs.description set_description,
4       ffvs.validation_type,
5       ffv.flex_value_id,
6       ffv.flex_value,
7       ffvt.flex_value_meaning,
8       ffvt.description value_description
9  FROM fnd_flex_value_sets ffvs, fnd_flex_values ffv, fnd_flex_values_tl ffvt
10 WHERE     ffvs.flex_value_set_id = ffv.flex_value_set_id
11       AND ffv.flex_value_id = ffvt.flex_value_id
12       AND ffvt.language = 'US'     --USERENV('LANG')
13       AND flex_value_set_name = 'Your value set name'

Query to find details of Table Value set     

GENERICgeneric
1SELECT ffvs.flex_value_set_id,
2       ffvs.flex_value_set_name,
3       ffvs.description set_description,
4       ffvs.validation_type,
5       ffvt.value_column_name,
6       ffvt.meaning_column_name,
7       ffvt.id_column_name,
8       ffvt.application_table_name,
9       ffvt.additional_where_clause
10  FROM fnd_flex_value_sets ffvs, fnd_flex_validation_tables ffvt
11 WHERE     ffvs.flex_value_set_id = ffvt.flex_value_set_id
12       AND flex_value_set_name = 'Your value set name'

Related posts: