Query to get Responsibility and Operating Unit association details

Get Org id from Responsibility Name

SELECT   frv.responsibility_name,

         fpov.profile_option_value org_id,

         hou.NAME

    FROM apps.hr_organization_units hou,

         apps.fnd_profile_options_vl fpo,

         apps.fnd_profile_option_values fpov,

         apps.fnd_responsibility_vl frv

   WHERE frv.responsibility_name = <Responsibility Name>

     AND fpov.level_value = frv.responsibility_id

     AND fpo.profile_option_id = fpov.profile_option_id

     AND fpo.user_profile_option_name = 'MO: Operating Unit'

     AND fpov.profile_option_id = fpo.profile_option_id

     AND hou.organization_id =TO_NUMBER(fpov.profile_option_value)
 ORDER BY frv.responsibility_name

GET RESPONSIBILITY Name  from Org id

--------------------------------------------------------

SELECT   frv.responsibility_name,

         fpov.profile_option_value org_id,

         hou.NAME

    FROM apps.fnd_profile_options_vl fpo,

         apps.fnd_responsibility_vl frv,

         apps.fnd_profile_option_values fpov,

         apps.hr_organization_units hou

   WHERE hou.NAME = <OU Name>

     AND fpov.profile_option_value = TO_CHAR (hou.organization_id)

     AND fpo.profile_option_id = fpov.profile_option_id

     AND fpo.user_profile_option_name = 'MO: Operating Unit'

     AND frv.responsibility_id = fpov.level_value

ORDER BY frv.responsibility_name