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

13 comments:

Unknown 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

Devi 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

saranya 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

Unknown 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

Unknown 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

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

Unknown said...

Excellent post. Thank you for sharing.
HR Payroll Software | Leave Management Software | Attendance Management System | HR Management Software

rajeev said...

Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com

RJ said...

Thanks for a great tips, This would be a different idea from the routine tips. We specialise in finance, tax, IT, marketing & HR Services . As an ISO 9001 certified company with over 30 years international experience in accounting, VAT and technology, we have the unique capabilities to ensure you are fully compliant to the UAE legislation. See our range of articles, white papers and learning resources and self-study material to learn accounting, VAT and taxation at your own pace

SmartCursors said...

Your post is itself informative and has encouraged so many more inputs from experts in the thread/comments. Thank you for initiating this topic. For some more wise and witty discussions, visit HRMS Singapore .

Do Assignment Help said...

Great blog you posted here. Really amazing. Be honest, I visited your blog for the first time but now I am a fan of your blog writing. Like you! I am also here to promote my Assignment help website organically. Basically we are an online Assignment help provider that helps and guides students to complete their assignments or how to complete assignments perfectly. We are here to help only, so if you need then contact us for help.