DFF Columns Mapping with Attributes List

select fa.application_short_name,
fdft.title,
fdf.application_table_name,
-- fdf.descriptive_flexfield_name,
-- fdf.description,
fdfcu.application_column_name,
-- fdfcu.end_user_column_name,
fdfcu.enabled_flag enabled,
fdfcu.required_flag required,
--fdfcu.form_left_prompt,
--fdfcu.description,
--fdfcu.creation_date,
fu.user_name created_by , fdfcu.*
from fnd_descriptive_flexs fdf,
fnd_descriptive_flexs_tl fdft,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_column_usages fdfcu,
fnd_application fa,
fnd_user fu
where fdf.application_id=fdft.application_id
and fdf.descriptive_flexfield_name=fdft.descriptive_flexfield_name
and fdft.application_id=fa.application_id
and fdf.application_id=fdfc.application_id
and fdf.descriptive_flexfield_name=fdfc.descriptive_flexfield_name
and fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code
and fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name
and fdfc.application_id=fdfcu.application_id
and fdfcu.created_by=fu.user_id
and fdf.descriptive_flexfield_name ='MTL_SYSTEM_ITEMS'