Query :
select sess.sid, sess.sql_hash_value, 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 ETime_in_Mins from apps.fnd_concurrent_requests fcr, apps.fnd_concurrent_programs_tl fcp, apps.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 (+) -- and p.addr = sess.paddr order by 6 DESC