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;