Concurrent Request Details

SELECT fc.request_id, application_name, responsibility_name,
       program_short_name, user_concurrent_program_name, fc.argument_text,
       requestor,
       (   FLOOR (  (  (fc.actual_completion_date - fc.actual_start_date)
                     * 24
                     * 60
                     * 60
                    )
                  / 3600
                 )
        || ' HOURS '
        || FLOOR (  (  (  (fc.actual_completion_date - fc.actual_start_date)
                        * 24
                        * 60
                        * 60
                       )
                     -   FLOOR (  (  (  fc.actual_completion_date
                             

        - fc.actual_start_date
                                     )
                                   * 24
                                   * 60
                                   * 60
                                  )
                                / 3600
                               )
                       * 3600
                    )
                  / 60
                 )
        || ' MINUTES '
        || ROUND ((  (  (fc.actual_completion_date - fc.actual_start_date)
                      * 24
                      * 60
                      * 60
                     )
                   -   FLOOR (  (  (  fc.actual_completion_date
                                    - fc.actual_start_date
                                   )
                                 * 24
                                 * 60
                                 * 60
                                )
                              / 3600
                             )
                     * 3600
                   - (  FLOOR (  (  (  (  fc.actual_completion_date
                                        - fc.actual_start_date
                                       )
                                     * 24
                                     * 60
                                     * 60
                                    )
                                  -   FLOOR (  (  (  fc.actual_completion_date
                                                   - fc.actual_start_date
                                                  )
                                                * 24
                                                * 60
                                                * 60
                                               )
                                             / 3600
                                            )
                                    * 3600
                                 )
                               / 60
                              )
                      * 60
                     )
                  )
                 )
        || ' SECS '
       ) RUN_TIME , TO_CHAR(fc.actual_start_date)run_date,
       user_print_style, output_file_type, outfile_name, logfile_name,
       fc.completion_text
  FROM fnd_conc_req_summary_v fcr,
       fnd_application_tl fa,
       fnd_responsibility_tl fr,
       fnd_concurrent_requests fc
 WHERE 1 = 1
   AND fcr.responsibility_application_id = fa.application_id
   AND fcr.responsibility_id = fr.responsibility_id  
   AND fc.request_id = fcr.request_id
   AND fc.request_id = 6948615