Can you please help me out in identifying the values defined in a particular valuset,
I have used the following query,
select * from fnd_flex_values_vl where flex_value_set_id = 20118
but I need to know wat is 20118 in front end?
Run the following query.
SELECT * FROM FND_FLEX_VALUE_SETS where flex_value_set_id = 20118;
You will get flex_value_set_name
Take this name and navigate to System Administrator-->Application-->Validation-->Values
Query the value set and you can check the values.
If it does not have any values then you can check in fnd_flex_values_vl too. There is a column called 'FLEX_VALUE'.
Hope this helps.