How to find the name of a DFF

If you have the name of the table you want the DFF for, you can use this query:

select app.APPLICATION_NAME, dff.TITLE, dff.APPLICATION_TABLE_NAME
from apps.FND_DESCRIPTIVE_FLEXS_VL dff,
 apps.FND_APPLICATION_TL app
where dff.APPLICATION_ID = app.APPLICATION_ID
 and dff.APPLICATION_TABLE_NAME = 'HZ_PARTIES';

Leave a Reply

Your email address will not be published. Required fields are marked *