Query to find concurrent requests submitted by a particular user

Query to find concurrent requests submitted by a particular user

In this post , we will be discuss about the Query to find concurrent requests submitted by a particular user. This SQL query will help to extract the list of concurrent requests submitted by particular user in oracle apps.This is one of the Important SQL query to extract concurrent requests submitted by a particular user. Here below is the complete detail about concurrent requests submitted by a particular user.

4 Important Tables used by concurrent requests submitted by a particular user

1.fnd_concurrent_requests
2.fnd_concurrent_programs
3.fnd_concurrent_programs_tl
4.fnd_user

Detail SQL Query to find concurrent requests submitted by a particular user

select distinct c.user_concurrent_program_name,

      round(((sysdate-a.actual_start_date)*24*60*60/60),2) as process_time,
    a.request_id,
    a.parent_request_id,
    a.request_date,
    a.actual_start_date,
    a.actual_completion_date,
      (a.actual_completion_date-a.request_date)*24*60*60 as end_to_end,
      d.user_name,
      a.phase_code,
      a.status_code "Program Status",
      a.argument_text "Program Paramters"
from     apps.fnd_concurrent_requests a,
    apps.fnd_concurrent_programs b ,
    apps.fnd_concurrent_programs_tl c,
    apps.fnd_user d
where   a.concurrent_program_id=b.concurrent_program_id and
    b.concurrent_program_id=c.concurrent_program_id and
    a.requested_by=d.user_id
    and d.user_name=nvl(:P_USER_NAME,d.user_name)
  order by process_time desc;

Query to find concurrent requests submitted by a particular user

Query to find concurrent requests submitted by a particular user