Use the below query for finding all the concurrent requests which are running.

Select /*+ RULE */ substr(Concurrent_Queue_Name,1,12) Manager Name,
       Request_Id Request, User_Name,
       fpro.OS_PROCESS_ID OSprocess,
      fcr.oracle_process_id LocalProcess,
       substr(Concurrent_Program_Name,1,35) Program, Status_code,
       To_Char(Actual_Start_Date, 'DD-MON-YY HH24:MI') Started
       from apps.Fnd_Concurrent_Queues fcq, apps.Fnd_Concurrent_Requests fcr,
      apps.Fnd_Concurrent_Programs fcp, apps.Fnd_User Fu, apps.Fnd_Concurrent_Processes fpro
       WHERE
       Phase_Code = 'R' And
       Status_Code <> 'W' 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
       order by Started



Running between time

SELECT 
    fr.request_id,
    fr.concurrent_program_id,
    fat.application_name,
    fcpt.user_concurrent_program_name,
    fr.phase_code,
    fr.status_code,
    fr.actual_start_date,
    fr.actual_completion_date,
    fu.user_name AS requested_by
FROM 
    fnd_concurrent_requests fr
JOIN 
    fnd_concurrent_programs fcp ON fr.concurrent_program_id = fcp.concurrent_program_id
JOIN 
    fnd_concurrent_programs_tl fcpt ON fcp.concurrent_program_id = fcpt.concurrent_program_id
                                   AND fcpt.language = 'US'
JOIN 
    fnd_application fa ON fcp.application_id = fa.application_id
JOIN 
    fnd_application_tl fat ON fa.application_id = fat.application_id
                          AND fat.language = 'US'
JOIN 
    fnd_user fu ON fr.requested_by = fu.user_id
WHERE 
    fr.actual_start_date BETWEEN TO_DATE('2024-06-07 08:00:00', 'YYYY-MM-DD HH24:MI:SS') 
                            AND TO_DATE('2024-06-07 18:00:00', 'YYYY-MM-DD HH24:MI:SS')
ORDER BY 
    fr.actual_start_date;