Results for “qlt_code”

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

Overview

OKL_AM_QUOTE_AMT_SUMMARY_UV is an APPS-owned database view within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It consolidates quote-level amount information from the OKL transaction and quote tables into a single reporting structure, aggregating line amounts by quote and quote line type. In Oracle EBS 12.1.1 and 12.2.2, this view serves as a reporting and integration layer over the underlying OKL quote tables, shielding consumers from the multi-table join logic required to reconcile quote lines, tax sources, contract lines, and stream types.

The view is particularly relevant to users searching on QST_CODE, a column the view exposes from OKL_TRX_QUOTES_B. QST_CODE denotes the quote status code, and its presence in this summary view allows reporting on quote amounts segmented by status without directly joining to the quote header table.

Underlying Base Objects

The view is defined over the following documented base objects:

• OKL_TRX_QUOTES_B (synonym) — the quote header table, supplying QUOTE_NUMBER, QST_CODE, QTP_CODE, ASSET_VALUE, RESIDUAL_VALUE, UNBILLED_RECEIVABLES, and GAIN_LOSS.
• OKL_TXL_QTE_LINES_ALL_B (synonym) — the quote line table, providing QLT_CODE and the summed AMOUNT.
• OKL_TAX_SOURCES (synonym) — supplies TOTAL_TAX for the AMCTAX union branch.
• FND_LOOKUPS (view) — resolves QLT_CODE into a MEANING via the OKL_QUOTE_LINE_TYPE lookup type.
• OKC_K_LINES_B (synonym) — contract line reference, outer-joined via KLE_ID.
• OKL_STRM_TYPE_V (view) — stream type reference, outer-joined via STY_ID, contributing NAME to FULL_DESCRIPTION.
• FND_GLOBAL (package) and OKL_ACCOUNTING_UTIL (package) — documented as referenced objects, typically used for session context and accounting utility logic.

The view is a UNION of two branches. The first aggregates quote line amounts excluding AMCFIA and AMCTAX line types; the second separately aggregates tax amounts (AMCTAX) from OKL_TAX_SOURCES. Both branches join lookup meanings and outer-join contract lines and stream types.

Key Columns

• QUOTE_NUMBER — the business-facing quote identifier.
• QLT_CODE / MEANING / FULL_DESCRIPTION — the quote line type code, its lookup meaning, and a concatenated description including the stream type name.
• QTE_ID — the internal quote identifier.
• AMOUNT — the summed line amount (or summed tax for the AMCTAX branch).
• QST_CODE — the quote status code from the quote header, central to status-based filtering.
• QTP_CODE — the quote type code.
• TOTAL_ASSET_VALUE, TOTAL_RESIDUAL_VALUE, TOTAL_UNBILLED_RECEIVABLES, GAIN_LOSS — quote-level financial totals carried through for reporting.

Common Use Cases and Queries

Typical usage includes quote amount reporting by status, line type analysis, and reconciliation of tax versus non-tax amounts. A representative query filtering on the searched attribute:

• SELECT quote_number, qst_code, qlt_code, amount FROM okl_am_quote_amt_summary_uv WHERE qst_code = :status;
• SELECT quote_number, SUM(amount) FROM okl_am_quote_amt_summary_uv GROUP BY quote_number;
• SELECT quote_number, full_description, total_residual_value, gain_loss FROM okl_am_quote_amt_summary_uv WHERE qlt_code = 'AMCTAX';

Because QST_CODE is exposed directly, integration and reporting solutions can summarise quote amounts by status without additional joins to the quote header, making the view suitable for operational dashboards and data extracts.