select FCPP.CONCURRENT_REQUEST_ID REQ_ID, FCP.NODE_NAME, FCP.LOGFILE_NAME
  from FND_CONC_PP_ACTIONS FCPP, FND_CONCURRENT_PROCESSES FCP
 where FCPP.PROCESSOR_ID = FCP.CONCURRENT_PROCESS_ID
       and FCPP.ACTION_TYPE = 6
       and FCPP.CONCURRENT_REQUEST_ID = 4643372;
1
2
3
4
5