Search Results amount_line_items_remaining




Overview
Explore in AI Chat

Overview

APPS.OKL_BPD_AR_INV_LINES_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 reporting view within the Enterprise Contracts (formerly Oracle Lease and Finance Management / OKL) module. Its name, composed of "BPD" (Billing and Payment Details), "AR," and "INV_LINES," signals its purpose: exposing Accounts Receivable invoice lines generated from contract billing events alongside their originating contract, stream, and transaction detail context. The view is a denormalized read layer that joins Receivables transaction lines to OKL contract and stream tables, primarily serving reporting, analysis, and integration scenarios where users require visibility into invoiced amounts, remaining balances, and payment due dates. Notably, the view does not store data itself; every column is derived at query time from joined base tables or from calls to the OKL_BILLING_UTIL_PVT package. The user search term "amount_line_items_remaining" corresponds directly to a column in this view that quantifies how much of an invoice line's billed amount remains outstanding after applying receipts and credits.

Underlying Base Objects

The view is defined over several documented base objects. RA_CUSTOMER_TRX_LINES_ALL supplies the core Receivables invoice line rows, including quantity invoiced, unit selling price, line number, and the customer_trx_line_id join key. RA_CUSTOMER_TRX_ALL provides the invoice header data, such as transaction number, customer_trx_id, bill-to customer, invoice currency, and org_id. OKL_TXD_AR_LN_DTLS_B holds the OKL transaction detail rows that link contract billing events to AR lines, carrying stream, structure, and late charge/interest assessment flags. OKL_STRM_TYPE_B supplies stream type definitions, while OKL_TXL_AR_INV_LNS_B and AR_PAYMENT_SCHEDULES_ALL contribute additional invoice and scheduling attributes, including APS.DUE_DATE and APS.CLASS. The OKL_BILLING_UTIL_PVT package is invoked inline for the AMOUNT_DUE_REMAINING, AMOUNT_DUE_ORIGINAL, AMOUNT_LINE_ITEMS_REMAINING, and INV_LN_AMT_REMAINING_WOTAX columns, meaning those amounts are computed by PL/SQL logic rather than read directly from a stored column. This design reflects the underlying AR columns having been intentionally commented out in favor of the package-based calculations.

Key Columns

Common Use Cases and Queries

Typical uses include contract-to-invoice reconciliation, aged receivables analysis for leased assets, and reports on unapplied or partially applied invoice lines. A sample query retrieving outstanding line balances for a contract:

  • SELECT CONTRACT_NUMBER, RECEIVABLES_INVOICE_NUMBER, LINE_NUMBER, AMOUNT, AMOUNT_LINE_ITEMS_REMAINING, DUE_DATE FROM APPS.OKL_BPD_AR_INV_LINES_V WHERE CONTRACT_NUMBER = :p_contract ORDER BY DUE_DATE;
  • SELECT RECEIVABLES_INVOICE_NUMBER, SUM(AMOUNT_LINE_ITEMS_REMAINING) AMT_OPEN FROM APPS.OKL_BPD_AR_INV_LINES_V WHERE ORG_ID = :p_org GROUP BY RECEIVABLES_INVOICE_NUMBER HAVING SUM(AMOUNT_LINE_ITEMS_REMAINING) > 0;

Because the remaining-amount columns derive from package functions, performance depends on the volume of lines queried; restricting by ORG_ID, CONTRACT_NUMBER, or DUE_DATE is advisable.