Value Sets are used in Oracle to define a limited sets of values for a particular field. There are 3 main tables in Oracle Fusion to fetch the values assigned to a value set. Here is a brief description of them:
1. FND_VS_VALUE_SETS: Table to hold the value set information ( Header level data).
2. FND_VS_VALUES_B: Table to hold the values of the value set.
3. FND_VS_VALUES_TL: Table to hold the description of the values.
Now let’s cut to the chase and see the query. Pretty simple it is:
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
Value Sets Query
SELECT vs.value_set_code,
vb.value,
vt.description
FROM FND_VS_VALUE_SETS vs,
FND_VS_VALUES_B vb,
FND_VS_VALUES_TL vt
WHERE 1=1
AND vs.value_set_code = :VALUE_SET_CODE
AND vs.value_set_id = vb.value_set_id
AND vt.value_id = vb.value_id
AND vt.language = USERENV(‘LANG’)
order by vb.value
Here :VALUE_SET_CODE is the input parameter for value set code name.
Related Posts
Fusion LoV Queries: Legal Entity, Business Unit, Inventory, Sub Inventory
Business Unit – Legal Entity – Ledger/ set of Books Relationship Query
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com
Check out the Amazon Deals of the day based on your interests..
