Flexfields avilable for your Oracle Application Version

Flexfields avilable for your Oracle Application Version:-
-----------------------------------------------------------------

The following Query gives us, all the flexfields avilable for your Oracle Application version.

select faa.APPLICATION_NAME "Application Name", fif.id_flex_name "Flexfield Name", faa.description "Application Description"
from FND_ID_FLEXS fif, FND_APPLICATION_ALL_VIEW faa
WHERE fif.APPLICATION_ID = faa.APPLICATION_ID
order by faa.APPLICATION_NAME;