Step 1) Find SID and Serial Number for Concurrent Job 1 2 3 4 5 6 7 8 9 10 11 SELECT a.request_id, d.sid, d.serial# ,d.osuser, d.process , c.SPID ,d.inst_id FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b, […]