Oracle EBS R12/R12.2: SQL query to find all running concurrent requests

Oracle EBS R12/R12.2: SQL query to find all running concurrent requests  

connect sqlplus as apps user and run below query:

col USER_CONCURRENT_PROGRAM_NAME for a30

col REQUESTED_BY for a15
col RESPONSIBILITY_NAME for a25
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;