Concurrent Request and Program related Scripts

This page will include the scripts
1. Find the responsibility name from which a concurrent program can be run
2. Find the responsibility name from which user has ran the concurrent program
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

Find from which responsibility user has ran the concurrent program

select distinct
 
user_concurrent_program_name,
 
responsibility_name,
 
user_name, 
 
request_date,
 
argument_text, 
 
request_id,
 
requested_by,
 
phase_code,
 
status_code,
 
a.concurrent_program_id,
 
a.responsibility_id,
 
logfile_name,
 
outfile_name
 
from fnd_concurrent_requests a,
 
fnd_concurrent_programs_tl b,
 
fnd_responsibility_tl c,
 
fnd_user d
 
where a.CONCURRENT_PROGRAM_ID = b.concurrent_program_id
 
and a.responsibility_id = c.responsibility_id
 
and a.requested_by = d.user_id 
 
and user_name like 'PRUDHVIA'