Query to find concurrent request details

Query to find concurrent request details

In this post , We will be discuss about Query to find concurrent request details. This SQL query will help to extract the list of  concurrent requests details 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 get concurrent program details. Here below is the complete detail Query to find concurrent request details.

Query to find concurrent request details

4 Important table used By Query to find concurrent request details

1. FND_concurrent_requests

2. FND_concurrent_programs

3. FND_CONCURRENT_PROGRAMS_TL

4. FND_USER 

SQL Query to find concurrent request details

Here below , we will be able to get the detail about 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;