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