SELECT frt.responsibility_name,
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

Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search