SELECT frsp.sequence,
fcp.user_concurrent_program_name,
fe.execution_file_name,
(SELECT ROUND (
AVG ( (actual_completion_date - actual_start_date) * 1440),
2)
AVG
FROM fnd_concurrent_Requests
WHERE concurrent_program_id = frsp.concurrent_program_id)
avg_time
FROM fnd_request_set_programs frsp,
fnd_concurrent_programs_vl fcp,
fnd_executables fe
WHERE request_set_id =
(SELECT request_set_id
FROM fnd_request_sets_tl
WHERE UPPER (user_request_set_name) = UPPER ('GIL MV Refresh'))
AND frsp.concurrent_program_id = fcp.concurrent_program_id
AND fe.executable_id = fcp.executable_id
ORDER BY sequence
fcp.user_concurrent_program_name,
fe.execution_file_name,
(SELECT ROUND (
AVG ( (actual_completion_date - actual_start_date) * 1440),
2)
AVG
FROM fnd_concurrent_Requests
WHERE concurrent_program_id = frsp.concurrent_program_id)
avg_time
FROM fnd_request_set_programs frsp,
fnd_concurrent_programs_vl fcp,
fnd_executables fe
WHERE request_set_id =
(SELECT request_set_id
FROM fnd_request_sets_tl
WHERE UPPER (user_request_set_name) = UPPER ('GIL MV Refresh'))
AND frsp.concurrent_program_id = fcp.concurrent_program_id
AND fe.executable_id = fcp.executable_id
ORDER BY sequence