Ameer Khan

Login to apps user

sqlplus apps/<apps_passwd>

SELECT sess.sid,

   sess.serial#,

   oracle_process_id OS_PROCESS_ID,

   fusr.description user_name,

   fcp.user_concurrent_program_name progName,

   TO_CHAR (actual_Start_date, ‘DD-MON-YYYY HH24:MI:SS’)

   StartDate,

   request_id RequestId,

   (SYSDATE – actual_start_date) * 24 * 60 * 60 ETime

   FROM fnd_concurrent_requests fcr,

   fnd_concurrent_programs_tl fcp,

   fnd_user fusr,

   v$session sess

   WHERE fcp.concurrent_program_id = fcr.concurrent_program_id

   AND fcr.program_application_id = fcp.application_id

   AND fcp.language = ‘US’

   AND fcr.phase_code = ‘R’

   AND fcr.status_code = ‘R’

   AND fcr.requested_by = fusr.user_id

   AND fcr.oracle_session_id = sess.audsid(+)

   ORDER BY 8;