VIEW: APPS.OKL_CS_AMORT_SCHEDULES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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