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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
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 ‘PRUDHVI’ |