Query to find Concurrent request history

Query to find Concurrent request history

In this post , We will be discuss about query to find concurrent request history. This SQL query will help to extract the list of  concurrent requests submitted in the oracle system. We will be able to get the complete informations about concurrent requests submission details using this query. This is one of the important sql query to concurrent program request history details. Here below is the complete about Query to find Concurrent request history.

Query to find Concurrent request history

4 Important Table Used By Query to find Concurrent request history

1. FND_concurrent_requests

2. FND_concurrent_programs

3. FND_CONCURRENT_PROGRAMS_TL

4. FND_USER 

Query to find Concurrent request historY

Here below , we will be able to get the detail abbout Concurrent request history using this query.

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,

 (a.actual_start_date-a.request_date)*24*60*60 AS lag_time,

 d.user_name,

 a.phase_code,

 a.status_code,

 a.argument_text,

 a.priority

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

order by Process_time desc;

Query to find Concurrent request history

Query to find Concurrent request history