insert into t values ('1st: XX Merged From: Vendor: Acme Corp 1');
insert into t values ('2nd: CA Merged From: Vendor: Acme Corp 2');

select *
from t
where REGEXP_LIKE(note_tx, 'CA\s+\n?Merged\s+\n?From:\s+\n?Vendor:');