————————————————————-
EBS Find a concurrent program running time
————————————————————-
SELECT fcr.request_id,
user_concurrent_program_name,
ROUND ( (fcr.actual_completion_date – Actual_start_date) * 24 * 60, 2) time_in_min,
fcr.actual_completion_date,
Actual_start_date
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt
WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
AND fcp.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID
AND user_concurrent_program_name LIKE ‘%Report%’
ORDER BY fcr.request_id DESC;