APPS: Finding Flexfields per table

This SQL gave me a nice report on Oracle Apps flexfields used in a set of tables:

select distinct
fdf.APPLICATION_TABLE_NAME,
fcu.APPLICATION_COLUMN_NAME,
fcu.descriptive_flex_context_code,
fcu.END_USER_COLUMN_NAME,
fcu.ENABLED_FLAG,fcu.REQUIRED_FLAG,fcu.DISPLAY_FLAG,fcu.DISPLAY_SIZE, fcu.FLEX_VALUE_SET_ID
,fvs.FLEX_VALUE_SET_NAME, fvs.DESCRIPTION VALUESETDESC, fvs.VALIDATION_TYPE
from APPLSYS.FND_DESCRIPTIVE_FLEXS fdf
left outer join APPLSYS.FND_DESCR_FLEX_COLUMN_USAGES fcu
on fdf.application_id = fcu.application_id
and fdf.descriptive_flexfield_name = fcu.descriptive_flexfield_name
left outer join APPLSYS.FND_FLEX_VALUE_SETS fvs
on fcu.FLEX_VALUE_SET_ID = fvs.FLEX_VALUE_SET_ID
where fdf.application_table_name in (....list_of_tables...)
order by 1,2,3

Sphere: Related Content