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

6 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

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

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

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 .