ESS - High Frequency 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 
   AND (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('')) LIKE '%MINUTELY%') 
 ORDER BY INTERVAL;