to count the number of concurrent requests submitted by particular user

Select B.user_concurrent_program_name,C.user_name,D.responsibility_name, A.*
from apps.fnd_concurrent_requests A, apps.fnd_concurrent_programs_tl B, Apps.fnd_user C, apps.fnd_responsibility_tl D
 where 1=1
and  B.user_concurrent_program_name like
 'Test Report'
 and B.concurrent_program_id=A.concurrent_program_id
 and A.requested_by=C.user_id
 and A.responsibility_id=D.responsibility_id
 order by request_date desc