Oracle Syatem Profile setup at different levels

Query to find out a specific profile setup at different levels :-

In the query below I have taken standard profile 'FND: Debug Log Enabled', you can change it accordingly for the profile you want to check.

Pass user profile name in the query.

Query :- 

SELECT po.profile_option_name "NAME",org.name name1,
pot.USER_PROFILE_OPTION_NAME,
        decode(to_char(pov.level_id),
               '10001', 'SITE',
               '10002', 'APP',
               '10003', 'RESP',
               '10005', 'SERVER',
               '10006', 'ORG',
               '10004', 'USER', '???') "LEV",
        decode(to_char(pov.level_id),
               '10001', '',
               '10002', app.application_short_name,
               '10003', rsp.responsibility_key,
               '10005', svr.node_name,
               '10006', org.name,
               '10004', usr.user_name,
               '???') "CONTEXT",
        pov.profile_option_value "VALUE"
FROM   apps.FND_PROFILE_OPTIONS po,
        apps.fnd_profile_options_tl pot,
        apps.FND_PROFILE_OPTION_VALUES pov,
        apps.fnd_user usr,
        apps.fnd_application app,
        apps.fnd_responsibility rsp,
        apps.fnd_nodes svr,
        apps.hr_all_organization_units org
WHERE  pot.user_profile_option_name like 'FND: Debug Log Enabled'
and    po.profile_option_name = pot.profile_option_name
AND    pov.application_id = po.application_id
AND    pov.profile_option_id = po.profile_option_id
AND    usr.user_id (+) = pov.level_value
AND    rsp.application_id (+) = pov.level_value_application_id
AND    rsp.responsibility_id (+) = pov.level_value
AND    app.application_id (+) = pov.level_value
AND    svr.node_id (+) = pov.level_value
AND    org.organization_id (+) = pov.level_value
ORDER BY "NAME", pov.level_id, "VALUE";


Output :- 

Feel free to ask questions :)