Query to find Form Personalization

 I found this query at http://ravivarma1985.blogspot.com/2012/05/sql-query-to-get-list-of.html. Thought I would re-post it for my own personal reference. Might come in handy.

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;