How to find no of active concurrent requests

[nutmut]

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