SELECT frv.responsibility_name,
fpo.profile_option_name,
fpot.user_profile_option_name,
fpov.profile_option_value
FROM fnd_profile_options_tl fpot,
fnd_profile_options fpo,
fnd_profile_option_values fpov,
FND_RESPONSIBILITY_VL frv
WHERE fpot.profile_option_name =
fpo.profile_option_name
AND fpo.profile_option_id
= fpov.profile_option_id
AND fpov.level_id
= '10003'
AND fpov.level_value
= frv.responsibility_id
--AND frv.responsibility_name
= 'General Ledger Super User'
order by frv.responsibility_name;
No comments:
Post a Comment