Search Results line_name




Overview
Explore in AI Chat

Overview

OKL_BPD_TRX_SUM_LINES_RCPTS_UV is an APPS-owned reporting view in the Oracle Lease and Finance Management (OKL) module. It presents aggregated receipt and transaction line information for consolidated invoices, contract lines, and billing streams. The view is part of the Oracle Enterprise Traffic Routing Manager (ETRM) metadata set and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2 environments.

The view's primary function is to aggregate financial amounts — original amount due, tax, amount paid, and remaining balance — across billing line receipts, grouped by consolidated invoice, contract, and line identifiers. It serves as a denormalized, summary-level data source for reporting and integration scenarios where line-level financial rollups are required without joining the more granular receipt stream data.

Underlying Base Objects

According to documented ETRM metadata, OKL_BPD_TRX_SUM_LINES_RCPTS_UV is defined over two referenced base objects:

The view text explicitly selects from OKL_BPD_TRX_SUM_STRMS_RCPTS_UV, applying a GROUP BY clause on CONSOLIDATED_INVOICE_NUMBER, CONTRACT_NUMBER, CONTRACT_LINE_ID, CONSOLIDATED_LINE_NUMBER, and LINE_NAME. The aggregate columns SUM(AMOUNT_DUE_ORIGINAL), SUM(TAX_AMOUNT), SUM(AMOUNT_PAID), and SUM(BALANCE) collapse stream-level rows into one row per billing line. The dependency on OKL_BPD_TRX_SUM_STRMS_RCPTS_UV means this view inherits the filtering, security, and scope logic applied at the stream level.

Key Columns

  • CONSOLIDATED_INVOICE_NUMBER — Identifier of the consolidated invoice grouping that the line belongs to.
  • CONTRACT_NUMBER — Lease or finance contract number associated with the transaction.
  • CONTRACT_LINE_ID — Surrogate identifier of the contract line, used for programmatic joins.
  • CONSOLIDATED_LINE_NUMBER — Line number within the consolidated invoice for user-facing reference.
  • LINE_NAME — Descriptive name of the billing line.
  • AMOUNT_DUE_ORIGINAL — Sum of the original amount due across the underlying receipt streams.
  • TAX_AMOUNT — Sum of tax amounts applied to the line.
  • AMOUNT_PAID — Sum of payments received against the line.
  • BALANCE — Sum of remaining balances (typically AMOUNT_DUE_ORIGINAL plus TAX_AMOUNT minus AMOUNT_PAID).

These nine columns form a compact financial summary suitable for accounts receivable aging, lease billing reconciliation, and cash application reporting.

Common Use Cases and Queries

This view is typically used in receivables reporting, billing reconciliation, and custom Oracle Reports or BI Publisher data templates within OKL. A representative query that returns line-level summaries for a specific contract is shown below:

SELECT consolidated_invoice_number,
       contract_number,
       consolidated_line_number,
       line_name,
       amount_due_original,
       tax_amount,
       amount_paid,
       balance
FROM   apps.okl_bpd_trx_sum_lines_rcpts_uv
WHERE  contract_number = :p_contract_number
ORDER BY consolidated_invoice_number, consolidated_line_number;

A second common pattern aggregates the view for outstanding balances by invoice:

SELECT consolidated_invoice_number,
       SUM(balance) total_outstanding
FROM   apps.okl_bpd_trx_sum_lines_rcpts_uv
WHERE  balance > 0
GROUP BY consolidated_invoice_number
ORDER BY total_outstanding DESC;

Because the view already consolidates stream-level rows, it is economical to query directly rather than re-aggregating OKL_BPD_TRX_SUM_STRMS_RCPTS_UV. Queries should always reference the view through the APPS schema or a synonym, and should apply contract or invoice predicates to leverage the underlying stream filters. No DML should be attempted against this view; it is read-only and intended exclusively for reporting and integration consumption in Oracle EBS 12.1.1 and 12.2.2.