Sunday, February 23, 2014

How to find out Operating Unit of Responsibility in Oracle Apps R12

SELECT fr.responsibility_name, fpov.profile_option_value orgid, NAME org_name
  FROM fnd_profile_options_vl fpo,
       fnd_profile_option_values fpov,
       applsys.fnd_responsibility_tl fr,
       hr_operating_units hou
 WHERE UPPER (fpo.user_profile_option_name) LIKE UPPER ('MO%OPERATIN%')
   AND profile_option_name = 'ORG_ID'
   AND fpo.profile_option_id = fpov.profile_option_id
   AND TO_NUMBER (fpov.level_value) = fr.responsibility_id
   AND TO_CHAR (hou.organization_id) = TO_CHAR (fpov.profile_option_value)
   AND fr.responsibility_name LIKE 'XXDA_DA_AYAAN_RESP%'

No comments:

Post a Comment