OKL Principal Paydown Statement

  SELECT RECEIVABLE_APPLICATION_ID,
         TRANSACTION_TYPE, 
         INVOICE_NUMBER, 
         INVOICE_DATE, 
         TRANSACTION_AMOUNT,
         AMOUNT_APPLIED,
         AMOUNT_REMAINING,
         PAYMENT_METHOD,
         RECEIPT_NUMBER, 
         RECEIPT_AMOUNT,
         RECEIPT_DATE,
         CONTRACT_NUMBER,
         DUE_DATE,
         PAYMENT_APPLICATION_DATE, 
         APPLICATION_STATUS,
         LINE_IDENTIFIER,
         RECEIPT_CURRENCY_CODE,
         INVOICE_CURRENCY_CODE, 
         RECEIPT_METHOD_ID,
         CASH_RECEIPT_ID,
         INVOICE_ID,
         KHR_ID,
         CUST_ACCOUNT_ID, 
         RECEIPT_TYPE_CODE,
         ORG_ID,
         CUSTOMER_ID,
         RECEIPT_STATUS_CODE,
         RECEIPT_STATUS, 
         INVOICE_LINE_ID,
         ADVANCED_YN,
         CUSTOMER_ACCOUNT_NUMBER
FROM OKL_CS_TRX_PAYMENTS_UV
WHERE KHR_ID = :P_CONTRACT_ID
AND TRANSACTION_TYPE IN
(SELECT CODE
 FROM OKL_STRM_TYPE_B
 WHERE STREAM_TYPE_PURPOSE = 'UNSCHEDULED_PRINCIPAL_PAYMENT')