Get details of concurrent requests which are running currently and also the script will provide details of who is running the request and from which responsibility
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SELECT fcp.user_concurrent_program_name, fcr.request_id, fcr.request_date, fu.user_name Requested_By , fr.responsibility_name, TO_CHAR(fcr.actual_start_date,’DD-MON-YYYY HH24:MI:SS’) actual_start_date FROM fnd_concurrent_requests fcr , fnd_concurrent_programs_tl fcp , fnd_user fu , fnd_responsibility_tl fr WHERE 1 =1 AND fcr.phase_code =’R’ AND fcr.concurrent_program_id = fcp.concurrent_program_id AND fcr.requested_by = fu.user_id AND FCR.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID ; |