Item went error please check with this query

 Item went error please check with this query

SELECT b.SEGMENT1,
         a.message_name,
         b.creation_date,
         a.creation_date,
         SUBSTR (a.table_name, 1, 25) tbl_name,
         SUBSTR (a.column_name, 1, 20) col_name,
         a.error_message,
         a.organization_id
    FROM inv.mtl_interface_errors a, inv.mtl_system_items_interface b
   WHERE     a.transaction_id = b.transaction_id
         AND b.process_flag NOT IN (1, 7)
         AND TRUNC (a.creation_date) = TRUNC(SYSDATE)
         AND error_message = '(Keep your Error Message here)'
ORDER BY a.creation_date DESC