Results for “interface_line_context”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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

• CONTRACT_NUMBER / CONTRACT_ID / CONTRACT_LINE_ID — derived from RACTRL.INTERFACE_LINE_ATTRIBUTE6, TXD.KHR_ID, and TXD.KLE_ID, linking the invoice line to the lease contract and contract line.
• RECEIVABLES_INVOICE_NUMBER / RECEIVABLES_INVOICE_ID / INVOICE_ID — the AR transaction number and identifier.
• LATE_CHARGE_ASS_YN — late-charge assessment flag sourced from OKL_TXD_AR_LN_DTLS_B, with the companion LATE_CHARGE_ASSESS_DATE.
• LATE_INT_ASS_YN / LATE_INT_ASSESS_DATE — late-interest assessment flag and date.
• AMOUNT_DUE_REMAINING / AMOUNT_DUE_ORIGINAL — computed dynamically via OKL_BILLING_UTIL_PVT for the invoice line.
• AMOUNT — calculated as quantity invoiced multiplied by unit selling price.
• TAX_AMOUNT — a scalar subquery summing EXTENDED_AMOUNT from RA_CUSTOMER_TRX_LINES_ALL where LINK_TO_CUST_TRX_LINE_ID matches and LINE_TYPE = 'TAX'.
• STREAM_ID / STREAM_TYPE_ID / STY_ID / SEL_ID / TXD_ID — stream and stream-type identifiers used to characterize the billing stream.
• DUE_DATE / CLASS — payment schedule attributes.
• LINE_TYPE / TXN_LINE_TYPE / INTERFACE_LINE_CONTEXT — line classification fields.
• CURRENCY_CODE, ORG_ID, IXX_ID (bill-to customer), RECEIVABLES_INVOICE_LINE_ID.

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.