Set Pages 1000
Set head on
Column Manager Format A12
Column Request Format 999999999
Column Program Format A30
Column User_Name Format A15
Column Started Format A15
Column OSprocess Format A9
Column SPID Format A9
Column LocalProcess Format A9
prompt Managers that are currently running a request;
prompt ;
Select /*+ RULE */ substr(Concurrent_Queue_Name,1,12) Manager,
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
/
No comments:
Post a Comment