SELECT (SELECT user_profile_option_name
FROM fnd_profile_options_tl fpot
WHERE TRIM (fpot.profile_option_name) =
TRIM (fpo.profile_option_name))
PROFILE,
fpov.profile_option_value VALUE,
DECODE (fpov.level_id,
10001, 'SITE',
10002, 'APPLICATION',
10003, 'RESPONSIBILITY',
10004, 'USER'
) "Apply On",
fa.application_name application,
fr.responsibility_name responsibility, fu.user_name "USER"
FROM fnd_profile_option_values fpov,
fnd_profile_options fpo,
fnd_application_tl fa,
fnd_responsibility_vl fr,
fnd_user fu,
fnd_logins fl
WHERE fpo.profile_option_id = fpov.profile_option_id
AND fa.application_id(+) = fpov.level_value
AND fr.application_id(+) = fpov.level_value_application_id
AND fr.responsibility_id(+) = fpov.level_value
AND fu.user_id(+) = fpov.level_value
AND fl.login_id(+) = fpov.last_update_login
ORDER BY 1, 3
