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; |
Recent Comments