SQL to Find Requests Run by the Standard Manager in a Given Time Range
SELECT
fcr.request_id,
fcpt.user_concurrent_program_name AS program_name,
fcr.actual_start_date,
fcr.actual_completion_date,
fcr.phase_code,
fcr.status_code,
fcq.concurrent_queue_name AS manager_name
FROM
fnd_concurrent_requests fcr
JOIN fnd_concurrent_programs_tl fcpt
ON fcr.concurrent_program_id = fcpt.concurrent_program_id
JOIN fnd_concurrent_processes fcp
ON fcr.controlling_manager = fcp.concurrent_process_id
JOIN fnd_concurrent_queues fcq
ON fcp.queue_application_id = fcq.application_id
AND fcp.concurrent_queue_id = fcq.concurrent_queue_id
WHERE
fcpt.language = 'US'
AND fcq.concurrent_queue_name = 'STANDARD'
AND fcr.actual_start_date BETWEEN TO_DATE('2025-06-10 08:00:00', 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE('2025-06-10 18:00:00', 'YYYY-MM-DD HH24:MI:SS')
ORDER BY
fcr.actual_start_date;
Post a Comment
Post a Comment