Post date: Jul 03, 2013 12:38:33 PM
SELECT ffv.form_id ,
ffv.form_name ,
ffv.user_form_name ,
ffv.description "Form Description",
ffcr.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;
SELECT * FROM fnd_form_custom_rules;
Source: http://oracleappsdna.com/2012/02/oracle-sql-query-to-list-all-form-personalizations/