SQL Query to find Concurrent Request Details

--------------------------Query Starts--------------------------
alter session set current_schema=apps;

SELECT
  FCR.REQUEST_ID,
  FR.RESPONSIBILITY_NAME,
  FCP.CONCURRENT_PROGRAM_NAME,
  FCPT.USER_CONCURRENT_PROGRAM_NAME,
  FCR.ARGUMENT_TEXT,
  FCR.REQUEST_DATE,
  FCR.PHASE_CODE,
  FCR.STATUS_CODE,
  FCR.ACTUAL_START_DATE,
  FCR.ACTUAL_COMPLETION_DATE,
 ceil((FCR.ACTUAL_COMPLETION_DATE- FCR.ACTUAL_START_DATE)*24*60) "Time(Min)",
  FCR.COMPLETION_TEXT,
  FU.USER_NAME,
  FCR.LOGFILE_NAME,
  FCR.OUTFILE_NAME,
  FCR.ORACLE_SESSION_ID
FROM
  FND_CONCURRENT_REQUESTS FCR,
  FND_CONCURRENT_PROGRAMS FCP,
  FND_CONCURRENT_PROGRAMS_TL FCPT,
  FND_RESPONSIBILITY_TL FR,
  FND_USER FU
WHERE
  1=1
  --and REQUEST_ID=25045446
AND FCR.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID
AND FR.RESPONSIBILITY_ID     = FCR.RESPONSIBILITY_ID
AND FCP.CONCURRENT_PROGRAM_ID=FCPT.CONCURRENT_PROGRAM_ID
AND FCR.REQUESTED_BY         = FU.USER_ID
--AND CONCURRENT_PROGRAM_NAME = 'XLGLCURVAL'
--  AND USER_CONCURRENT_PROGRAM_NAME like  '%Invoice%Validation%'
--  and fr.RESPONSIBILITY_KEY='RESP_KEY'
--  and  FU.USER_NAME= 'USERNAME'
--  AND FCR.REQUEST_ID=30235254
  --AND FCR.REQUEST_DATE > SYSDATE-1
--AND FCR.phase_CODE='P'
and fcr.status_code ='R'
--and fcr.argument_text like '%2041,%'
ORDER BY
  request_id DESC;
--------------------------Query Ends--------------------------