How to Remove Unwanted Messages from Mailer's Queue without Rebuilding the Queue? (Doc ID 759747.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=435773428082446&id=759747.1&_afrWindowMode=0&_adf.ctrl-state=ppqrcpqcb_4





select wfno.msg_id
from applsys.aq$wf_notification_out wfno
where corr_id='APPS:ALR:'
and wfno.msg_state='READY';