Overview:
Below query give the form personalization details.
Query:
SELECT DISTINCT a.ID, a.SEQUENCE, a.function_name, a.form_name, a.enabled,
c.user_form_name, d.application_name, a.description,
a.trigger_event, a.trigger_object, a.condition, ca.*
FROM fnd_form_custom_rules a,
fnd_form b,
fnd_form_tl c,
fnd_application_tl d,
fnd_form_custom_actions ca
WHERE a.form_name = b.form_name
AND b.form_id = c.form_id
AND b.application_id = d.application_id
— AND D.Application_Id = 660 –For Order Management
— AND C.User_Form_Name LIKE ‘Sales%’ –All the Forms that Start with Sales
AND c.user_form_name =:p
–‘XX service contract additional information’
AND a.enabled = ‘Y’
AND a.ID = ca.rule_id
ORDER BY a.SEQUENCE
Recent Posts
