Query to find difference between concurrent start time and complete time

e

  SELECT   fcr.request_id,
           fu.user_name,
           FCP.USER_CONCURRENT_PROGRAM_NAME Report_Name,
           ARGUMENT_TEXT Parameters,
           MAX (FCRC.DATE1) SCHEDULED_PROG_START_DATE,
           MAX (FCRC.DATE2) SCHEDULED_PROG_END_DATE,
           NVL ( (DECODE (STATUS_CODE,
                          'C',
                          'COMPLETED',
                          'R',
                          'RUNNING',
                          'G',
                          'WARNING',
                          'D',
                          'CANCELLED',
                          'X',
                          'TERMINATED',
                          'E',
                          'ERROR')), STATUS_CODE)
              statUS,
           REQUESTED_START_DATE,
           ACTUAL_START_DATE,
           ACTUAL_COMPLETION_DATE,
           TO_CHAR (
              TRUNC( (  (ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE)
                      * 24
                      * 60
                      * 60)
                    / 60
                    / 60),
              '09'
           )
           || 'HR'
           || TO_CHAR (
                 TRUNC(MOD (
                          (  (ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE)
                           * 24
                           * 60
                           * 60),
                          3600
                       )
                       / 60),
                 '09'
              )
           || 'MIN'
           || TO_CHAR (
                 MOD (
                    MOD (
                       (  (ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE)
                        * 24
                        * 60
                        * 60),
                       3600
                    ),
                    60
                 ),
                 '09'
              )
           || 'SEC'
              Time_difference,
           '' comments,
           '' Solved
    FROM   fnd_concurrent_requests fcr,
           fnd_concurrent_programs_tl fcp,
           fnd_conc_release_classes FCRC,
           fnd_user fu
   WHERE       fcr.CONCURRENT_PROGRAM_ID = fcp.CONCURRENT_PROGRAM_ID
           AND fcr.REQUESTED_BY = fu.user_id
           AND fcr.release_class_id = fcrc.release_class_id(+)
           AND fcr.concurrent_program_id = 41587
           -- AND fcp.user_concurrent_program_name --LIKE 'Pre%'
           --           IN ('Pregenerate putaway suggestions')
           --  ( 'Pre)
           AND TRUNC (fcr.REQUESTED_START_DATE) BETWEEN TRUNC (SYSDATE - 1)
                                                    AND  TRUNC (SYSDATE)
           --           AND FCR.REQUESTED_BY = 2678
           AND status_code = 'Q'                           --NOT IN ('Q', 'I')
--           AND phase_code <> 'P'
GROUP BY   request_id,
           FCP.USER_CONCURRENT_PROGRAM_NAME,
           STATUS_CODE,
           REQUESTED_START_DATE,
           ACTUAL_START_DATE,
           ACTUAL_COMPLETION_DATE,
           ARGUMENT_TEXT,
           fu.user_name
ORDER BY   2