ESS - Jobs Failed Due to BIP

SELECT  
     ERH.REQUESTID, 
     DECODE(state,1,'Wait',2,'Ready',3,'Running',5,'Blocked',7,'Cancelling',9,'Cancelled',10,'Error',12,'Succeeded',13,'Paused',ERH.STATE) AS State, 
     ERH.DEFINITION, 
     ERH.JOBTYPE, 
     ERP.VALUE AS FAILED_BIP_JOB_URL 
 FROM FUSION_ORA_ESS.request_history ERH 
 JOIN FUSION_ORA_ESS.REQUEST_PROPERTY ERP 
     ON ERH.REQUESTID = ERP.REQUESTID 
 WHERE ERH.ERROR_WARNING_MESSAGE LIKE '%BIP job failed%' 
   AND ERP.NAME = 'bip.status_url' 
   AND ERH.submission > (SELECT SYSDATE - INTERVAL '24' HOUR FROM dual) 
   AND ERH.STATE = 10;