Search Results okl_cs_bpd_inv_dtl_v




Overview
Explore in AI Chat

Overview

OKL_CS_BPD_INV_DTL_V is an APPS-owned database view in the OKL (Leasing and Finance Management) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It is described in the ETRM repository as the "New CS Billing base view." Its purpose is to present a unified, consolidated picture of billing invoice detail for leasing contracts across two distinct origination paths — consolidated lease invoices created within OKL and standard Oracle Receivables invoices. Because it merges these sources into a single row-per-invoice-line result set, the view functions as a reporting and integration foundation for downstream billing analysis, reconciliation, and customer-facing invoice extracts rather than as a transaction-entry object. It exposes party, currency, amount, tax, and applied/credited/remaining balance information via calls to the OKL_BILLING_UTIL_PVT package.

Underlying Base Objects

The documented base objects reveal a UNION-based definition spanning the leasing consolidation tables and the Receivables tables:

Key Columns

Common Use Cases and Queries

Typical usage includes billing detail extracts, open-balance and aging analysis, tax reconciliation, and reconciliation between consolidated lease invoices and their AR counterparts.

  • Invoice listing by contract:
    SELECT contract_number, invoice_number, invoice_type, invoice_amount, due_date FROM okl_cs_bpd_inv_dtl_v WHERE contract_number = :p_contract;
  • Outstanding balance review:
    SELECT invoice_number, invoice_amount, amount_applied, amount_remaining FROM okl_cs_bpd_inv_dtl_v WHERE amount_remaining > 0 ORDER BY due_date;
  • Separating consolidated versus AR invoices:
    SELECT invoice_type, COUNT(*), SUM(invoice_amount) FROM okl_cs_bpd_inv_dtl_v GROUP BY invoice_type;

Because the view performs inline package function calls, performance-sensitive queries should filter on INVOICE_ID, CONTRACT_NUMBER, or ORG_ID to limit row volume.