Display status of all Concurrent Managers

rem -----------------------------------------------------------------------rem Filename:   appinfo.sqlrem Purpose:    Script to display status of all the Concurrent Managersrem Author:     Anonymousrem -----------------------------------------------------------------------set head oncolumn OsId       format A10 justify leftcolumn CpId       format 999999column Opid       format 999column Manager    format A30column Status     format A20column Started_At format A30column Cpid       heading 'Concurrent|Process ID'column OsId       heading 'System|Process ID'column Opid       heading 'Oracle|Process ID'column Manager    heading 'Concurrent Manager Name'column Status     heading 'Status|of Concurrent|Manager'column Started_At heading 'Concurrent Manager|Started at'select distinct Concurrent_Process_Id CpId, PID Opid,       Os_Process_ID Osid, Q.Concurrent_Queue_Name Manager,       P.process_status_code Status,       To_Char(P.Process_Start_Date, 'MM-DD-YYYY HH:MI:SSAM') Started_Atfrom   Fnd_Concurrent_Processes P, Fnd_Concurrent_Queues Q, FND_V$Processwhere  Q.Application_Id = Queue_Application_ID  and  Q.Concurrent_Queue_ID = P.Concurrent_Queue_ID  and  Spid = Os_Process_ID  and  Process_Status_Code not in ('K','S')order  by Concurrent_Process_ID, Os_Process_Id, Q.Concurrent_Queue_Name/