Query to get the Concurrent Request Details of the Concurrent Program

SELECT DISTINCT fcp.user_concurrent_program_name,
                fcp.concurrent_program_name,
                fcr.request_id,
                fcr.request_date,
                fcr.requested_start_date,
                fcr.actual_start_date,
                fcr.actual_completion_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 flv.lookup_code = fcr.status_code
            AND flv.lookup_type = 'CP_STATUS_CODE'
            AND flv.LANGUAGE = 'US'
            AND (fcp.user_concurrent_program_name) =:p_program_name
       ORDER BY fcr.request_date,
                fcr.request_id DESC;