/******************************************************* *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; |