Page 1 of 1
Sql query for Leadtime
Posted: Sat Oct 31, 2009 4:40 pm
by 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
Posted: Wed Nov 11, 2009 11:44 pm
by 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;