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;