Sql Query To Display The List of Value sets based on Oracle apps tables

Sql Query To Display The List of Value sets based on Oracle apps tables

 

How To Find Out The Value sets based on Oracle apps tables

select ffvs.flex_value_set_id ,

ffvs.flex_value_set_name ,

ffvs.description set_description ,

ffvs.validation_type,

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;