Search Results total_residual_value




Overview
Explore in AI Chat

Overview

The view APPS.OKL_QUOTE_AMT_SMRY_ALL_UV is a reporting object within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. As its name implies, it presents a consolidated amount summary for quotes across all operating units, providing a cross-operating-unit ("_ALL_") unified read-only ("_UV") perspective. In Oracle EBS 12.1.1 and 12.2.2, this view is commonly used by internal reporting logic, Oracle Business Intelligence Publisher reports, and custom inquiries that require a roll-up of quoted amounts without the burden of operating unit security filtering.

The view is particularly relevant to users searching for total_unbilled_receivables. That term appears as a projected column alias in the view definition, sourced from QTE.UNBILLED_RECEIVABLES in the underlying quotes base table. This makes the view a convenient single source for retrieving the total unbilled receivable amount associated with a quote, alongside other summary values.

Underlying Base Objects

The documented base objects referenced by this view are:

  • OKL_TRX_QUOTES_ALL_B (synonym) — the primary quotes table, providing quote header attributes such as quote number, status, quote type, asset value, residual value, unbilled receivables, and gain/loss.
  • OKL_TXL_QTE_LINES_ALL_B (synonym) — quote lines, supplying the line type code and amount that drive the summarized AMOUNT column.
  • OKL_TAX_SOURCES (synonym) — tax source records used in the UNION branch to surface estimated invoice tax amounts as a synthetic "AMCTAX" line type.
  • FND_LOOKUPS (view) — the standard lookup view, joined on lookup type OKL_QUOTE_LINE_TYPE to resolve the meaning and full description of each line type.
  • OKC_K_LINES_B (synonym) — contract line base table, outer-joined via KLE_ID.
  • OKL_STRM_TYPE_V (view) — stream type view, outer-joined via STY_ID to enrich the description with the stream name.
  • FND_GLOBAL (package) and OKL_ACCOUNTING_UTIL (package) — listed as referenced objects, typically consumed by the underlying view logic for context and accounting-derived values.

The view is defined as a UNION of two branches: one summarizing regular quote lines (excluding the AMCFIA line type), and one for estimated invoice tax amounts (AMCTAX). Results are grouped by quote, line type meaning, status, type, and the header-level amount fields, including unbilled receivables.

Key Columns

  • QUOTE_NUMBER — the quote identifier from OKL_TRX_QUOTES_ALL_B.
  • QLT_CODE / MEANING / FULL_DESCRIPTION — the quote line type code and its decoded lookup meaning, with an optional stream name appended.
  • QTE_ID — the internal quote ID.
  • AMOUNT — the summed amount for the line type (or total tax for the AMCTAX branch).
  • QST_CODE / QTP_CODE — quote status and quote type codes.
  • TOTAL_ASSET_VALUE / TOTAL_RESIDUAL_VALUE — header-level asset and residual values.
  • TOTAL_UNBILLED_RECEIVABLES — the key column for users searching this term; sourced directly from QTE.UNBILLED_RECEIVABLES and repeated across grouped rows.
  • GAIN_LOSS — the quote-level gain or loss figure.

Common Use Cases and Queries

Typical uses include cross-operating-unit quote amount reporting, reconciliation of unbilled receivables against quote line detail, and feeding financial summaries. A representative query to retrieve total unbilled receivables per quote follows:

SELECT quote_number, qte_id, qst_code, qtp_code,
  MAX(total_unbilled_receivables) total_unbilled_receivables
FROM apps.okl_quote_amt_smry_all_uv
GROUP BY quote_number, qte_id, qst_code, qtp_code;

To break down summarized amounts by line type:

SELECT quote_number, qlt_code, meaning, amount
FROM apps.okl_quote_amt_smry_all_uv
WHERE quote_number = :quote_number
ORDER BY qlt_code;

Because TOTAL_UNBILLED_RECEIVABLES is a header-level value duplicated on each grouped row, aggregations should apply MAX or DISTINCT to avoid over-counting.