Oracle SQL Query to list all Form Personalizations

By | February 4, 2012
/**********************************************************
 *PURPOSE: To list all forms personalizations             *
 *AUTHOR: Shailender Thallam                              *
 **********************************************************/
 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;
WOW! Did you like this post? We'll send more interesting posts like Oracle SQL Query to list all Form Personalizations to you!
Enter your Email Address: