Query to Get Report File Path by Request ID

 

SELECT fcr.request_id,

       fcr.concurrent_program_id,

       fcp.concurrent_program_name,

       frt.user_concurrent_program_name,

       fcr.outfile_name,

       fcr.logfile_name

  FROM fnd_concurrent_requests  fcr

       JOIN fnd_concurrent_programs fcp

           ON fcr.concurrent_program_id = fcp.concurrent_program_id

       JOIN fnd_concurrent_programs_tl frt

           ON fcp.concurrent_program_id = frt.concurrent_program_id

 WHERE fcr.request_id =  <request_id>;