SELECT WSL.WORKSHEET_HEADER_ID , AR.BANK_ACCOUNT_ID , WSL.WORKSHEET_LINE_ID , WSL.DESCRIPTION , AR.RECEIPT_NUMBER , DECODE(AR.CURRENCY_CODE , XBA.CURRENCY_CODE , AR.AMOUNT , AR.BASE_AMOUNT) BALANCE , AR.REFERENCE_ID FROM CE_AR_FC_RECEIPTS_V AR , CE_CP_WORKSHEET_LINES WSL , CE_CP_XTR_BANK_ACCOUNTS_V XBA WHERE AR.CASH_ACTIVITY_DATE = TRUNC(SYSDATE) AND WSL.SOURCE_TYPE = 'ARR' AND WSL.INCLUDE_FLAG = 'Y' AND (WSL.CLEARED_TRX_FLAG = 'Y' OR AR.STATUS NOT IN ('CLEARED' , 'RISK_ELIMINATED')) AND (WSL.RECEIPT_METHOD_ID IS NULL OR AR.RECEIPT_METHOD_ID = WSL.RECEIPT_METHOD_ID) AND AR.BANK_ACCOUNT_ID = XBA.BANK_ACCOUNT_ID