Saturday, September 19, 2015

Oracle Apps: Query to check Value Set Values

Below is Query to check Valueset Values in Oracle Apps

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,
ffv.last_update_date,
ffv.last_updated_by,
ffv.attribute1,
ffv.attribute2,
ffv.attribute3–Include attribute values based on DFF segments
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 like <Valueset>
ORDER BY flex_value asc

9 comments:

oracle fusion said...

Nice article and explanation is good,Thank you for sharing your experience on oracle Apps.You have clearly explained about the process thus it is very much interesting and i got more information from your blog.For more details about oracle fusion financial please check our website.

Oracle Fusion Financial Training Institute

devo said...

Thank you for sharing. The information you shared is very effective for learners. Java Training Institute in Chennai | Java Training Institute in Velachery.

sukere said...

Really an amazing post..! By reading your blog post i gained more information.

Social Media Marketing

Fuzzy International said...

The best thing is that your blog really informative thanks for your great information!
cashew nuts suppliers and exporters in dubai
A4 paper suppliers and exporters in dubai
onion suppliers and exporters in dubai
potato suppliers and exporters in dubai
spices&grains suppliers and exporters in dubai

Inigo joseph said...

Thanks a lot very much for the high your blog post quality and results-oriented help. I won’t think twice to endorse to anybody who wants and needs support about this area. java training in jaya nagar

mari A said...

Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.

AWS Training in Chennai

calfre services said...

This site has lots of advantage awesome i really enjoyed reading thanks for sharing for grate info ..we are also proving free local search engine..this search engine can track all reffering training institutes with mobile numbers,placement details,area locations,everything available in this search engine ... this search engine just type Ur course name and location search engine can shows top training institutes data shown in your desktop..or mobiles
java training

Sphinax info systems said...

Nice Blog. Thank you for sharing.
ERP in Chennai | ERP Providers in Chennai | ERP Software in Chennai | ERP Software Development Company in Chennai

cara menggugurkan hamil said...

just information we only provide information for those who need it
A. cara agar cepat hamil setelah selesai haid
B. cara agar cepat hamil
C. cara alami untuk segera mendapat kehamilan
D. makanan dan minuman agar cepat hamil
E. masa subur biar cepat hamil
F. panduan agar cepat hamil