Check Transaction Managers Status

Transaction Managers
——————–

SELECT fcqv.USER_CONCURRENT_QUEUE_NAME “Name”
, fcqv.TARGET_NODE “Node”
, fcqv.MAX_PROCESSES “Target Processes”
, fl.MEANING “Status”
FROM FND_CONCURRENT_QUEUES_VL fcqv
, FND_LOOKUPS fl
WHERE fcqv.CONTROL_CODE = fl.LOOKUP_CODE (+)
AND fcqv.ENABLED_FLAG = ‘Y’
AND fl.LOOKUP_TYPE (+) = ‘CP_CONTROL_CODE’
AND fcqv.CONCURRENT_QUEUE_NAME IN (‘RCVOLTM’,’PODAMGR’)
ORDER BY fcqv.USER_CONCURRENT_QUEUE_NAME
, fcqv.TARGET_NODE