Query to get Value Set Details
SELECT ffvs.flex_value_set_id,
ffvs.flex_value_set_name,
ffvs.description ,
ffvs.validation_type,
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_id = ffv.flex_value_set_id
AND ffv.flex_value_id = ffvt.flex_value_id
AND ffvt.language = 'US'
![](http://oratrainings.com/wp-content/uploads/2023/06/image-4-1024x74.png)