SQL Query to Find the Concurrent Request Session Id

 SELECT sess.sid,

       sess.serial#,

       fcr.request_id,

       fcpt.user_concurrent_program_name,

       fcr.requested_start_date,

       fcr.phase_code,

       fcr.status_code

  FROM apps.fnd_concurrent_requests     fcr,

               v$session   sess,

               apps.fnd_concurrent_programs_tl  fcpt

 WHERE     fcr.request_id = &request_id

       AND fcr.phase_code = 'R'

       AND fcr.status_code = 'R'

       AND fcr.oracle_session_id = sess.audsid(+)

       AND fcr.concurrent_program_id = fcpt.concurrent_program_id