Script to check Interface managers status

SELECT
x.PROCESS_TYPE “Name”,
decode((select ‘1’
FROM APPS.FND_CONCURRENT_REQUESTS cr,
APPS.FND_CONCURRENT_PROGRAMS_VL cp,
APPS.FND_APPLICATION A
WHERE cp.concurrent_program_id = cr.concurrent_program_id
AND cp.CONCURRENT_PROGRAM_NAME = x.PROCESS_NAME
AND cp.APPLICATION_ID = a.application_id
AND a.APPLICATION_SHORT_NAME = x.PROCESS_APP_SHORT_NAME
AND PHASE_CODE != ‘C’ and rownum=1),’1′,’Active’,’Inactive’) “Status”,
x.WORKER_ROWS “Worker Rows”,
x.TIMEOUT_HOURS “Timeout Hours”,
x.TIMEOUT_MINUTES “Timeout Minutes”,
x.PROCESS_HOURS “Process Interval Hours”,
x.PROCESS_MINUTES “Process Interval Minutes”,
x.PROCESS_SECONDS “Process Interval Seconds”
FROM (
SELECT
MIPC.PROCESS_CODE ,
MIPC.PROCESS_STATUS ,
MIPC.PROCESS_INTERVAL ,
MIPC.MANAGER_PRIORITY ,
MIPC.WORKER_PRIORITY ,
MIPC.WORKER_ROWS ,
MIPC.PROCESSING_TIMEOUT ,
MIPC.PROCESS_NAME ,
MIPC.PROCESS_APP_SHORT_NAME ,
A.MEANING PROCESS_TYPE ,
FLOOR(MIPC.PROCESS_INTERVAL/3600) PROCESS_HOURS ,
FLOOR((MIPC.PROCESS_INTERVAL –
(FLOOR(MIPC.PROCESS_INTERVAL/3600) * 3600))/60) PROCESS_MINUTES ,
(MIPC.PROCESS_INTERVAL – (FLOOR(MIPC.PROCESS_INTERVAL/3600) * 3600) –
(FLOOR((MIPC.PROCESS_INTERVAL –
(FLOOR(MIPC.PROCESS_INTERVAL/3600) * 3600))/60) * 60)) PROCESS_SECONDS ,
FLOOR(MIPC.PROCESSING_TIMEOUT/3600) TIMEOUT_HOURS ,
FLOOR((MIPC.PROCESSING_TIMEOUT –
FLOOR(MIPC.PROCESSING_TIMEOUT/3600) * 3600)/60) TIMEOUT_MINUTES
FROM
APPS.MTL_INTERFACE_PROC_CONTROLS MIPC,
APPS.MFG_LOOKUPS A
WHERE
A.LOOKUP_TYPE = ‘PROCESS_TYPE’ AND
A.LOOKUP_CODE = MIPC.PROCESS_CODE
) x
— WHERE x.PROCESS_TYPE = ‘Material transaction’ — uncomment this to display only the Material transaction; Possible Values: Cost Manager; Lot Move Transaction; Material transaction; Move transaction
ORDER BY 1;