Conc Request Complete Time Day Wise

select count(*),TRUNC(a.actual_completion_date) from
APPLSYS.fnd_Concurrent_requests a
,APPLSYS.fnd_concurrent_processes b
,applsys.fnd_concurrent_queues q
,APPLSYS.fnd_concurrent_programs_tl c2
,APPLSYS.fnd_concurrent_programs c
,APPLSYS.fnd_user f
--    ,v$session vs
--    ,v$process vp
where 1=1
--and a.REQUEST_ID = 183923555
AND a.controlling_manager    = b.concurrent_process_id
AND a.concurrent_program_id  = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND c2.concurrent_program_id = c.concurrent_program_id
AND c2.application_id        = c.application_id
AND a.requested_by = f.user_id
AND b.queue_application_id   = q.application_id
AND b.concurrent_queue_id    = q.concurrent_queue_id
AND c2.language = 'US'
and c2.concurrent_program_id=57389
and a.actual_completion_date   between to_date('01-NOV-2016 01:40:00','DD-MON-YYYY HH24:MI:SS') and to_Date('21-NOV-2016 23:00:00','DD-MON-YYYY HH24:MI:SS')
group by TRUNC(a.actual_completion_date) ORDER BY 2;


example :
REQUEST_ID START_TIME      END_TIME        COMP_TIME ARGUMENT_TEXT                                 USER_NAME       S P
---------- --------------- --------------- --------- --------------------------------------------- --------------- - -
  11048480 23-OCT 08:34:06 23-OCT 08:39:21      5.25 , 145704                                      428686          C C
  11048688 23-OCT 08:52:17 23-OCT 08:56:20      4.05 , 154046                                      186219          C C
  11048873 23-OCT 09:10:16 23-OCT 09:14:00      3.73 , 154046                                      186219          C C
  11049070 23-OCT 09:26:05 23-OCT 09:29:33      3.47 , 144482                                      428686          C C
  11049192 23-OCT 09:37:26 23-OCT 09:39:48      2.37 , 305806                                      428687          C C
  11049990 23-OCT 10:41:15 23-OCT 10:46:11      4.93 , 64050                                       428686          C C