To Find long running con-current program status

/* To find long running cuncurrent current status*/

SELECT req.request_id REQID,
           proc.os_process_id OSPROCID,
           summ.user_concurrent_program_name PROGRAM,
           proc.oracle_process_id OPID,
           vsess.username DBUSER,
           vproc.spid SVRPROC,
      LTRIM(vsess.SID)SID,
      LTRIM(vsess.serial#) SERIAL#,
           area.sql_text
      FROM apps.fnd_concurrent_requests req,
           apps.fnd_concurrent_processes proc,
           v$process vproc,
           v$session vsess,
           apps.fnd_concurrent_programs_tl summ,
           v$sqlarea area
    WHERE req.controlling_manager = proc.concurrent_process_id(+)
       AND req.concurrent_program_id = summ.concurrent_program_id
       and summ.LANGUAGE='US'
       AND proc.oracle_process_id = vproc.pid(+)
       AND vproc.addr = vsess.paddr(+)
       AND vsess.sql_address = area.address(+)
      AND req.request_id = 27149902