View: OKL_CS_AMORT_SCHEDULES_UV

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

View Text

SELECT CTR_HDR.ID ID
, CTR_HDR.CONTRACT_NUMBER CONTRACT_NUMBER
, X.STREAM_ELEMENT_DATE DUE_DATE
, (SUM(X.AMOUNT) + SUM(Y.AMOUNT)) TOTAL_PAYMENT
, SUM(X.AMOUNT) PRINCIPAL_PAYMENT
, SUM(Y.AMOUNT) INTEREST_AMOUNT
, SUM(Z.AMOUNT) PRINCIPAL_BALANCE
, 0 ACCRUAL_AMOUNT
, CTR_HDR.CURRENCY_CODE
, X.KLE_ID KLE_ID
, X.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
FROM OKC_K_HEADERS_V CTR_HDR
, OKC_K_LINES_V CTR_LN
, OKL_CS_SCHPRINC_PAYMENTS_UV X
, OKL_CS_SCHINTR_PAYMENTS_UV Y
, OKL_CS_SCHPRINC_BALANCE_UV Z
WHERE CTR_HDR.ID = CTR_LN.CHR_ID
AND CTR_LN.ID = X.KLE_ID
AND X.KLE_ID = Y.KLE_ID
AND Y.KLE_ID = Z.KLE_ID
AND X.STREAM_ELEMENT_DATE = Y.STREAM_ELEMENT_DATE
AND Y.STREAM_ELEMENT_DATE = Z.STREAM_ELEMENT_DATE GROUP BY X.STREAM_ELEMENT_DATE
, CTR_HDR.ID
, CTR_HDR.CONTRACT_NUMBER
, CTR_HDR.CURRENCY_CODE
, X.KLE_ID

Columns