SQL query to fetch all notifications/emails sent by Fusion for AR invoice print.

We need to extract all notifications/Approval/email notifications that are triggered in Fusion within a specific time range. If the Print Receivable Transaction ESS is run then after completion the email is sent for the customer. Where we can see the bursting details. Need the below details.

Notification Sent from email
Email address who it is sent to
Name associated with email (if name available)
Customer/Account number
Invoice number
Receipt number
Supplier/Supplier Number
Email Notification Subject line
Email Notification type/template
Date/Time of notification generated
Date/Time of notification sent
Was notification opened- If email is read