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