OKL Principal Paydown Statement

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLPRINPAYDOWN
DB package:
Run OKL Principal Paydown Statement and other Oracle EBS reports with Blitz Report™ on our demo environment
  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')
Download
Related Blitz Reports
RK: AR Transactions and Lines OKL Billing Inquiry Data Avalara VAT LinesData Avalara VAT listing OKL Amortization Schedule OKL Accept Quote OKL Termination Quotes OKL Loans Amortization Schedule OKL Lease Property Tax
Blitz Report™

Blitz Report™ provides multiple benefits: