Find OPP Log File Using Concurrent Request ID

Select logfile_name from fnd_concurrent_requests where request_id = 11111111;


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 = 1111111;