ESS - Scheduled Jobs That Ended

SELECT 
     ROWNUM, 
     REQUESTID, 
     ABSPARENTID, 
     PARENTREQUESTID, 
     REQUESTTYPE, 
     TYPE, 
     DEFINITION, 
     DECODE(state, 
            1,'Wait',  
            11,'Warning', 
            2,'Ready', 
            12,'Succeeded', 
            3,'Running', 
            13,'Paused', 
            4,'Completed', 
            14,'Pending Validation', 
            5,'Blocked', 
            15,'Validation Failed', 
            6,'Hold', 
            16,'Schedule Ended', 
            7,'Canceling', 
            17,'Finished', 
            8,'Expired', 
            18,'Error Auto-Retry', 
            9,'Canceled', 
            19,'Error Manual Recovery', 
            10,'Error', 
            state) AS STATUS   
 FROM  
     FUSION.ESS_REQUEST_HISTORY  
 WHERE  
     parentrequestid = -1 
     AND state IN (16,17);