All running concurrent requests and current Request status on an EBS Single Instance

All running concurrent requests and current Request status on an EBS Single Instance [SQL] --- summary of all concurrent requests running on an instance and their current status and waiting status select w. seconds_in_wait "Secondswait", w. event "waitEvent", w. p1 | chr (10) | w. p2 | chr (10) | w. p3 "Session Wait", p. spid | chr (10) | s. process "ServerClient", s. sid | chr (10) | s. serial # | chr (10) | s. SQL _hash_value "SidSerialSQLHash", u. user_name | chr (10) | PHASE_CODE | ''| STATUS_CODE | chr (10) | s. status "D BPhaseStatusCODEUser ", Request_id | chr (10) | substring | chr (10) | Parent_request_id" Request_id ", concurrent_program_name, substring, requested_start_Date | chr (10) | round (sysdate-requested_start_date) * 1440, 2) | 'M' "RequestStartDate", ARGUMENT_TEXT, CONCURRENT_QUEUE_ID, QUEUE_DESCRIPTION FROM Region, fnd_user u, gv $ session s, gv $ Process p, gv $ session_wait w WHERE (Phase_Code = 'R') and hold_flag! = 'Y' and Requested_Start_Date <= sysdate and (''is null or ('' = 'B' AND PHASE_CODE = 'r' AND STATUS_CODE IN ('I ', 'q') and '1' in (0, 1, 4) and requested_by = u. user_id and s. paddr = p. addr and s. sid = w. sid and oracle_process_id = p. spid and oracle_session_id = s. audsid order by requested_start_date;