How to find email text associated with workflow notification_id?
Hello,
We are going to follow document 372933.1, stop the worflow mailers, and do an update like below:
update wf_notifications
set mail_status = 'SENT', status = 'CLOSED'
where mail_status = 'MAIL'
and message_name in
('OTA_CLS_RESCHEDULE_LRNR_EMB'
,'OTA_CERT_ENROLL_LRNR_MSG'
,'OTA_BULK_ENR_NTF_MSG_EMB'
,'OTA_CERT_COMPLETION_MSG'
,'OTA_LNR_NTF_ENR_STATUS_NO_EMB'
,'OTA_LNR_NTF_ENR_STS_OA_NO_EMB');
We want to be extra confident that we are only updating workflows for particular certificates, that will be named in the email header or text.
Is there a table we can link to the wf_notifications table to read the email header/body?