SELECT TRANS_ID, PRI_IDENTITY, TRX_AMT, TRANS_DATE, DECODE(TRANS_TYPE,'TFT','0','1') AS OPERATION FROM ardb98.AR_LOG_TRX WHERE BE_ID = '101' AND CHANNEL_ID = '222' AND (TRANS_TYPE = 'TFF' OR TRANS_TYPE='TFT') AND TRANS_DATE >= TO_DATE(20170327095000, 'YYYYMMDDHH24MISS') AND TRANS_DATE < TO_DATE(20170327095000, 'YYYYMMDDHH24MISS')