Concurrent Requests status

Select fcrt.USER_CONCURRENT_PROGRAM_NAME
, frt.responsibility_name
, fcr.request_id
, (NVL(fcr.actual_completion_date, sysdate) - fcr.actual_start_date)*24*60 "CURRENT RUNNING TIME(in Mins)"
, (fcr.actual_start_date - fcr.REQUEST_DATE)*24*60 "WAIT TIME(in Mins)"
, (fcr.actual_completion_date - fcr.actual_start_date)*24*60 "RUN TIME(in Mins)"
, fcr.actual_start_date
, fcr.actual_completion_date
, fcr.phase_code
, fcr.status_code
, fcr.completion_text
, fcr.REQUEST_DATE
, fu.USER_NAME
, fcr.PRIORITY
, fcr.REQUESTED_START_DATE
, fcr.NUMBER_OF_COPIES
, fcr.NUMBER_OF_ARGUMENTS
, fcr.PRINT_STYLE
, fcr.REQ_INFORMATION
, fcr.ARGUMENT_TEXT
, fcr.OUTFILE_NAME
, fcr.OFILE_SIZE
, fcr.OUTPUT_FILE_TYPE
, fcr.OUTFILE_NODE_NAME
from fnd_concurrent_requests fcr,
fnd_responsibility_tl frt,
fnd_concurrent_programs_tl fcrt,
fnd_user fu
where fcr.CONCURRENT_PROGRAM_ID = fcrt.CONCURRENT_PROGRAM_ID
and fcrt.LANGUAGE = 'US'
--and fcr.concurrent_program_id IN (7748378,7748233,7747832,77478321)
--And fcr.request_id IN (7748378,7748233,7747832,77478321)
--And fcrt.USER_CONCURRENT_PROGRAM_NAME like ('Belron Batch Pick Slip Report') ,('%Pick%')
--And fcrt.USER_CONCURRENT_PROGRAM_NAME like '%Period close value summary%'
--And fcrt.USER_CONCURRENT_PROGRAM_NAME like 'BELRON - Optimiza Bridge File - Data Files'
--And fcrt.USER_CONCURRENT_PROGRAM_NAME like '%Gather%'
and fcr.responsibility_application_id = frt.application_id
and fcr.REQUESTED_BY = fu.user_id
and frt.language = 'US'
and fcr.responsibility_id = frt.responsibility_id
and fcr.phase_code = 'R'
and fcr.status_code = 'R'
--and fcr.actual_start_date like Sysdate
-- and (upper(frt.responsibility_name) like UPPER('%Laddaw%')
-- OR
-- upper(frt.responsibility_name) like UPPER('%Bardon%'))
--order by request_id DESC
order by (NVL(fcr.actual_completion_date, sysdate) - fcr.actual_start_date)*24*60 desc






Status Code Phase Code
============= ================
CODE MEANING CODE MEANING

A Waiting C Completed
B Resuming I Inactive
C Normal P Pending
D Cancelled R Running
E Error
G Warning
H On Hold
I Normal
M No Manager
P Scheduled
Q Standby
R Normal
S Suspended
T Terminating
U Disabled
W Paused
X Terminated
Z Waiting