Saturday, October 3, 2009

Query to Check List of Form personalizations

SELECT ID,
DECODE (level_id,
20, 'Site',
30, 'Responsibility',
40, 'User'
) level1,
(SELECT fr.responsibility_name
FROM fnd_responsibility_vl fr
WHERE fr.responsibility_id(+) = b.level_value
AND b.level_id = 30) resp,
(SELECT fu.user_name
FROM fnd_user fu
WHERE fu.user_id = b.level_value AND b.level_id = 40) user_name,
SEQUENCE, function_name, form_name, a.description, trigger_event,
trigger_object, condition, rule_type
FROM apps.fnd_form_custom_rules a, apps.fnd_form_custom_scopes b
WHERE 1 = 1
AND b.rule_id = a.ID
AND form_name = :p_form_name
AND a.enabled = 'Y'
ORDER BY SEQUENCE, function_name, ID

No comments:

Post a Comment

Blog Archive