SQL Query to Find DFF Structure from backend

By | August 14, 2017 | 38 views | Category: AOL SQL Scripts Tags: , ,

/*******************************************************
 *PURPOSE: SQL Query to find DFF Structure from backend*
 *AUTHOR: Shailender Thallam                           *
 *******************************************************/
  SELECT apps.application_name                  "Application",
         d_flex.title                           "DFF Title",
         d_flex.application_table_name          "Table Name",
         d_flex.context_user_override_flag      "DFF Disp",
         d_flex.freeze_flex_definition_flag     "Frozen",
         d_flex.default_context_value           "Default Context",
         d_flex.context_required_flag           "DFF Required",
         ctx_val_s.flex_value_set_name          "Context ValueSet",
         ctx.descriptive_flex_context_name      "Context Name",
         ctx.enabled_flag                       "Context Enabled",
         col.form_left_prompt                   "Prompt",
         col.end_user_column_name               "User Column Name",
         val_s.flex_value_set_name              "Value Set",
         col.enabled_flag                       " Column Enabled",
         col.required_flag                      "Required",
         col.application_column_name            "Application Column Name",
         col.display_flag                       " Column Display",
         col.DEFAULT_VALUE                      "Default Value",
         col.security_enabled_flag              "Security",
         col.display_size,
         col.maximum_description_len,
         col.concatenation_description_len,
         col.application_id,
         d_flex.concatenated_segs_view_name,
         col.descriptive_flexfield_name,
         col.form_above_prompt,
         col.descriptive_flex_context_code,
         col.range_code,
         col.flex_value_set_id,
         col.default_type,
         col.srw_param
    FROM apps.fnd_descr_flex_col_usage_vl col,
         apps.fnd_descr_flex_contexts_vl ctx,
         apps.fnd_descriptive_flexs_vl   d_flex,
         apps.fnd_flex_value_sets        val_s,
         apps.fnd_flex_value_sets        ctx_val_s,
         apps.fnd_application_tl         apps
   WHERE     1 = 1
         AND d_flex.title LIKE :dff_tittle                      --'PO Headers'
         AND d_flex.descriptive_flexfield_name = ctx.descriptive_flexfield_name
         AND ctx.descriptive_flexfield_name = col.descriptive_flexfield_name(+)
         AND col.descriptive_flex_context_code(+) =
             ctx.descriptive_flex_context_code
         AND val_s.flex_value_set_id(+) = col.flex_value_set_id
         AND ctx_val_s.flex_value_set_id(+) =
             d_flex.context_override_value_set_id
         AND apps.application_id = d_flex.application_id
         --AND d_flex.application_table_name <> 'FND_SRS_MASTER'
         --AND d_flex.application_table_name = 'PO_HEADERS_ALL'
         --and apps.application_name = 'Purchasing'
         AND apps.language = 'US'
ORDER BY apps.application_name,
         d_flex.title,
         ctx.descriptive_flex_context_name,
         col.column_seq_num;
WOW! Did you like this post? We'll send more interesting posts like SQL Query to Find DFF Structure from backend to you!
Enter your Email Address: