Query to retrieve profile seetings which are customized for user
select user_profile_option_name,
decode(level_id,
10001,
'Site',
10002,
'Application',
10003,
'Responsibility',
10004,
'User',
10005,
'Server',
'UnDef'),
usr.user_Name,
optval.*
from fnd_profile_option_values optval
join FND_PROFILE_OPTIONS_VL opt
on opt.profile_option_id = optval.PROFILE_OPTION_ID
join FND_USER usr
on optval.level_value = usr.user_id
where level_id = 10004
No comments:
Post a Comment