To find out about the given Request ID Details

select r.REQUEST_ID
,u.user_name
, decode(r.PHASE_CODE,'C', 'Complete','P', 'Pending', 'R', 'Running', r.PHASE_CODE) phase
,decode(r.STATUS_CODE, 'C', 'Normal','I' ,'Normal','R' ,'Normal','Q', 'Standby', 'E' ,'Error', 'X' ,'Terminated','W', 'Paused' , r.STATUS_CODE) status
,r.PRIORITY
,decode(r.HOLD_FLAG,'N','"NOT on hold"','Y','"ON HOLD"',r.HOLD_FLAG) Hold_flag
, p.application_short_name
, f.user_concurrent_program_name
, v.RESPONSIBILITY_name
, r.REQUEST_CLASS_APPLICATION_ID
, q.request_class_name
, r.PARENT_REQUEST_ID
,to_char(r.REQUESTED_START_DATE,'DD-MON-YYYY HH:MI') requested_start_date
,to_char(r.ACTUAL_START_DATE,'DD-MON-YYYY HH:MI') actual_start_date
,decode(r.ACTUAL_COMPLETION_DATE,null,'"Still Running"',to_char(r.ACTUAL_COMPLETION_DATE,'DD-MON-YYYY HH:MI')) actual_completion_date
,to_char(decode(r.ACTUAL_COMPLETION_DATE,null,SYSDATE,r.ACTUAL_COMPLETION_DATE)-decode(r.ACTUAL_START_DATE,null,SYSDATE,r.ACTUAL_START_DATE),'MI') "Time Running"
,r.CPU_SECONDS
,r.LOGICAL_IOS
,r.PHYSICAL_IOS
,r.ORACLE_PROCESS_ID
,r.ORACLE_SESSION_ID
,r.OS_PROCESS_ID
,r.CD_ID
,r.ARGUMENT_TEXT Parameters
from fnd_concurrent_requests r
, fnd_user u
, fnd_application p
, fnd_concurrent_programs_vl f
, fnd_responsibility_vl v
, fnd_concurrent_request_class q
where u.user_id = r.requested_by
and p.application_id = r.PROGRAM_APPLICATION_ID
and r.CONCURRENT_PROGRAM_ID = f.CONCURRENT_PROGRAM_ID
and v.responsibility_id = r.responsibility_id
and q.request_class_id (+)= r.concurrent_request_class_id
and r.request_id = &reqid;