There will be many instances during which you are asked to find out the latest concurrent requests that are submitted for a given concurrent program. In order to achieve those results, you have to join the fnd_concurrent_programs_tl and the fnd_concurrent_requests tables. Below is the sample code:

  SELECT fcr.request_date,
         fcr.argument_text,
         fcr.argument1,
         fcr.argument2,
         fcr.argument3,
         fcr.*
    FROM fnd_concurrent_requests fcr, fnd_concurrent_programs_tl fcp
   WHERE     fcr.concurrent_program_id = fcp.concurrent_program_id
         AND fcp.user_concurrent_program_name =
                'Payables Open Interface Import'
ORDER BY fcr.request_date DESC;