Oracle Fusion

Value Sets: Related Tables and Query to Fetch the Details

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...
https://www.amazon.in/gp/product/B093CC1CLD?ie=UTF8&tag=oraclebytes-21&camp=3638&linkCode=xm2&creativeASIN=B093CC1CLD

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..

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?