Query to find concurrent requests on hold

Query to find concurrent requests on hold

In this post , we will be discuss about Query to find concurrent requests on hold. This query will help to extract the list of concurrent requests which are showing in the hold status in oracle apps system. This sql query is one of the important sql query which helps to get the details of hold concurrent requests. Please find below the detail about Query to find concurrent requests on hold.

Query to find concurrent requests on hold

Important Table used by SQL Query to find concurrent requests on hold

1.fnd_concurrent_requests

2.fnd_concurrent_programs

3.fnd_concurrent_programs_tl

4.fnd_user

Detail SQL Query to find concurrent requests on hold

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  a.requested_start_date > SYSDATE

and  a.hold_flag = 'Y';

order by process_time desc