OracleAppsDNA

SQL Query to Find DFF Structure from backend

/*******************************************************
 *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
   fnd_descr_flex_col_usage_vl col,
   fnd_descr_flex_contexts_vl ctx,
   fnd_descriptive_flexs_vl d_flex,
   fnd_flex_value_sets val_s,
   fnd_flex_value_sets ctx_val_s,
   fnd_application_tl apps 
WHERE
   1 = 1 	
   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 like 'RA_CUSTOMER_TRX_ALL%' 	
   --AND apps.application_name = 'Receivables'
   --AND Upper(d_flex.title) LIKE Upper('%Invoice Transactions%')   
   --AND ctx.descriptive_flex_context_name like 'XX%' 
   AND apps.language = 'US' 
order by
   apps.application_name,
   d_flex.title,
   ctx.descriptive_flex_context_name,
   col.column_seq_num;
Exit mobile version