Need a SQL query to Identify if PO Cancel email for External Domain of Supplier

Summary:

Hello Oracle Supplier Experts

Currently when any inflight PO get cancelled by Buyer, as a buying organization we don't have feasibility to check if PO Cancel email is triggered to Supplier via Communication Method: Email which we set during Action » Cancel Document on any Open Purchase Order.

Do we have any Technical Query which can give us result of external email triggered as confirmation

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

25A

Code Snippet (add any code snippets that support your topic, if applicable):