Query To Find Values Of Value Set In Oracle E-Business Suite:
SELECT tl.flex_value_meaning, tl.description
FROM apps.fnd_flex_value_sets fvs,
apps.fnd_flex_values_tl tl,
apps.fnd_flex_values fv
WHERE fvs.flex_value_set_id = fv.flex_value_set_id
AND fvs.flex_value_set_name = :P_VALUE_SET_NAME
AND enabled_flag = 'Y'
AND tl.language = 'US' --your language
AND tl.flex_value_id = fv.flex_value_id;