QUERY TO FIND VALUES OF VALUE SET IN ORACLE E-BUSINESS SUITE

Query To Find Values Of Value Set In Oracle E-Business Suite:

1
2
3
4
5
6
7
8
9
 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;