FND Concurrent Request details with concurrent program by user Query SQL in Oracle Applications

  SELECT fu.user_name,
         fcp.user_concurrent_program_name,
         fcr.request_id,
         fcr.request_date,
         fcr.actual_start_date,
         fcr.actual_completion_date,
         fcr.argument_text
    FROM apps.fnd_concurrent_programs_vl fcp,
         apps.fnd_concurrent_requests fcr,
         apps.fnd_user fu
   WHERE     fu.user_id = fcr.requested_by
         AND fcp.concurrent_program_id = fcr.concurrent_program_id
         AND fcp.user_concurrent_program_name =
                NVL ( :concurrent_program_name,
                     fcp.user_concurrent_program_name)
         AND fcr.request_date >= NVL ( :P_DATE, fcr.request_date)
         AND fu.user_name = NVL ( :P_USER_NAME, fu.user_name)
ORDER BY fcr.request_id DESC