SELECT LN.KHR_ID CONTRACT_ID , PS.DUE_DATE DUE_DATE , SUM( PS.AMOUNT_DUE_REMAINING) AMOUNT_DUE FROM AR_PAYMENT_SCHEDULES_ALL PS , OKL_CNSLD_AR_STRMS_B ST , OKL_CNSLD_AR_LINES_B LN WHERE PS.CLASS IN ('INV' , 'CM') AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID AND ST.LLN_ID = LN.ID GROUP BY LN.KHR_ID , PS.DUE_DATE HAVING SUM(PS.AMOUNT_DUE_REMAINING ) > 0