List Forms Personalization and XX-Forms

In a R12 upgrade project it can be a good idea to read some information from the database regarding the customizations.

List Forms Personalization

SELECT ft.user_function_name, 
       fo.form_name,
       c.* 
FROM fnd_form_custom_rules c,
     fnd_form_functions f,
     fnd_form_functions_tl ft,
     fnd_form fo
WHERE c.function_name = f.function_name
AND   f.function_id = ft.function_id
AND   f.form_id = fo.form_id
ORDER BY 2

List Custom Forms

SELECT ft.user_form_name,
       f.* 
FROM fnd_form f,
     fnd_form_tl ft
WHERE f.form_id = ft.form_id
AND   form_name LIKE 'XX%'
ORDER BY 4