Query to get DFF (Descriptive Flex Field) Details

1--
2SELECT ffv.descriptive_flexfield_name  "DFF Name",
3         ffv.application_table_name      "Table Name",
4         ffv.title                       "Title",
5         ap.application_name             "Application",
6         ffc.descriptive_flex_context_code "Context Code",
7         ffc.descriptive_flex_context_name "Context Name",
8         ffc.description                 "Context Desc",
9         ffc.enabled_flag                "Context Enable Flag",
10         att.column_seq_num              "Segment Number",
11         att.form_left_prompt            "Segment Name",
12         att.application_column_name     "Column",
13         fvs.flex_value_set_name         "Value Set",
14         att.display_flag                "Displayed",
15         att.enabled_flag                "Enabled",
16         att.required_flag               "Required"
17    FROM apps.fnd_descriptive_flexs_vl  ffv,
18         apps.fnd_descr_flex_contexts_vl ffc,
19         apps.fnd_descr_flex_col_usage_vl att,
20         apps.fnd_flex_value_sets       fvs,
21         apps.fnd_application_vl        ap
22   WHERE     ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
23         AND ap.application_id = ffv.application_id
24         AND ffv.descriptive_flexfield_name = ffc.descriptive_flexfield_name
25         AND ffv.application_id = ffc.application_id
26         AND ffc.descriptive_flex_context_code =
27                att.descriptive_flex_context_code
28         AND fvs.flex_value_set_id = att.flex_value_set_id
29         AND ffv.title LIKE '<provide Title Name>'
30         AND ffc.descriptive_flex_context_code LIKE
31                '<provide Context Code Value>'
32ORDER BY att.column_seq_num
33--