ESS - Jobs Running or Cancelling More Than 24 Hours

SELECT requestid, DEFINITION, ELAPSEDTIME 
 FROM FUSION.ESS_REQUEST_HISTORY 
 WHERE SUBMISSION < SYSDATE - 1 
   AND state IN (3,7) 
   AND ELAPSEDTIME IS NOT NULL 
   AND definition NOT IN ('JobDefinition://oracle/apps/ess/financials/subledgerAccounting/shared/XLAOTEC') 
 ORDER BY DEFINITION;