Triggered Notifications - SQL Syntax

Here's one I use for Invoices that are created when an ERS invoice already exists and the AP clerk labeled "Blocked" because they can not match it. It's to alert them that they need to delete the invoice since ERS has already processed it. It happens when Vendors send invoices when they shouldn't.

Select Employee.aenm, Vendor.id Vendor#, vendor.aenm Name, posum.id PO, ivcsum.ivcgrsamt_amt, ltrim(ivcsum.ivcnum) Invoice from mc.IVCSUM IVCSUM Inner join mc.IVCTYPE ivctype on ivcsum.ivctypref_oi = ivctype.ivtpoi inner join mc.posum posum on ivcsum.PO_oi = posum.posumoi inner join mc.poline poline on posum.posumoi = poline.PO_oi inner join mc.podel podel on poline.polnoi = podel.poline_oi inner join mc.employee employee on ivcsum.audt_user_oi = employee.empoi inner join mc.vendor vendor on ivcsum.vnd_oi = vendor.vendoi Where podel.isers = 1 and ivctype.ivctypid like '%Blocked%' and ivcsum.ivcposted = 0 order by PO ASC