Query to find responsibility for Operating Unit or Org_id

1 2 3 4 5 6 7 8 9 10 11 12 13

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