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;