SELECT SUM(AR.AMOUNT_DUE_ORIGINAL-AR.AMOUNT_DUE_REMAINING) AMOUNT_RECEIVED , TIL.KLE_ID KLE_ID FROM FND_LOOKUPS FLT , AR_PAYMENT_SCHEDULES_ALL AR , OKL_EXT_SELL_INVS_B XSI , OKL_XTL_SELL_INVS_B XLS , OKL_TXD_AR_LN_DTLS_B TLD , OKL_TXL_AR_INV_LNS_B TIL , OKL_TRX_AR_INVOICES_B TAI WHERE XSI.RECEIVABLES_INVOICE_ID = AR.PAYMENT_SCHEDULE_ID AND XSI.ID = XLS.XSI_ID_DETAILS AND XSI.TRX_STATUS_CODE = FLT.LOOKUP_CODE AND FLT.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS' AND XLS.TLD_ID = TLD.ID AND TLD.TIL_ID_DETAILS = TIL.ID AND TIL.TAI_ID = TAI.ID GROUP BY TIL.KLE_ID