SELECT ffv.application_table_name
,ffv.descriptive_flexfield_name
,ffv.context_column_name
,ffv.title
,att.application_column_name
,att.end_user_column_name
,att.column_seq_num
,att.enabled_flag
,att.required_flag
,att.security_enabled_flag
,att.display_flag
,att.flex_value_set_id
,att.form_left_prompt
,ffv.*
FROM fnd_descriptive_flexs_vl ffv
,fnd_descr_flex_col_usage_vl att
WHERE ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
AND ffv.descriptive_flexfield_name = 'PO_LINES'
Output:
,ffv.descriptive_flexfield_name
,ffv.context_column_name
,ffv.title
,att.application_column_name
,att.end_user_column_name
,att.column_seq_num
,att.enabled_flag
,att.required_flag
,att.security_enabled_flag
,att.display_flag
,att.flex_value_set_id
,att.form_left_prompt
,ffv.*
FROM fnd_descriptive_flexs_vl ffv
,fnd_descr_flex_col_usage_vl att
WHERE ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
AND ffv.descriptive_flexfield_name = 'PO_LINES'
Output:
Hi,
ReplyDeleteI am googling for a query to get the arribute columns which were enabled during registering the DFF of a table.
For example:
in aso_quote_headers_all, only attribute1 to attribute15 were enabled and attribute16 to attribute20 are not enabled. How can we get the disabled attribute columns from query. which table stores this data.
i could see the enabled and disabled attributes in Descriptive->resgister->segments