Oracle EBS find descriptive flexfield definitions using SQL query
SELECT
fdfv.title,
fdfv.application_table_name,
fdfv.context_column_name,
fdfcu.descriptive_flexfield_name,
fdfcu.descriptive_flex_context_code,
fdfcu.column_seq_num,
fdfcu.application_column_name,
fdfcu.end_user_column_name,
fdfcu.enabled_flag,
fdfcu.required_flag,
fdfcu.display_flag,
fdfcu.srw_param,
fdfcu.default_type,
fdfcu.DEFAULT_VALUE,
fvs.flex_value_set_name
FROM apps.fnd_descr_flex_col_usage_vl fdfcu,
apps.fnd_descriptive_flexs_vl fdfv,
apps.fnd_flex_value_sets fvs
WHERE 1 = 1
AND fdfcu.descriptive_flexfield_name = fdfv.descriptive_flexfield_name
AND fdfcu.application_id = fdfv.application_id
AND SUBSTR (title, 1, 5) != ‘$SRS$’
AND fvs.flex_value_set_id = fdfcu.flex_value_set_id
ORDER BY fdfcu.descriptive_flexfield_name,
fdfcu.descriptive_flex_context_code,
fdfcu.column_seq_num