View: OKL_BPD_TRX_SUM_LINES_RCPTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_TRX_SUM_LINES_RCPTS_UV

View Text

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

Columns