Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tablea(
  mfpartno varchar2( 255 )
, cf1 varchar2( 255 )
, cf2 varchar2( 255 )
, cf3 varchar2( 255 )
) ;
create table tableb(
  cbn varchar2( 255 )
, cf1 varchar2( 255 )
, cf2 varchar2( 255 )
, cf3 varchar2( 255 )
) ;
begin
  insert into tablea ( mfpartno, cf1, cf2, cf3 )
    values('M1001','co1','co2,co3','co4') ;
  insert into tablea ( mfpartno, cf1, cf2, cf3 )
    values('M1002',null,null,'co7') ;
  insert into tablea ( mfpartno, cf1, cf2, cf3 )
    values('M1003','co1','co3','co4') ;
--
  insert into tableb ( cbn, cf1, cf2, cf3 )
    values('cbn100','co1','co2','co4') ;
  insert into tableb ( cbn, cf1, cf2, cf3 )
    values('cbn101','co2','co2,co3','co5') ;
  insert into tableb ( cbn, cf1, cf2, cf3 )
    values('cbn103','co1','co5','co7,co4') ;
end ;
/
1 rows affected

    select
      A.mfpartno
    , B.cbn
    , case when instr( A.cf1, B.cf1 ) > 0 or B.cf1 is null then 'true' else 'false' end AB1
    , case when instr( A.cf2, B.cf2 ) > 0 or B.cf2 is null then 'true' else 'false' end AB2
    , case when instr( A.cf3, B.cf3 ) > 0 or B.cf3 is null then 'true' else 'false' end AB3
    , case when instr( B.cf1, A.cf1 ) > 0 or A.cf1 is null then 'true' else 'false' end BA1
    , case when instr( B.cf2, A.cf2 ) > 0 or A.cf2 is null then 'true' else 'false' end BA2
    , case when instr( B.cf3, A.cf3 ) > 0 or A.cf3 is null then 'true' else 'false' end BA3
    from tablea A cross join tableb B


MFPARTNO
CBN
AB1
AB2
AB3
BA1
BA2
BA3


M1001
cbn100
true
true
true
true
false
true

M1001
cbn101
false
true
false
false
true
false

M1001
cbn103
true
false
false
true
false
true

M1002
cbn100
false
false
false
true
true
false

M1002
cbn101
false
false
false
true
true
false

M1002
cbn103
false
false
false
true
true
true

M1003
cbn100
true
false
true
true
false
true

M1003
cbn101
false
false
false
false
true
false

M1003
cbn103
true
false
false
true
false
true


select result_
from (
  select 
    case when
      ( AB1 = 'true' and AB2 = 'true' and AB3 = 'true' )  
      or
      ( BA1 = 'true' and BA2 = 'true' and BA3 = 'true' )  
      then mfpartno || '=' || cbn
    end result_
  from (
    select
      A.mfpartno
    , B.cbn
    , case when instr( A.cf1, B.cf1 ) > 0 or B.cf1 is null then 'true' else 'false' end AB1
    , case when instr( A.cf2, B.cf2 ) > 0 or B.cf2 is null then 'true' else 'false' end AB2
    , case when instr( A.cf3, B.cf3 ) > 0 or B.cf3 is null then 'true' else 'false' end AB3
    , case when instr( B.cf1, A.cf1 ) > 0 or A.cf1 is null then 'true' else 'false' end BA1
    , case when instr( B.cf2, A.cf2 ) > 0 or A.cf2 is null then 'true' else 'false' end BA2
    , case when instr( B.cf3, A.cf3 ) > 0 or A.cf3 is null then 'true' else 'false' end BA3
    from tablea A cross join tableb B
  )
)
where result_ is not null
;


RESULT_


M1001=cbn100

M1002=cbn103

MFPARTNO	CBN	AB1	AB2	AB3	BA1	BA2	BA3
M1001	cbn100	true	true	true	true	false	true
M1001	cbn101	false	true	false	false	true	false
M1001	cbn103	true	false	false	true	false	true
M1002	cbn100	false	false	false	true	true	false
M1002	cbn101	false	false	false	true	true	false
M1002	cbn103	false	false	false	true	true	true
M1003	cbn100	true	false	true	true	false	true
M1003	cbn101	false	false	false	false	true	false
M1003	cbn103	true	false	false	true	false	true