Search Results okl_bpd_ar_inv_lines_v




Overview
Explore in AI Chat

Overview

OKL_BPD_AR_INV_LINES_V is an APPS-owned database view within the Oracle Lease and Finance Management (OKL) module. It is classified as a VALID object in both Oracle EBS 12.1.1 and 12.2.2 and is documented in ETRM as a view "to display Payable Invoice Line details." In practice, the view presents lease contract billing data flowing into Oracle Receivables, exposing the relationship between a lease contract, its billing stream, and the generated manual or auto-invoice lines in RA_CUSTOMER_TRX_LINES_ALL. It is therefore a reporting and integration layer that lets downstream consumers — custom reports, extracts, reconciliation processes, and BPD (Billing/Payment Detail) integrations — retrieve contract-linked receivables invoice line data without directly navigating the OKL transactional tables.

The user search term late_charge_ass_yn maps directly to a column exposed by this view, LATE_CHARGE_ASS_YN, which is sourced from OKL_TXD_AR_LN_DTLS_B. This confirms that the view is a primary access point for late-charge assessment information associated with lease invoice lines.

Underlying Base Objects

The view is defined over a set of documented base objects including synonyms and a package:

  • RA_CUSTOMER_TRX_LINES_ALL (SYNONYM) — the AR invoice line table, aliased RACTRL, supplying line number, quantity invoiced, unit selling price, line type, and customer_trx_line_id.
  • RA_CUSTOMER_TRX_ALL (SYNONYM) — aliased RACTRX, providing the transaction number, customer_trx_id, currency, and bill-to customer.
  • OKL_TXD_AR_LN_DTLS_B (SYNONYM) — aliased TXD, the lease transaction detail table that supplies the late-charge and late-interest assessment flags and dates, stream IDs, and the KHR/TIL/STY identifiers.
  • OKL_TXL_AR_INV_LNS_B (SYNONYM) — additional lease invoice line detail linkage.
  • OKL_STRM_TYPE_B (SYNONYM) — aliased SM, providing the stream type identifier.
  • AR_PAYMENT_SCHEDULES_ALL (SYNONYM) — aliased APS, supplying due date and payment schedule class.
  • OKL_BILLING_UTIL_PVT (PACKAGE) — an OKL billing utility package invoked within the SELECT to compute AMOUNT_DUE_REMAINING and AMOUNT_DUE_ORIGINAL per invoice line.

Because the view calls OKL_BILLING_UTIL_PVT functions, query performance depends on that package's execution path. Note that the documented text shows the original RACTRL.AMOUNT_DUE_REMAINING and AMOUNT_DUE_ORIGINAL columns commented out and replaced by the package calls.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciling lease billing to receivables, reporting open amounts by contract, and identifying lines flagged for late-charge or late-interest assessment. A representative query for late-charge reporting:

SELECT CONTRACT_NUMBER, RECEIVABLES_INVOICE_NUMBER, LINE_NUMBER, LATE_CHARGE_ASS_YN, LATE_CHARGE_ASSESS_DATE, AMOUNT_DUE_REMAINING FROM OKL_BPD_AR_INV_LINES_V WHERE LATE_CHARGE_ASS_YN = 'Y' AND ORG_ID = :p_org_id;

For outstanding balances by contract:

SELECT CONTRACT_NUMBER, TRX_NUMBER, CURRENCY_CODE, AMOUNT, AMOUNT_DUE_REMAINING, DUE_DATE FROM OKL_BPD_AR_INV_LINES_V WHERE AMOUNT_DUE_REMAINING > 0 ORDER BY DUE_DATE;

Because function-based columns invoke OKL_BILLING_UTIL_PVT, filters should be applied on indexed descriptive columns such as CONTRACT_NUMBER, ORG_ID, or the invoice identifiers wherever possible to limit the rows passed to the package calls.