Forms Personalization Tables

When any Forms Personalization is done the following tables will be populated

FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_PARAMS
FND_FORM_CUSTOM_PROP_VALUES
FND_FORM_CUSTOM_PROP_LIST

Query to get  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;