SELECT a.request_id,floor((sysdate-a.actual_start_date)*24) hou,

       round(((sysdate-a.actual_start_date)*24-

       floor((sysdate-a.actual_start_date)*24))*60) mini,

       c.sql_address, c.inst_id,f.full_name,u.user_name,

       b.user_concurrent_program_name,r.responsibility_key, w.event,

       a.actual_start_date , a.argument_text,b.description,

       b.concurrent_program_name, a.phase_code, a.status_code,

       c.sid, c.serial#, d.pid, d.spid, w.*

FROM fnd_concurrent_requests a, fnd_user u, per_all_people_f f,

       fnd_concurrent_programs_vl b, Gv$session c,

       Gv$process d, Gv$session_wait w,fnd_responsibility r

WHERE a.concurrent_program_id = b.CONCURRENT_PROGRAM_ID

AND a.Oracle_Session_Id = c.audsid

AND c.paddr = d.addr

and c.inst_id=d.inst_id

and w.inst_id=c.inst_id

and c.sid = w.sid

and r.responsibility_id=a.responsibility_id

AND a.phase_code = 'R'

and u.user_id=a.requested_by

and u.employee_id=f.person_id(+);