Concurrent Managers that are currently running requests

SELECT Concurrent_Queue_Name Manager,

       Request_Id Request,

       User_name,

       Concurrent_Program_Name Program,

       Run_Alone_Flag,

       TO_CHAR (Actual_Start_Date, 'DD-MON-YY HH24:MI') Started

  FROM Fnd_Concurrent_Queues Fcq,

       Fnd_Concurrent_Requests Fcr,

       Fnd_Concurrent_Programs Fcp,

       Fnd_User Fu,

       Fnd_Concurrent_Processes Fpro

 WHERE Phase_Code = 'R' AND Fcr.Controlling_Manager = Concurrent_Process_Id

       AND (Fcq.Concurrent_Queue_Id = Fpro.Concurrent_Queue_Id

            AND Fcq.Application_Id = Fpro.Queue_Application_Id)

       AND (Fcr.Concurrent_Program_Id = Fcp.Concurrent_Program_Id

            AND Fcr.Program_Application_Id = Fcp.Application_Id)

       AND Fcr.Requested_By = User_Id