SELECT WSL.WORKSHEET_HEADER_ID , XTI.BANK_ACCOUNT_ID , WSL.WORKSHEET_LINE_ID , WSL.DESCRIPTION , TO_CHAR(XTI.DEAL_NUMBER) , XTI.AMOUNT , XTI.REFERENCE_ID FROM CE_XTR_CASHFLOWS_V XTI , CE_CP_WORKSHEET_LINES WSL WHERE XTI.TRX_DATE = TO_DATE(SYSDATE , 'YYYY/MM/DD') AND WSL.SOURCE_TYPE = 'XTI' AND WSL.INCLUDE_FLAG = 'Y' AND XTI.AMOUNT >= 0 AND (WSL.CLEARED_TRX_FLAG = 'Y' OR XTI.RECONCILED_REFERENCE IS NULL) AND (WSL.INDICATIVE_FLAG = 'Y' OR NOT (XTI.DDA_DEAL_TYPE = 'EXP' AND XTI.DDA_DEAL_SUBTYPE = 'INDIC'))