子查询解嵌套not in 无法展开改写

SQL> explain plan for select *
  from OPS$CZTEST1.SAVJ_ATOMJOURBAK
 where ((list_flag = '1' and prt_flag = '0') and
       acct_no not in
       (select acct_no
           from OPS$CZTEST1.savb_basicinfo1
          where ((card_no is not null and base_acct_no is null) or
                (book_flag = '1' and bus_code = 21))));  2    3    4    5    6    7    8 

Explained.

SQL> select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 3909253513

--------------------------------------------------------------------------------------
| Id  | Operation                             | Name                         | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------