Query to find profile option values

1SELECT fa.application_name,
2         fpov.level_id,
3         fa.application_short_name,
4         fpo.USER_PROFILE_OPTION_NAME,
5         fpo.PROFILE_OPTION_NAME,
6         DECODE (fpov.level_id,
7                 10001, 'Site',
8                 10002, 'Application',
9                 10003, 'Responsibility',
10                 10004, 'User',
11                 10005, 'Server',
12                 10006, 'Organization',
13                 10007, 'ServResp',
14                 'Unknown')
15            Level_name,
16         DECODE (fpov.LEVEL_ID,
17                 10001, NULL,
18                 10002, fal.APPLICATION_NAME,
19                 10003, frt.RESPONSIBILITY_NAME,
20                 10004, fu.USER_NAME,
21                 10005, svr.node_name,
22                 10006, org.name,
23                 10007,    (SELECT n.node_name
24                              FROM fnd_nodes n
25                             WHERE n.node_id = level_value2)
26                        || '/'
27                        || (DECODE (fpov.level_value,
28                                    -1, 'Default',
29                                    (SELECT responsibility_key
30                                       FROM fnd_responsibility
31                                      WHERE responsibility_id = level_value))),
32                 fpov.level_id)
33            Level_value,
34         fpov.PROFILE_OPTION_VALUE
35    FROM fnd_profile_options_vl  fpo,
36         fnd_profile_option_values fpov,
37         fnd_application_vl      fa,
38         fnd_application_vl      fal,
39         fnd_responsibility_vl   frt,
40         fnd_user                fu,
41         fnd_nodes               svr,
42         hr_operating_units      org
43   WHERE     fpo.profile_option_id = fpov.profile_option_id
44         AND fa.application_id = fpo.application_id
45         AND fpov.LEVEL_VALUE = fal.APPLICATION_ID(+)
46         AND fpov.LEVEL_VALUE = frt.RESPONSIBILITY_ID(+)
47         AND fpov.LEVEL_VALUE = fu.USER_ID(+)
48         AND fpov.LEVEL_VALUE_APPLICATION_ID = frt.APPLICATION_ID(+)
49         AND fpov.level_value = svr.node_id(+)
50         AND fpov.level_value = org.organization_id(+)
51         AND fpo.USER_PROFILE_OPTION_NAME LIKE
52                '<profile option name>'
53ORDER BY USER_PROFILE_OPTION_NAME;