Query to find Form Personalization

1SELECT DISTINCT
2         ffv.form_name,
3         user_form_name,
4         fcr.function_name,
5         fff.user_function_name,
6         fcr.description per_description,
7         trigger_event,
8         trigger_object,
9         condition,
10         enabled,
11         (SELECT user_name
12            FROM fnd_user fu
13           WHERE fu.user_id = fcr.created_by)
14            created_by,
15         DECODE (fcr.rule_type,  'F', 'Form',  'A', 'Function')
16            personalize_rule_level,
17         DECODE (fcs.level_id,
18                 10, 'Industry',
19                 20, 'Site',
20                 30, 'Responsibility',
21                 40, 'User')
22            context_level,
23         DECODE (fcs.level_id,
24                 10, '',
25                 20, '',
26                 30, frt.responsibility_name,
27                 40, fu.user_name)
28            context_level_value
29    FROM fnd_form_custom_rules fcr,
30         fnd_form_custom_scopes fcs,
31         fnd_form_functions_vl fff,
32         fnd_responsibility_tl frt,
33         fnd_user             fu,
34         fnd_form_vl          ffv
35   WHERE     fcs.rule_id = fcr.ID
36         AND fcr.function_name = fff.function_name
37         AND fcs.level_value = frt.responsibility_id(+)
38         AND fcs.level_value = fu.user_id(+)
39         AND ffv.form_name = fcr.form_name
40ORDER BY form_name