Concurrent Runnung status

SELECT a.REQUEST_ID,  REQUEST_DATE, func_getshift(REQUEST_DATE) shift, trunc(REQUEST_DATE) req_dt, REQUESTOR, ARGUMENT_TEXT,
--b.full_name,
PROGRAM, ACTUAL_start_DATE, ACTUAL_COMPLETION_DATE,
floor(sysdate - ACTUAL_start_DATE) || ' days(s) ' ||
   trunc( 24*((sysdate-ACTUAL_start_DATE) -
   trunc(sysdate-ACTUAL_start_DATE))) || ' hour(s) ' ||
   mod(trunc(1440*((sysdate-ACTUAL_start_DATE) -
   trunc(sysdate-ACTUAL_start_DATE))), 60) ||' minute(s) ' ||
   mod(trunc(86400*((sysdate-ACTUAL_start_DATE) -
   trunc(sysdate-ACTUAL_start_DATE))), 60) ||' seconds' Running_time,
round((SYSDATE- ACTUAL_START_DATE) * 24*60,2) Minutes,
--AD_CORE.GET_FORMATTED_ELAPSED_TIME((actual_completion_date - actual_start_date), 2 ) Elapsed,
AD_CORE.GET_FORMATTED_ELAPSED_TIME((SYSDATE - actual_start_date), 2 ) Elapsed,
--round((SYSDATE - ACTUAL_START_DATE) * 24*60,2) Minutes_run,
PHASE_CODE, DECODE(PHASE_CODE, 'C', 'Completed', 'I', 'Inactive','P', 'Pending','R', 'Running') PHASE_CODE_NAME,
STATUS_CODE, DECODE(STATUS_CODE,'A','Waiting','B','Resuming','C', 'Normal','D', 'Cancelled','E', 'Error','F', 'Scheduled','G', 'Warning','H', 'On Hold',
'I', 'Normal','M', 'No Manager','P','Pending', 'Q', 'Standby', 'R', 'Normal','S', 'Suspended', 'T', 'Terminating','U', 'Disabled',
'W', 'Paused', 'X', 'Terminated', 'Z', 'Waiting') STATUS_CODE_NAME
FROM apps.FND_CONC_REQ_SUMMARY_V a
     --apps.per_all_people_f b
WHERE  --a.REQUESTOR = b.EMPLOYEE_NUMBER(+)
--PROGRAM like 'TNPL AP Creditors Ledger Details for a Period Internal'
--PROGRAM like 'TNPL INV%Reel/Bundle List Internal'
PROGRAM LIKE '%'
--PROGRAM LIKE 'TNPL Finished Good Invoice Generation%'
--PROGRAM LIKE 'TNPL Finished Good Invoice Generation%' 
--PROGRAM LIKE 'Inventory transaction worker'
--PROGRAM LIKE 'India - Receiving Transaction Processor (India - Receiving Transaction Processor)'
--PROGRAM LIKE 'TNPL Automated Branch Receipts (Report Set)'
--program like 'TNPL Weighment Transaction Summary Report'
--PROGRAM LIKE 'India - Receiving Transaction Processor for Deliver (India - Receiving Transaction Processor)'       
/*
in ('TNPL OM PWP Indentor Wise Dispatch Details Report internal',
'TNPL OM Shift wise Dispatch Summary Internal',
'TNPL OM Loading Sheet with Abstract Internal' ) */
--PROGRAM like 'TNPL Finisher Code Lot Attribute Update'
--PROGRAM like 'Actual Cost Processing (OPM Actual Cost Program)'
--PROGRAM like '%TNPL Branch Invoice Generation (Report Set)%'
--and PROGRAM like 'TNPL_BUNDLE_MMTL_ISSUE' --- 'TNPL Bundle Issue Manager' --Actual Cost Processing (OPM Actual Cost Program)'
--and round((ACTUAL_COMPLETION_DATE- ACTUAL_START_DATE) * 24*60,2) >= 10
--and round((sysdate - ACTUAL_start_DATE) * 24*60,2)
and actual_start_date >= sysdate - 4
AND phase_code ='R'
AND status_code  IN ('R')
--AND REQUESTOR like '1542'
--and request_id in (12530234)
order by 11 desc
--order by ACTUAL_COMPLETION_DATE desc