又见谓词推入

--------原始SQL
select e.* , 
       aa.* ,
       bb.* ,
       ee.* ,
       dd.*
  from b_m_sys_branch e
  left join
        --购买金额
       (select nvl(c.SEC_ORG_ID, '其他') as SEC_ORG_ID,
               max(nvl(c.SEC_ORG_NAME, '其他')) as SEC_ORG_NAME,
               sum(a.finance_amt) as 购买金额
          from (SELECT DISTINCT a.RECOM_OPER_NO,
                                a.cust_no,
                                a.cust_name,
                                a.product_no,
                                a.contract_no,
                                a.finance_amt,
                                a.sign_date
                  FROM DWF.F_EVT_EXTR_FINANCE_BOOK a
                 where a.valid_flag = '1' --有效标志
                   AND a.deduct_flag = '1' -- 扣款标志
                   AND a.acct_flag = '0') a
          left join dwf.f_extc_finance_para b
            on a.product_no = b.product_no
          lef