SELECT
fpot.user_profile_option_name Profile,
decode(fpov.level_id,
10001,'Site',
10002,'Application',
10003,'Responsibility',
10004,'User') Profile_option_level,
decode(fpov.level_id,
10001,'Site',
10002,fa.application_short_name,
10003,frt.Responsibility_name,
10004,fu.user_name) profile_Level_Value,
nvl(fpov.profile_option_value,'Is Null') Profile_option_Value
FROM
fnd_profile_option_values fpov,
fnd_profile_options_tl fpot ,
fnd_profile_options fpo,
fnd_responsibility_tl frt,
fnd_application fa,
fnd_user fu
WHERE
fpo.profile_option_name = fpot.profile_option_name
and fpo.profile_option_id = fpov.profile_option_id
and fpov.level_value = frt.responsibility_id (+)
and fpov.level_value = fa.application_id (+)
and fpov.level_value = fu.user_id (+)
and fpot.user_profile_option_name like ('%FND%Debug%')
No comments:
Post a Comment