Wednesday 17 October 2012

Find the Personalization applied on a Oracle Apps Form

SELECT
ffv.form_id ,
ffv.form_name ,
ffv.user_form_name ,
ffv.description "Form Description",
ffcr.SEQUENCE ,
ffcr.description "Personalization Rule Name",
ffcr.TRIGGER_EVENT,
ffcr.TRIGGER_OBJECT,
ffcr.CONDITION,
ffcr.ENABLED "ENABLED OR NOT"
FROM
fnd_form_vl ffv,
fnd_form_custom_rules ffcr
WHERE
ffv.form_name = ffcr.form_name
ffcr.form_name = FORM_NAME  -- GIVE THE FORM NAME
ORDER BY ffv.form_name,Ffcr.Sequence;