Friday, January 17, 2020

Query to list all Form Personalizations oracle apps


 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;

No comments:

Post a Comment