Query to get DFF (Descriptive Flex Field) Details

Query to get DFF (Descriptive Flex Field) Details
Oracle Apps sql to get dff details
Dff Definition
Descriptive flexfield
SELECT ffv.descriptive_flexfield_name  "DFF Name",
         ffv.application_table_name      "Table Name",
         ffv.title                       "Title",
         ap.application_name             "Application",
         ffc.descriptive_flex_context_code "Context Code",
         ffc.descriptive_flex_context_name "Context Name",
         ffc.description                 "Context Desc",
         ffc.enabled_flag                "Context Enable Flag",
         att.column_seq_num              "Segment Number",
         att.form_left_prompt            "Segment Name",
         att.application_column_name     "Column",
         fvs.flex_value_set_name         "Value Set",
         att.display_flag                "Displayed",
         att.enabled_flag                "Enabled",
         att.required_flag               "Required"
    FROM apps.fnd_descriptive_flexs_vl  ffv,
         apps.fnd_descr_flex_contexts_vl ffc,
         apps.fnd_descr_flex_col_usage_vl att,
         apps.fnd_flex_value_sets       fvs,
         apps.fnd_application_vl        ap
   WHERE     ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
         AND ap.application_id = ffv.application_id
         AND ffv.descriptive_flexfield_name = ffc.descriptive_flexfield_name
         AND ffv.application_id = ffc.application_id
         AND ffc.descriptive_flex_context_code =
         AND fvs.flex_value_set_id = att.flex_value_set_id
         AND ffv.title LIKE '<provide Title Name>'
         AND ffc.descriptive_flex_context_code LIKE
                '<provide Context Code Value>'
ORDER BY att.column_seq_num
Related posts: Upload your own post and refer it anywhere anytime:

Leave a Reply