Query to check if DMZ is enabled
select
p.user_profile_option_name “Profile Name”,
decode(v.profile_option_value,
1, ‘Admin’,
2, ‘Normal’,
3, ‘External’,
‘Unknown’) Value,
decode(v.level_id,
10001, ‘SITE’,
10002, (select ‘App:’||a.application_short_name from fnd_application a
where a.application_id = v.level_value),
10003, (select ‘Resp:’||f.RESPONSIBILITY_name||’ (‘||responsibility_key||’)’ from fnd_responsibility_vl f
where f.responsibility_id = v.level_value),
10004, (select ‘User:’||u.user_name from fnd_user u
where u.user_id = v.level_value),
10005, (select ‘Server:’||n.node_name from fnd_nodes n
where n.node_id = v.level_value),
10006, (select ‘Org:’||org.name from hr_operating_units org
where org.name = v.level_value),
‘NOT SET’) “Level Where Option Is Set”
from
fnd_profile_options_vl p,
fnd_profile_option_values v
where
p.profile_option_id = v.profile_option_id (+)
and p.application_id = v.application_id (+)
and p.profile_option_name like upper(‘%TRUST%’)
order by 1,2,3 desc;
