Query to view all Form Personalizations in Oracle Apps

 SELECT fp.application_id

       ,fp.application_short_name

   ,fpt.application_name

   ,ff.form_name

   ,fft.user_form_name

   ,fft.description

   ,fff.function_name

   ,ffft.user_function_name

   ,ffft.description

   ,ffcr.function_name

   ,ffcr.description

   ,ffcr.trigger_event

   ,ffcr.trigger_object

   ,ffcr.condition

   ,ffcr.sequence

   ,ffcr.enabled

   ,frt.responsibility_name

   ,frt.description

   ,fu.user_id

   ,fu.user_name

   FROM fnd_application fp

       ,fnd_application_tl fpt

       ,fnd_form ff

       ,fnd_form_tl fft

       ,fnd_form_functions fff

       ,fnd_form_functions_tl ffft

       ,fnd_form_custom_rules ffcr

       ,fnd_form_custom_scopes ffcs

       ,fnd_responsibility_tl frt

       ,fnd_user fu

       ,fnd_form_custom_actions ffca

       ,fnd_form_custom_prop_list ffcpl

 WHERE fp.application_id = fpt.application_id

   AND fpt.application_id = ff.application_id

   AND ff.form_id = fft.form_id

   AND ff.form_id = fff.form_id 

   AND fff.function_id = ffft.function_id

   AND ff.form_name = ffcr.form_name

   AND ffcr.function_name = fff.function_name

   AND ffcr.id = ffcs.rule_id

   AND ffcs.created_by = fu.user_id

   and ffcr.last_updated_by = fu.user_id

   and ff.last_updated_by = fu.user_id