Get details of concurrent requests / programs that are executed by a specific user from a specific responsibility between certain dates.

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 ;