Select Code to Download

create table t (note_tx varchar2(100));

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:');