How to find no of active concurrent requests

Hi all

How would I be able to find the active concurrent requests from Oracle Database, Remember I need SQL, I dont want to do it through Oracle Apps

Everywhere I looked keeps history, I dont want history how do i find the current scheduled requests

Regards
Irfan Khan

Hi

please run the following sql


select * from fnd_concurrent_request where status_code = 'R'

It will display running concurrent request.


select * from fnd_concurrent_request where status_code ='P'
and phast_code = 'I'

it will display scheduled concurrent requests.

If you want script please reply me i will sent detail scripts.


regards

nutmut