SQL Script to find Concurrent Request Details in Oracle

select req.request_id,
       req.argument_text,
       req.requested_start_date,
       req.actual_start_date,
       req.actual_completion_date,
      (select meaning
          from apps.fnd_lookup_values
         where lookup_type = 'CP_STATUS_CODE'
           AND lookup_code = req.phase_code
           and start_date_active is not null) phase,
       (select meaning
          from apps.fnd_lookup_values
         where lookup_type = 'CP_STATUS_CODE'
           AND lookup_code = req.status_code
           and start_date_active is not null) status,
       (usr.user_name || ' - ' || usr.DESCRIPTION) requested_by,
       fcpt.user_concurrent_program_name,
       (SELECT responsibility_name
          FROM apps.fnd_responsibility_tl
         WHERE responsibility_id = req.responsibility_id) resp,
       req.logfile_name,
       req.outfile_name
  from apps.fnd_concurrent_requests    req,
       apps.fnd_user                   usr,
       apps.fnd_concurrent_programs_tl fcpt,
       apps.fnd_concurrent_programs    fcp
 where req.concurrent_program_id = fcpt.concurrent_program_id
   and fcp.concurrent_program_id = fcpt.concurrent_program_id
   and usr.user_id = req.requested_by
   and req.request_id in (&req_id);