trans = select TR.SKF_REALIZED_TRANSACTION_CLD, TR.SKF_REALIZED_TRANSACTION_CLN, TR.CODE_CANCEL_TYPE, tr.TEXT_TRANSACTION_APPOINTMENT, tr.AMT_TRANSACTION, tr.SKP_ACCOUNT_BANK_CREDIT, tr.SKP_ACCOUNT_BANK_DEBIT, cr.text_gl_number, cr.text_gl_number_short, cr.text_iban, db.text_gl_number, db.text_gl_number_short, db.text_iban, cr.skp_client_bank, db.skp_client_bank from OWNER_DWH.F_REALIZED_TRANSACTION_TT TR join OWNER_DWH.F_ACCOUNT_BANK_AD cr on cr.skp_account_bank = tr.SKP_ACCOUNT_BANK_CREDIT join OWNER_DWH.F_ACCOUNT_BANK_AD db on db.skp_account_bank = tr.SKP_ACCOUNT_BANK_DEBIT where 1=1 and tr.DATE_REALIZATION = trunc(sysdate) - 1 and db.text_gl_number_short ='1860';