How To Find Out On Which Instance FNDSM Is Currently Running

How To Find Out On Which Instance FNDSM Is Currently Running?

Execute below Query :-

SELECT concurrent_queue_name, p.node_name, db_instance
  FROM fnd_concurrent_processes p, fnd_concurrent_queues q, fnd_cp_services s
 WHERE     p.queue_application_id = q.application_id
       AND p.concurrent_queue_id = q.concurrent_queue_id
       AND q.manager_type = s.service_id
       AND p.process_status_code = 'A';

Output:-

CONCURRENT_QUEUE_NAME	NODE_NAME	DB_INSTANCE
INVTMRPM	LITHIUM	UAT
INVTMRPM	LITHIUM	UAT
FNDSM_LITHIUM	LITHIUM	UAT
FNDICM	LITHIUM	UAT
INVTMRPM	LITHIUM	UAT
XDP_APPL_SVC	LITHIUM
WFWSSVC	LITHIUM
FNDCPOPP	LITHIUM
WFALSNRSVC	LITHIUM
WFMLRSVC	LITHIUM
XDP_CTRL_SVC	LITHIUM
XDP_Q_ORDER_SVC	LITHIUM
XDP_Q_FA_SVC	LITHIUM
XDP_Q_FE_READY_SVC	LITHIUM
XDP_Q_EVENT_SVC	LITHIUM
XDP_Q_IN_MSG_SVC	LITHIUM
XDP_Q_TIMER_SVC	LITHIUM
XDP_SMIT_SVC	LITHIUM
FNDOPP10999	LITHIUM
FNDCRM	LITHIUM	UAT
XDP_MANAGER	LITHIUM	UAT
STANDARD2	LITHIUM	UAT
STANDARD2	LITHIUM	UAT
STANDARD2	LITHIUM	UAT
STANDARD	LITHIUM	UAT
STANDARD	LITHIUM	UAT
STANDARD	LITHIUM	UAT
STANDARD	LITHIUM	UAT
STANDARD	LITHIUM	UAT
STANDARD	LITHIUM	UAT
REPORTS_lithium_7015	LITHIUM
XDP_Q_WI_SVC	LITHIUM