Find the Responsibility name from which a concurrent program can be run


select distinct
 
a.application_id,
 
a.concurrent_program_id,
 
a.user_concurrent_program_name,
 
a.description,
 
b.request_group_id,
 
request_group_name,
 
e.responsibility_name
 
from fnd_concurrent_programs_tl a,
 
fnd_request_groups b,
 
fnd_request_group_units c,
 
fnd_responsibility d,
 
fnd_responsibility_tl e
 
where a.concurrent_program_id = c.request_unit_id
 
and b.request_group_id = c.request_group_id
 
and b.request_group_id = d.request_group_id
 
and d.responsibility_id = e.responsibility_id
 
and a.application_id = b.application_id
 
and b.application_id = c.application_id
 
and d.application_id = e.application_id
 
-- and a.user_concurrent_program_name like 'XX%'
 
and a.concurrent_program_id = 45220
 
 
 
 
 

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...