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;

Query to find form personalization

SELECT ffv.form_id          "Form ID",

       ffv.form_name        "Form Name",

       ffv.user_form_name   "User Form Name",

       ffv.description      "Form Description",

       ffcr.sequence        "Sequence",

       ffcr.description     "Personalization Rule Name"

  FROM fnd_form_vl             ffv,

       fnd_form_custom_rules   ffcr

 WHERE ffv.form_name = ffcr.form_name

 ORDER BY ffv.form_name, ffcr.sequence;