Search Results total_due_amount

Overview

ZOKL_CSE_K_STATS_V is a reporting view within the Oracle E-Business Suite (EBS) OKL – Leasing and Finance Management module. Its documented purpose is to expose the contents of the OKL_CSE_K_STASTICS base table (spelled in the documentation as OKL_CSE_K_STASTICS, while the view name and the underlying statistics table are commonly referenced as OKL_CSE_K_STATISTICS). The view presents a denormalized, read-only projection of customer/contract statistics used by the Leasing and Finance Management "Key Statistics" or credit/customer summary functionality.

The view is intended for reporting and integration purposes rather than transactional processing. It surfaces aggregated snapshot figures captured at a point in time, indicated by the AS_OF_DATE column, allowing downstream reports, dashboards, and interfaces to consume contract-level financial performance metrics without querying the base table directly. Because the view is "Not implemented in this database" per the ETRM documentation, its presence depends on the specific implementation and patch level of the OKL module in a given environment.

Underlying Base Objects

According to the documented view text, the view is defined solely over a single underlying object aliased as CCSB, which corresponds to the OKL_CSE_K_STASTICS (OKL_CSE_K_STATISTICS) table. No joined tables or additional base objects are documented. The view is a straightforward SELECT of columns from this one source, using CCSB.ROWID exposed as ROW_ID to preserve a unique row identifier, together with the table's primary key (ID) and OBJECT_VERSION_NUMBER for optimistic locking and version tracking.

Although the documented "Referenced base objects" list is empty and the owner is not documented, the view text makes the single-source dependency unambiguous. The CCSB alias surfaces standard EBS audit and multi-org columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ORG_ID), concurrent program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), and the ATTRIBUTE1 through ATTRIBUTE15 descriptive flexfield (DFF) columns.

Key Columns

• ID / ROW_ID / OBJECT_VERSION_NUMBER – Primary key, unique row locator, and version stamp for the statistics record.
• CCC_ID – Foreign reference linking the statistics row to the associated contract/customer credit record.
• SEQUENCE_NUMBER / AS_OF_DATE – Identifies the ordering and the effective date of the statistics snapshot.
• LAST_INVOICE_DATE – The date of the most recent invoice generated for the contract; this is the column most relevant to the "last_invoice_date" search and is frequently used to determine billing recency.
• LAST_INVOICE_DUE_DATE / LAST_INVOICE_AMOUNT – Due date and amount of the last invoice.
• NEXT_INVOICE_DATE / NEXT_INVOICE_AMOUNT – Scheduled date and amount of the upcoming invoice.
• PAST_DUE_AMOUNT / DAYS_PAST_DUE / TOTAL_DUE_AMOUNT – Delinquency and outstanding balance measures.
• NUMBER_PAST_DUE_30/45/60/90 – Aging bucket counters for overdue invoices.
• TOTAL_OVERDUE_INVOICES – Aggregate count of overdue invoices.
• LAST_PAYMENT_AMOUNT / LAST_PAYMENT_METHOD / LAST_PAYMENT_STATUS – Most recent payment details.
• NUMBER_OF_NSF_FEES – Count of non-sufficient-funds fees.
• TOTAL_NUMBER_OF_PAYMENTS / REMAINING_NUMBER_OF_PAYMENTS – Payment schedule progress.
• ORG_ID – Operating unit context for multi-org security.
• ATTRIBUTE1–15 / ATTRIBUTE_CATEGORY – Descriptive flexfield segments for client-specific extensions.

Common Use Cases and Queries

The view supports billing and delinquency reporting, customer statement generation, and integration extracts. A typical query filters by last invoice activity, which directly addresses the "last_invoice_date" search.

Find contracts with recent invoicing:

SELECT ccc_id, last_invoice_date, last_invoice_amount, last_invoice_due_date
FROM   zokl_cse_k_stats_v
WHERE  last_invoice_date >= :p_from_date
ORDER  BY last_invoice_date DESC;

Delinquency and aging snapshot:

SELECT ccc_id, as_of_date, days_past_due, past_due_amount,
       number_past_due_30, number_past_due_60, number_past_due_90,
       total_overdue_invoices
FROM   zokl_cse_k_stats_v
WHERE  org_id = :p_org_id
  AND  total_overdue_invoices > 0;

Latest snapshot per contract:

SELECT *
FROM  (SELECT ccc_id, as_of_date, last_invoice_date, last_invoice_amount,
              ROW_NUMBER() OVER (PARTITION BY ccc_id ORDER BY as_of_date DESC) rn
       FROM   zokl_cse_k_stats_v)
WHERE rn = 1;

These patterns let reporting tools and interfaces consume invoice, payment, and aging metrics while honoring ORG_ID security and version context.