Showing posts with label Query to link a Responsibility to a Set of Books in Oracle. Show all posts
Showing posts with label Query to link a Responsibility to a Set of Books in Oracle. Show all posts

Thursday, 7 April 2011

Query to link a Responsibility to a Set of Books in Oracle


Query to link a 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 = 'GL Set of Books Name'
AND fpo.profile_option_id = fpov.profile_option_id
AND fpov.level_value = fr.responsibility_id