UPDATE SMNTP_MESSAGE_DEFAULT SET MESSAGE = 'Dear [approver],

Vendor Registration for [vendor] has been approved by [sender],
and submitted it for VENDOR CODE assignment.

Thank you,
SM Vendor Portal Admin' WHERE STATUS_ID = 199;

UPDATE SMNTP_MESSAGE_DEFAULT SET MESSAGE = 'Dear [vendor_name],

Please submit your additional requirements on or before [submission_deadline].

Thank you,
SM Vendor Portal Admin' WHERE STATUS_ID = 190;