Sql query for Leadtime

[Frapacino]

Hi
I am looking for a sql query to analyse the lead time between the promised date of the supplier and the actual date received by our requestor.

Regards
Frapacino

[wenjie]

the time of report show off, you can use this query from our moderator

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;