SELECT rq.parent_request_id "Parent Req. ID",
rq.request_id "Req. ID",
tl.user_concurrent_program_name "Program Name",
rq.actual_start_date "Start Date",
rq.actual_completion_date "Completion Date",
rq.argument_text parameter,
Round(( rq.actual_completion_date - rq.actual_start_date ) * 1440, 2) "Runtime (in Minutes)",
Round((( rq.actual_completion_date - rq.actual_start_date ) * 1440)/60,2) "Runtime (in Hrs)"
FROM applsys.fnd_concurrent_programs_tl tl,
applsys.fnd_concurrent_requests rq
WHERE tl.application_id = rq.program_application_id
AND tl.concurrent_program_id = rq.concurrent_program_id
AND tl.LANGUAGE = Userenv('LANG')
AND rq.actual_start_date IS NOT NULL
AND rq.actual_completion_date IS NOT NULL
AND rq.status_code = 'C' --Status : Normal
AND tl.user_concurrent_program_name = <concurrent_prog_name>
AND trunc(rq.actual_start_date) > SYSDATE - 1 --For SYSDATE Running Requests
-- AND rq.request_id in (67386374, 67386370)
ORDER BY rq.request_id DESC;