VIEW: APPS.OKL_BPD_K_DUE_DATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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