Select ( Select substr( fu.user_name, 1, 20 ) FROM fnd_user fu WHERE fu.user_id = cr.requested_by )
"User_Name", TO_CHAR ( NVL ( cr.actual_start_date, cr.requested_start_date ),
'DD-MON-YYYY HH24:MI' ) "Start_Time", cr.request_id, cr.oracle_process_id spid, vp.pid pid,
to_number(cr.os_process_id) "OS Process Id",
cr.oracle_session_id AUDSID, vs.sid sid, vs.serial# serial#,
( SELECT SUBSTR ( cp.concurrent_program_name || ' - ' || cpl.user_concurrent_program_name, 1, 40 )
FROM fnd_concurrent_programs cp, fnd_concurrent_programs_tl cpl
WHERE cp.application_id = cr.program_application_id
AND cp.concurrent_program_id = cr.concurrent_program_id
AND cpl.application_id = cr.program_application_id
AND cpl.concurrent_program_id = cr.concurrent_program_id
AND cpl.language= USERENV('LANG') ) "Concurrent_Program"
FROM fnd_concurrent_requests cr, v$process vp, v$session vs
WHERE cr.phase_code NOT IN ('I', 'C') AND cr.status_code NOT IN ('U','X','D','E','I','C')
AND cr.oracle_process_id = vp.spid(+) AND cr.oracle_session_id = vs.audsid(+) ORDER BY 1,2,3
/