Get Average Runtime of A Concurrent

SELECT
fcp.description "Description",

TRUNC (

AVG (

(TO_NUMBER (TO_CHAR (actual_completion_date, 'SSSSS'))

- TO_NUMBER (TO_CHAR (actual_start_date, 'SSSSS')))

/ 60),

2)

"Time in Min."

FROM
fnd_concurrent_programs_vl fcp,
fnd_concurrent_requests fcr

WHERE
fcp.application_id = fcr.program_application_id

AND fcp.concurrent_program_id = fcr.concurrent_program_id

AND TO_CHAR (actual_completion_date, 'DD-MON-YY') =

TO_CHAR (actual_start_date, 'DD-MON-YY')

GROUP BY fcp.description

ORDER BY fcp.description;