Query to get list all the forms in Oracle Applications that have been customized using Forms Personlization:

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

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;