SELECT S1.TRANSACTION_ID AS TRANSACTION_ID,
       S1.PARENT_TRANSACTION_ID AS PARENT_TRANSACTION_ID,
       S1.SENT_TIME AS SENT_TIME,
       S2.FAULT AS FAULT,
       S1.OPERATION_NAME AS OPERATION_NAME,
       S1.NAMESPACE AS NAMESPACE
FROM JMS_ESB_PROPERTY S1 INNER JOIN JMS_ESB_PROPERTY S2
ON S1.TRANSACTION_ID = S2.TRANSACTION_ID AND
       S1.NAMESPACE = 'IMS_ESB_T_HABOF' AND
       S1.OPERATION_NAME = 'HABOF_FROM_OTPF' AND
       S2.FAULT = 'TECHNICAL_ERROR' AND
       S1.SENT_TIME > '01-MAR-2018' AND
       S1.SENT_TIME < '31-MAR-2018';