Script to find current running wokflow service components location

select fl.meaning,fcp.process_status_code,
  decode(fcq.concurrent_queue_name,'WFMLRSVC','maile r container','WFALSNRSVC','listener container',fcq.concurrent_queue_name),
    fcp.concurrent_process_id,os_process_id, fcp.logfile_name
 from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
 where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
    and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
  fl.lookup_code=fcp.process_status_code
   and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
  order by fcp.logfile_name;

Sample output:

MEANING    P DECODE(FCQ.CONCURRENT_QUEUE_NA CONCURRENT_PROCESS_ID OS_PROCESS LOGFILE_NAME

---------- - ------------------------------ --------------------- ---------- ----------------------------------------------------------------------

Active     A listener container                             42605 21254      /data07/erp/oracle/comn/admin/log/FNDCPGSC42605.txt

Active     A maile r container                              42607 21270      /data07/erp/oracle/comn/admin/log/FNDCPGSC42607.txt