Concurrent requests scheduled by a User

Connect to database as apps user and run the below query:

=>It prompt for user name, Enter username in caps

set lines 200

col CONC_PROG for a40

col start_date for a12

col end_date for a12

col Next_run for a12

col last_run for a12

select r.request_id,

 p.user_concurrent_program_name || nvl2(r.description,' ('||r.description||')',null) Conc_prog,

-- r.argument_text arguments,

 r.requested_start_date next_run,

 r.last_update_date LAST_RUN,

 r.hold_flag on_hold,

 c.date1 start_date,

 c.date2 end_date

 from fnd_concurrent_requests r,

 fnd_conc_release_classes c,

 fnd_concurrent_programs_tl p,

 fnd_user s,

 (with date_schedules as (

 select release_class_id,

 rank() over(partition by release_class_id order by s) a, s

 from (select c.class_info, l,

 c.release_class_id,

 decode(substr(c.class_info, l, 1), '1', to_char(l)) s

 from (select level l from dual connect by level <= 31),

 fnd_conc_release_classes c

 where c.class_type = 'S'

 and instr(substr(c.class_info, 1, 31), '1') > 0)

 where s is not null)

 SELECT release_class_id, substr(max(SYS_CONNECT_BY_PATH(s, ' ')), 2) dates

 FROM date_schedules

 START WITH a = 1

 CONNECT BY nocycle PRIOR a = a - 1

 group by release_class_id) dates

 where s.user_name = '&1'

 and r.phase_code = 'P'

 and c.application_id = r.release_class_app_id

 and c.release_class_id = r.release_class_id

 and nvl(c.date2, sysdate + 1) > sysdate

 and c.class_type is not null

 and p.concurrent_program_id = r.concurrent_program_id

 and p.language = 'US'

 and dates.release_class_id(+) = r.release_class_id

 and r.requested_by = s.user_id

 order by conc_prog, on_hold, next_run;