The blog provides some useful SQL Queries to retrieve the SQL data for Internal concurrent Manager in Oracle EBS R12 

Internal Concurrent Manager (ICM) Actual and Target Processes

SELECT MAX_PROCESSES,RUNNING_PROCESSES
FROM FND_CONCURRENT_QUEUES
WHERE CONCURRENT_QUEUE_NAME='FNDICM';

Internal concurrent Manager (ICM) Current Running Node 

SELECT FCQ.CONCURRENT_QUEUE_NAME, FCQ.TARGET_NODE,
SUBSTR(FCP.OS_PROCESS_ID,0,10) “OS PROC” ,
FCP.ORACLE_PROCESS_ID “ORACLE ID” ,
FCP.PROCESS_STATUS_CODE
FROM APPS.FND_CONCURRENT_QUEUES FCQ ,
     APPS.FND_CONCURRENT_PROCESSES FCP
WHERE FCQ.CONCURRENT_QUEUE_ID=FCP.CONCURRENT_QUEUE_ID
AND FCQ.CONCURRENT_QUEUE_NAME=’FNDICM’
AND FCP.PROCESS_STATUS_CODE=’A’
ORDER BY FCP.PROCESS_STATUS_CODE

Internal concurrent Manager (ICM) Environment Settings

SELECT 'PCP' "NAME", VALUE
FROM APPS.FND_ENV_CONTEXT
WHERE VARIABLE_NAME = 'APPLDCP' AND
CONCURRENT_PROCESS_ID = (SELECT MAX(CONCURRENT_PROCESS_ID)
FROM APPS.FND_CONCURRENT_PROCESSES WHERE CONCURRENT_QUEUE_ID = 1)
UNION ALL
SELECT 'RAC' "NAME", DECODE(COUNT(*), 0, 'N', 1, 'N', 'Y') "VALUE" FROM V$THREAD
UNION ALL
SELECT 'GSM' "NAME", NVL(V.PROFILE_OPTION_VALUE, 'N') "VALUE"
FROM APPS.FND_PROFILE_OPTIONS P, APPS.FND_PROFILE_OPTION_VALUES V
WHERE P.PROFILE_OPTION_NAME = 'CONC_GSM_ENABLED'
AND P.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID
UNION ALL
SELECT NAME, VALUE FROM APPS.FND_CONCURRENT_QUEUE_PARAMS
WHERE QUEUE_APPLICATION_ID = 0 AND CONCURRENT_QUEUE_ID = 1;