SQL query is not giving expected results when using NOT LIKE/LIKE operators

Hello Experts,

Oracle 11g version: 11.0.2.1

we have a requirements to display item name and lot number based on certain criteria as per below details,

Create table:

create table table_a(item_name varchar2(100), lot_number varchar2(50),src_id number,dest_id number);

create table table_v(org_id number,tag varchar2(10));

insertion statements:

insert into table_a values('item1','2abc1234',701,699);

insert into table_a values('item2','3abc12345',701,699);

insert into table_a values('item3','4abc1234',701,2089);

insert into table_a values('item4','4abc1234',701,2089);

insert into table_a values('item5','3abc1234',701,699);