SQL Sorgu Banka Hareketleri

SELECT SNM.YIL,SNM.AY,SNM.TARIH,SNM.ISLEMTURU,SNM.FISNO,SNM.BANKA_CARI,
    SNM.BANKAKODU,SNM.BANKAADI,SNM.HESAPKODU,SNM.HESAPADI,SNM.KARSIHESAPKODU,SNM.KARSIHESAPADI,
    ISNULL(CASE HAREKETTURU WHEN 'BORC' THEN AMOUNT END,0) AS BORC,
    ISNULL(CASE HAREKETTURU WHEN 'ALACAK' THEN AMOUNT END,0) ALACAK FROM (
SELECT YEAR(BN.DATE_)YIL,MONTH(BN.DATE_)AY,BN.DATE_ TARIH,
    CASE BN.TRCODE
        WHEN '1' THEN (CASE WHEN CSTRANSREF>0 THEN 'Masraf' ELSE 'Banka İşlem Fişi' END)
        WHEN '2' THEN 'Virman İşlemi'
        WHEN '3' THEN 'Gelen Havale'
        WHEN '4' THEN 'Gönderilen Havale'
        WHEN '5' THEN 'Açılış İşlemi'
        WHEN '6' THEN 'Kur Farkı Fişi'
        WHEN '7' THEN 'Döviz Alış Belgesi'
        WHEN '8' THEN 'Döviz Satış Belgesi'
        WHEN '16' THEN 'Alınan Hizm. Fat'
        WHEN '17' THEN 'Verilen Hizm.Fat.'
        WHEN '18' THEN 'Çek Ödemesi'
        WHEN '19' THEN 'Senet Ödemesi'
        WHEN '10' THEN 'Çek Çıkış(Tahsil)'
    END AS ISLEMTURU,BN.TRANNO FISNO,
    (SELECT CODE FROM LG_215_CLCARD WHERE LOGICALREF=BN.CLIENTREF) BANKA_CARI,
    (SELECT CODE FROM LG_215_BNCARD WHERE LOGICALREF=BN.BANKREF)BANKAKODU,
    (SELECT DEFINITION_ FROM LG_215_BNCARD WHERE LOGICALREF=BN.BANKREF)BANKAADI,
    (SELECT CODE FROM LG_215_BANKACC WHERE LOGICALREF=BN.BNACCREF)HESAPKODU,
    (SELECT DEFINITION_ FROM LG_215_BANKACC WHERE LOGICALREF=BN.BNACCREF)HESAPADI,
CASE BN.TRCODE WHEN '10' THEN
    (SELECT CODE FROM LG_215_EMUHACC WHERE LOGICALREF=(SELECT ACCREF FROM LG_215_01_CSTRANS WHERE ROLLREF=BN.SOURCEFREF))
    ELSE(SELECT CODE FROM LG_215_EMUHACC WHERE LOGICALREF=BN.ACCOUNTREF)END KARSIHESAPKODU,
    CASE BN.TRCODE WHEN '10' THEN
    (SELECT DEFINITION_ FROM LG_215_EMUHACC WHERE LOGICALREF=(SELECT ACCREF FROM LG_215_01_CSTRANS WHERE ROLLREF=BN.SOURCEFREF))
    ELSE(SELECT DEFINITION_ FROM LG_215_EMUHACC WHERE LOGICALREF=BN.ACCOUNTREF)END KARSIHESAPADI,
case BN.SIGN when 0 then 'BORC' ELSE 'ALACAK' END HAREKETTURU, BN.AMOUNT
FROM LG_215_01_BNFLINE BN) SNM ORDER BY SNM.TARIH