SELECT CONSOLIDATED_INVOICE_ID, CONSOLIDATED_INVOICE_NUMBER, due_date, currency_code, NULL, NULL, NULL, NULL, SUM(AMOUNT_DUE_ORIGINAL), SUM(AMOUNT_DUE_REMAINING) FROM OKL_BPD_LEASING_PAYMENT_TRX_V GROUP BY CONSOLIDATED_INVOICE_ID, CONSOLIDATED_INVOICE_NUMBER, currency_code, due_date
SELECT CONSOLIDATED_INVOICE_ID
, CONSOLIDATED_INVOICE_NUMBER
, DUE_DATE
, CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, SUM(AMOUNT_DUE_ORIGINAL)
, SUM(AMOUNT_DUE_REMAINING)
FROM OKL_BPD_LEASING_PAYMENT_TRX_V GROUP BY CONSOLIDATED_INVOICE_ID
, CONSOLIDATED_INVOICE_NUMBER
, CURRENCY_CODE
, DUE_DATE
|
|
|