SQL to find the currently running request

SELECT a.SID, a.serial#, b.spid, e.request_id, e.program, e.requestor,e.program_short_name, e.argument_text,TRUNC (MOD ((SYSDATE - e.actual_start_date) * 24, 24)) ':' TRUNC (MOD ((SYSDATE - e.actual_start_date) * 24 * 60, 60)) ':' TRUNC (MOD ((SYSDATE - e.actual_start_date) * 24 * 60 * 60, 60))"RUNTIME"FROM v$session a,v$process b,applsys.fnd_concurrent_requests c,applsys.fnd_concurrent_processes d,apps.fnd_conc_req_summary_v eWHERE a.paddr = b.addrAND a.process = d.os_process_idAND c.request_id = e.request_idAND c.phase_code = 'R'AND c.controlling_manager = d.concurrent_process_id;