Get details of concurrent requests / programs that are executed by a specific user from a specific responsibility between certain dates.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
SELECT fcp.user_concurrent_program_name, fcr.request_id, fcr.request_date, fu.user_name Requested_By , fr.responsibility_name FROM fnd_concurrent_requests fcr , fnd_concurrent_programs_tl fcp , fnd_user fu , fnd_responsibility_tl fr WHERE 1 =1 AND fcr.concurrent_program_id = fcp.concurrent_program_id AND fcr.requested_by = fu.user_id AND fcr.responsibility_id = fr.responsibility_id AND fu.user_name = :p_UserName AND fr.responsibility_name = :p_ResponsibilityName –and fcr.request_id=pRequestID AND fcr.request_date between :p_from_date and :p_to_date ; |