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