Thanks for the post.
You can create shell script and send the alert by mail.
Go to Alert Manager Responsibility and create a alert for running/pending requests
In my case i have created periodic alert when programs crossed 10 will get email
SELECT count(*) into &n
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 status_code='R'
having count(*) > 10