SELECT DISTINCT fcp.user_concurrent_program_name,
                  fcp.concurrent_program_name,
                  fcr.request_id,
                  fcr.request_date,
                  flv.meaning status,
                  fcr.status_code,
                  fcr.completion_text,
                  fcr.logfile_name,
                  fcr.outfile_name,
                  fcr.argument_text
    FROM apps.fnd_concurrent_programs_vl fcp,
         apps.fnd_concurrent_requests fcr,
         apps.fnd_lookup_values flv
   WHERE     fcr.concurrent_program_id = fcp.concurrent_program_id
         AND TRUNC (fcr.last_update_date) = TRUNC (SYSDATE)
         AND flv.lookup_code = fcr.status_code
         AND flv.lookup_type = 'CP_STATUS_CODE'
         AND flv.language = 'US'
ORDER BY fcr.request_date, fcr.request_id DESC;