Profile option check – Initialization SQL Statement – Oracle

————————————————————————-
—     Author : Jay Gopal
————————————————————————-
select po.profile_option_name “NAME”,
po.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   FND_PROFILE_OPTIONS_VL po,
FND_PROFILE_OPTION_VALUES pov,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where  po.USER_PROFILE_OPTION_NAME like ‘%SQL%Statement%’
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”;