How to find list of all outbound notifications goes to supplier

Summary:

How to find list of all outbound notifications goes to supplier

Content (please ensure you mask any confidential information):

We have received a custom requirement and we wants to extract list of all outbound notifications goes to supplier from fusion cloud.

1. Are there any efficient way to extract list of all outbound notifications goes to supplier?
2. Has anyone has SQL query to fetch all notifications/emails sent by Fusion to supplier's account?
   

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

26C

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