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';