I need a sql query to identify all the responsibilities, menus that are attached to a concurrent program. If I pass a concurrent program as a parameter to the sql query, the output must show all the responsibilities and menus which attached to that concurrent program.

Interview Candidate
Nov 8th, 2006
2
4473

Showing Answers 1 - 2 of 2 Answers

Ashish

Nov 8th, 2006

select resp.responsibility_name
from fnd_responsibility_vl resp, fnd_request_group_units rgu, fnd_concurrent_programs_vl prog
where resp.request_group_id = rgu.request_group_id
AND rgu.request_unit_id = prog.concurrent_program_id
AND rgu.unit_application_id = prog.application_id
AND prog.user_concurrent_program_name = '.................'

sjakkula
Profile Answers by sjakkula

Nov 14th, 2007

select responsibility_name resp,fm.menu_name
from fnd_responsibility_vl resp, fnd_request_group_units rgu, fnd_concurrent_programs_vl prog
,fnd_menus fm
where resp.request_group_id = rgu.request_group_id
AND fm.menu_id = resp.menu_id
AND rgu.request_unit_id = prog.concurrent_program_id
AND rgu.unit_application_id = prog.application_id
AND prog.user_concurrent_program_name = 'Financial Adjustments Report'
order by resp