Forms Personalization related Script

The below script list all the forms in Oracle Applications that have been customized using Forms Personlization:

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