SELECT
REQUESTID, SYSDATE, SUBMISSION, REQUESTEDSTART, READYTIME, PROCESSSTART
FROM FUSION_ORA_ESS.request_history
WHERE state = 2
AND READYTIME < (SELECT SYSDATE - INTERVAL '1' MINUTE FROM dual);
SELECT
REQUESTID, SYSDATE, SUBMISSION, REQUESTEDSTART, READYTIME, PROCESSSTART
FROM FUSION_ORA_ESS.request_history
WHERE state = 2
AND READYTIME < (SELECT SYSDATE - INTERVAL '1' MINUTE FROM dual);