Query to Find the Descriptive FlexField (DFF) Name




Script:

ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';


select application_id, DESCRIPTIVE_FLEXFIELD_NAME, application_table_name
from fnd_descriptive_flexs_vl
where DESCRIPTIVE_FLEXFIELD_NAME LIKE '%' || UPPER('&name') || '%'
order by application_table_name;





If you like please follow and comment