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;

Other Query:

select user_name , req_date, count(*)

from(

SELECT

    user_name,

  to_char( request_date, 'DD-MON-RRRR') req_date

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 request_date > sysdate -8

    and user_concurrent_program_name like '&Program_name'

group by user_name, request_date

order by request_date desc)

group by user_name, req_date;

If you like please follow and comment