SELECT consolidated_invoice_number, contract_number, contract_line_id, consolidated_line_number, line_name, SUM(amount_due_original) amount_due_original, SUM(tax_amount) tax_amount, SUM(amount_paid) amount_paid, SUM(balance) balance FROM OKL_BPD_TRX_SUM_STRMS_RCPTS_UV GROUP BY consolidated_invoice_number, contract_number, contract_line_id, consolidated_line_number, line_name
SELECT CONSOLIDATED_INVOICE_NUMBER
, CONTRACT_NUMBER
, CONTRACT_LINE_ID
, CONSOLIDATED_LINE_NUMBER
, LINE_NAME
, SUM(AMOUNT_DUE_ORIGINAL) AMOUNT_DUE_ORIGINAL
, SUM(TAX_AMOUNT) TAX_AMOUNT
, SUM(AMOUNT_PAID) AMOUNT_PAID
, SUM(BALANCE) BALANCE
FROM OKL_BPD_TRX_SUM_STRMS_RCPTS_UV GROUP BY CONSOLIDATED_INVOICE_NUMBER
, CONTRACT_NUMBER
, CONTRACT_LINE_ID
, CONSOLIDATED_LINE_NUMBER
, LINE_NAME
|
|
|