Query to Fetch value Set Values

Hi Friends, we are going to discuss about Query to Fetch value Set Values. We will share the detail sql query to extract the value set values. This sql query will help to extract the complete list of value set values. This is one of the important sql query related to value set in oracle apps. We can use this sql query , to develop the custom reports related to value set in values. We will also share the important tables related to query to fetch value set values in oracle apps. Please find below the detail about  Query to Fetch value Set Values.

 Query to Fetch value Set Values

3 Important Table in Query to Fetch value Set Values

1.fnd_flex_value_sets

2.fnd_flex_values

3.fnd_flex_values_tl

Detail SQL Query to Fetch value Set Values

Here below is the detail sql query to extract the value set values in oracle apps r12.

SELECT ffvs.flex_value_set_id ,

ffvs.flex_value_set_name ,

ffvs.description set_description ,

ffvs.validation_type,

ffv.flex_value,

ffvt.description value_description,

ffv.enabled_flag

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 = USERENV(‘LANG’)

and flex_value_set_name = :P_VALUE_SET_NAME

ORDER BY flex_value asc

 Query to Fetch value Set Values

 Query to Fetch value Set Values