Find the right responsibility for your concurrent program with OU for particular parameter

SELECT frt.responsibility_name,

               frg.request_group_name,

               frg.description

  FROM fnd_request_groups frg

             ,fnd_request_group_units frgu

             ,fnd_concurrent_programs fcp

             ,fnd_concurrent_programs_tl fcpt

             ,fnd_responsibility_tl frt

             ,fnd_responsibility frs

 WHERE frgu.unit_application_id = fcp.application_id

 AND   frgu.request_unit_id = fcp.concurrent_program_id

 AND   frg.request_group_id = frgu.request_group_id

 AND   frg.application_id = frgu.application_id

 AND   fcpt.source_lang = USERENV('LANG')

 AND   fcp.application_id = fcpt.application_id

 AND   fcp.concurrent_program_id = fcpt.concurrent_program_id

 AND   frs.application_id = frt.application_id

 AND   frs.responsibility_id = frt.responsibility_id

 AND   frt.source_lang = USERENV('LANG')

 AND   frs.request_group_id = frg.request_group_id

 AND   frs.application_id = frg.application_id

---- AND   fcp.concurrent_program_name = <shortname>

 AND   fcpt.user_concurrent_program_name LIKE 'EU Printed PO Report'---Give concur prgm name

 AND RESPONSIBILITY_NAME IN (SELECT frv.responsibility_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 = ' Europe Consolidated'----Give you 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

)