Query to find DFF Related Information in Oracle Apps

Query to find DFF Related Information in Oracle Apps

Query:

ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN'

SELECT

       fdf.title                             "DFF Title",

       fdf.application_table_name            "Application Table",

       fdf.context_column_name               "Context Column Name",

       --

       fdfcu.descriptive_flex_context_code   "DFF Context Code",

       fdfcu.column_seq_num                  "Sequence",

       fdfcu.end_user_column_name            "Segment Name",

       fdfcu.application_column_name         "Column Name",

       --

       ffv.flex_value_set_name               "Value Set Name"

  FROM

       fnd_descr_flex_col_usage_vl   fdfcu,

       fnd_descriptive_flexs_vl      fdf,

       fnd_flex_value_sets           ffv

 WHERE

  1 = 1

   --

AND fdf.title = 'Flexfield Segment Values'        -- <change it>

-- AND fdfcu.descriptive_flex_context_code = 'US'   

 AND fdfcu.enabled_flag = 'Y'

   --

AND 

   fdfcu.flex_value_set_id = ffv.flex_value_set_id

   AND fdfcu.descriptive_flexfield_name = fdf.descriptive_flexfield_name

   AND fdfcu.application_id = fdf.application_id

   --

 ORDER BY

       fdfcu.descriptive_flexfield_name,

       fdfcu.descriptive_flex_context_code,

       fdfcu.column_seq_num;

If you like please follow and comment