根据请求id查找提交用户及职责

select round((nvl(r1.actual_completion_date, sysdate) -
             r1.actual_start_date) * 86400) run_seconds,
       r1.request_id,
       r1.program_short_name,
       r1.requestor,
       r3.responsibility_name,
       r1.user_concurrent_program_name,
       r1.program,
       r1.argument_text,
       r1.phase_code,
       r1.status_code,
       r1.requested_start_date,
       r2.resubmit_interval,
       r2.resubmit_interval_unit_code,
       r1.parent_request_id,
       r2.oracle_session_id,
       r1.actual_start_date,
       r1.actual_completion_date,
       r2.resubmit_end_date
  from apps.fnd_conc_req_summary_v  r1,
       apps.fnd_concurrent_requests r2,
       apps.fnd_responsibility_vl   r3
--fnd_conc_requests_form_v
 where r1.request_id = '&request_id'
   and r1.request_id = r2.request_id
   and r2.responsibility_application_id = r3.application_id
   and r2.responsibility_id = r3.responsibility_id;