Oracle Alert - QTY REC hold alert

Hi All,

We are trying to implement a small alert for invoices that are placed on a QTY REC hold.

In test, when we run the alert, we receive an alert action for each invoice on a QTY REC hold.

However, in PROD, we've come accross several invoices that have multiple QTY REC holds on them (On account of the invoice being matched to several PO's)

Therefore, the recipient is receiving multiple alert notifications, where we only want them to receive one.

Is there a way to configure the alert, and/or adjust the sql code to accomodate this?

Code we are using: (Note, have removed the INTO section)