利用FILTER特性优化SQL

SELECT       A.CARDOFBANK, 
               A.CARD_NO, 
               to_char(A.TRANS_DATE, 'YYYY-MM-DD') ,
               decode(A.TRANS_CODE, '111019', 0, A.TRANS_AMT), 
               A.FEE_AMT ,
               A.TRANS_CODE , 
               A.ABS || (case when A.TRANS_CODE = '111005' and A.dc_flag = '1' then '转出'
                              when A.TRANS_CODE = '111005' and A.dc_flag = '2' then '转入'
                          end) ,
               E.TRANS_TYPE,
               E.TRANS_TYPE_DESC , 
               case  when A.TRANS_CODE = '111005' and A.dc_flag = '2' then 'B4'
                     else E.BUSINESS_TYPE
               END BUSINESS_TYPE, 
               E.BUSINESS_TYPE_DESC, 
               A.SEQ_NO , 
               A.AUTH_CODE , 
               B.EQUIP_TYPE , 
               B.EQUIP_NO ,
               D.ORG_ID,