Query : Responsibility to a Set of Books in Oracle

SELECT fr.responsibility_name,
fpov.profile_option_value set_of_books_name
FROM fnd_profile_options_vl fpo,
fnd_profile_option_values fpov,
applsys.fnd_responsibility_tl fr
WHERE fpo.user_profile_option_name =
AND fpo.profile_option_id = fpov.profile_option_id
AND fpov.level_value = fr.responsibility_id

Good for 11i

0 comments:

Post a Comment