SELECT concurrent_program_name, COUNT(*)
FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS P
WHERE R.concurrent_program_id=P.concurrent_program_id
AND R.actual_start_date= {pick a day}
GROUP BY concurrent_program_name
ORDER BY 2 DESC;
NOTE: give the value for pick a day
No comments:
Post a Comment