Query to get all personalized form

 SELECT DISTINCT ffcr.form_name,
                  ffcr.function_name,
                  func.user_function_name,
                  fat.application_name
    FROM fnd_form_custom_rules ffcr,
         fnd_form_vl          frm,
         fnd_application_tl   fat,
         fnd_form_functions_vl func
   WHERE     1 = 1
         AND frm.form_name = ffcr.form_name
         AND fat.application_id = frm.application_id
         AND fat.language = 'US'
         AND func.form_id = frm.form_id
         AND func.function_name = ffcr.function_name
ORDER BY fat.application_name, ffcr.form_name