Query to find a list of all the forms in Oracle Applications that have been customized using Forms Personalization

 Query to find all Forms customized uining Personalization

Query to find a list of all the forms in Oracle Applications that have been customized using Forms Personalization:

select distinct a.form_name , a.enabled, c.USER_FORM_NAME, d.APPLICATION_NAME 

from FND_FORM_CUSTOM_RULES a,

     FND_FORM b,

     FND_FORM_TL c,

     fnd_application_tl d

where enabled = 'Y'

and a.form_name = b.form_name

and b.form_id = c.form_id

and b.application_id = d.application_id

order by application_name;