Seesion Information of a Concurrent Request

This query can give you sid and serial# that can be used to kill a concurrent request.

SELECT fcr.concurrent_program_id
     , fcr.oracle_process_id
     , fcr.oracle_session_id
     , fcr.os_process_id
     , vs.sid
     , vs.serial#
  FROM apps.fnd_concurrent_requests fcr
     , v$process                    vp
     , v$session                    vs
 WHERE fcr.request_id= 44479533
   AND fcr.oracle_process_id  = vp.spid
   AND vs.paddr               = vp.addr