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;
Post a Comment
Post a Comment