HOW TO find DFFs that use a particular value setThis is a featured page

Platform: Oracle App: Application Object Library Tool:
DB Ver: 9.2 App Ver: 11.5.8 Tool Ver:
Revision Date: 02-Nov-2005 Keywords: HOWTO, FLEXFIELD, VALUE SETS

Goal
Find the descriptive flex fields that use a particular value set

Facts


Solution
Run the following script:

SELECT
ffvs.flex_value_set_name
,fa.application_name
,fdf.title
,fcu.descriptive_flex_context_code
,fcu.application_column_name
,fcu.end_user_column_name
,fcu.descriptive_flexfield_name
FROM fnd_flex_value_sets ffvs
,fnd_descr_flex_col_usage_vl fcu
,fnd_descriptive_flexs_vl fdf
,fnd_application_vl fa
WHERE 1=1
AND ffvs.flex_value_set_name LIKE '&flex_value_set_name'
AND fcu.flex_value_set_id = ffvs.flex_value_set_id
AND fdf.descriptive_flexfield_name = fcu.descriptive_flexfield_name
AND fa.application_id = fdf.application_id
/




consultium
consultium 		Latest page update: made by consultium , Oct 6 2009, 12:36 PM EDT (about this update About This Update consultium Edited by consultium


view changes
- complete history)
Keyword tags: FLEXFIELD HOW TO VALUE SETS
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
HOW TO programmatically launching concurrent request sets HOW TO simulate DISTINCT or GROUP BY in a value set HOW TO find all profile option values
HOW TO reference profile values from value sets HOW TO trace a concurrent program HOW TO make flexfield fields dependent on another
HOW TO use personalize for simple customizations HOW TO setup a printer driver SQL Dev SDK How Tos