ESS - Show All ESS Schedules

SELECT 
     requestid, 
     DECODE(state, 
            1,'Scheduled', 
            10,'ERROR', 
            11,'WARNING', 
            12,'SUCCEEDED', 
            6,'Hold', 
            state) AS STATE, 
     SUBSTR(definition, (INSTR(definition, '/', -1) + 1)) AS Name, 
     TO_TIMESTAMP(SUBSTR((SUBSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''),  
                     INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') + LENGTH(''), 
                     INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') -  
                     INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') - LENGTH(''))), 1, 19), 'YYYY-MM-DD HH24:MI:SS') AS SCHEDULE_START, 
     TO_TIMESTAMP(SUBSTR((SUBSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''),  
                     INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') + LENGTH(''), 
                     INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') -  
                     INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') - LENGTH(''))), 1, 19), 'YYYY-MM-DD HH24:MI:SS') AS SCHEDULE_END, 
     SUBSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''),  
            INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') + LENGTH(''), 
            INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') -  
            INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') - LENGTH('')) AS FREQUENCY, 
     SUBSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''),  
            INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') + LENGTH(''), 
            INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') -  
            INSTR(REPLACE(utl_raw.cast_to_varchar2(adhocschedule), chr(0), ''), '') - LENGTH('')) AS INTERVAL 
 FROM 
     fusion_ora_ess.request_history rh 
 WHERE 
     rh.parentrequestid = -1 
     AND rh.requesttype = 2 
     AND rh.state = 1 
     AND rh.adhocschedule IS NOT NULL 
 ORDER BY FREQUENCY;