Search Results receivables_invoice_number




Overview
Explore in AI Chat

Overview

APPS.OKL_BPD_TRX_SUM_STRMS_RCPTS_UV is a supplementary view in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, owned by the APPS schema and registered as FND Design Data OKL.OKL_BPD_TRX_SUM_STRMS_RCPTS_UV. Its documented purpose is to simplify forms coding; Oracle explicitly warns that the view is not intended for direct query or data manipulation and that its definition may change dramatically in subsequent minor or major releases. In practice it functions as a reporting and integration surface that consolidates transaction summary information across lease contract streams and their associated receivables activity, exposing invoice, contract, tax, and payment amounts in a single row-per-stream structure. The view is validated in both 12.1.1 and 12.2.2 environments.

The column name most frequently associated with the search term "receivables_invoice_number" is RECEIVABLES_INVOICE_NUMBER (VARCHAR2(30)), which carries the Oracle Receivables invoice number linked to a given lease stream. This view is therefore a natural starting point when reconciling lease contract billing streams against their downstream AR invoices.

Underlying Base Objects

The ETRM metadata documents two dependencies for this view: the package APPS.OKL_ACCOUNTING_UTIL and the view APPS.OKL_BPD_LEASING_PAYMENT_TRX_V. OKL_BPD_LEASING_PAYMENT_TRX_V supplies the leasing payment transaction detail (contract, stream, and amount information) that the outer view summarizes. OKL_ACCOUNTING_UTIL is an accounting utility package referenced in the view definition, typically invoked to derive accounting-related attributes or stream purpose meaning values exposed as STREAM_PURPOSE_MEANING. The view also carries an LSM_ID column documented as a foreign key to the view OKL_CNSLD_AR_STRMS_V, which provides consolidated AR stream context. In turn, OKL_BPD_TRX_SUM_STRMS_RCPTS_UV is referenced by APPS.OKL_BPD_TRX_SUM_LINES_RCPTS_UV, forming a small hierarchy of BPD (Business Process Definition) reporting views used by the Lease Management forms.

Key Columns

  • CONSOLIDATED_INVOICE_NUMBER / CONSOLIDATED_INVOICE_ID / CONSOLIDATED_LINE_NUMBER — consolidated invoice identifiers and the associated line number within that invoice.
  • CONTRACT_NUMBER / CONTRACT_LINE_ID — the lease contract number and its line identifier, key to linking streams back to contract terms.
  • RECEIVABLES_INVOICE_NUMBER — the Oracle Receivables invoice number for the billing generated against the stream, the primary join key to AR reporting.
  • STREAM_NAME / STREAM_PURPOSE_MEANING / LINE_NAME — descriptive attributes identifying the payment stream, its purpose (e.g., rent, tax, fees), and the line it belongs to.
  • TAX_AMOUNT / AMOUNT_DUE_ORIGINAL / BALANCE / AMOUNT_PAID — monetary measures covering original amount due, tax, outstanding balance, and amount paid, supporting aging and collection analysis.
  • LSM_ID — foreign key to OKL_CNSLD_AR_STRMS_V, used to tie the row to the consolidated AR stream record.

Common Use Cases and Queries

Typical scenarios include reconciling lease billing streams to Receivables invoices, analyzing tax and payment status by contract, and driving lease payment forms. A representative query filtering on the receivables invoice number follows:

SELECT contract_number, stream_name, receivables_invoice_number, amount_due_original, amount_paid, balance, tax_amount, stream_purpose_meaning FROM apps.okl_bpd_trx_sum_strms_rcpts_uv WHERE receivables_invoice_number = :p_invoice_number;

A second pattern aggregates payments by contract:

SELECT contract_number, SUM(amount_paid) paid, SUM(balance) open_balance FROM apps.okl_bpd_trx_sum_strms_rcpts_uv GROUP BY contract_number;

Because Oracle documents the view as supplementary and unstable across releases, production integrations should confirm column semantics against each target release and consider sourcing from the documented underlying objects where long-term stability is required.