Sunday, February 23, 2014

How to find out GL Set of Books of a Responsibility in Oracle Apps R12

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
   AND fr.responsibility_name LIKE 'XXDA_DA_RESP%'

No comments:

Post a Comment