ESS - Jobs That Require Review

SELECT 
     DECODE(state, 
            1,'Wait', 
            2,'Ready', 
            3,'Running', 
            5,'Blocked', 
            6,'Hold', 
            7,'Cancelling', 
            9,'Cancelled', 
            10,'Error', 
            12,'Succeeded', 
            13,'Paused', 
            19,'Error_Manual_Recovery', 
            state) AS Status, 
     requestid 
 FROM FUSION.ESS_REQUEST_HISTORY 
 WHERE state IN (5,6,7,19) 
 ORDER BY 1;