Consulta para checar todas as responsabilidades onde um dado concorrente esta disponível.
select b.responsibility_name
,c.request_group_name
,ie.concurrent_program_name
,f.description
from APPS.FND_RESPONSIBILITY a
, APPS.FND_RESPONSIBILITY_TL b
, APPS.FND_REQUEST_GROUPS c
, APPS.FND_REQUEST_GROUP_UNITS d
, APPS.FND_CONCURRENT_PROGRAMS ie
, APPS.FND_CONCURRENT_PROGRAMS_TL f
where a.application_id = b.application_id
and a.responsibility_id = b.responsibility_id
and a.application_id = c.application_id
and a.request_group_id = c.request_group_id
and c.application_id = d.application_id
and c.request_group_id = d.request_group_id
and d.request_unit_id = ie.concurrent_program_id
and ie.application_id = f.application_id
and ie.concurrent_program_id = f.concurrent_program_id
and upper(f.user_concurrent_program_name) Like upper(‘%NOME DO CONCORRENTE%’)