/**********************************************************
*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; |
/**********************************************************
*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;