SELECT
fcp.description "Description",
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
fnd_concurrent_programs_vl fcp,
fnd_concurrent_requests fcr
WHERE
fcp.application_id = fcr.program_application_id
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;
No comments:
Post a Comment