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 = :REQUEST_ID;