Query to find a Concurrent Request Submitted by Users and its Count

Query  to find a Concurrent Request Submitted by Users and its Count

Query:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RRRR HH24:MI:SS';

SELECT

    user_name,

    request_date,

   count(*)

FROM

    fnd_concurrent_requests fcr,

    fnd_concurrent_programs_tl fcp,

    fnd_responsibility_tl fr,

    fnd_user fu

WHERE

    fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id

    and fcr.responsibility_id = fr.responsibility_id

    and fcr.requested_by = fu.user_id

    and fr.language='US'

    and user_concurrent_program_name='&Program_name'

group by user_name, request_date

order by request_date desc;

If you like please follow and comment