Results for “okl_am_quote_amounts_uv”

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

Overview

The OKL_AM_QUOTE_AMOUNTS_UV view is an Oracle Applications (APPS) database object owned by the APPS schema, delivered as part of the Oracle Leasing and Finance Management (OKL) module. It presents quote-level and quote-line-level monetary amounts associated with lease and finance quotes, consolidating header values maintained on OKL_TRX_QUOTES_B with line-level values held in OKL_TXL_QUOTE_LINES_V. The view is defined as a UNION of two subqueries, allowing standard quote lines and tax-derived lines (identified by the pseudo lookup code AMCTAX) to be reported together in a single result set.

Its principal reporting role is to expose descriptive and financial attributes of each quote amount line — the quote number, line type meaning, stream type, amount, and the various *_YN indicator flags — in a form suitable for concurrent programs, Extensible Flexfields, and integration extracts.

Underlying Base Objects

The documented base objects referenced by the view are:

• OKL_TRX_QUOTES_B (synonym) — the quote header table, aliased TQ, supplying QUOTE_NUMBER, ACCEPTED_YN, asset value, residual value, unbilled receivables, gain/loss, and per diem amounts.
• OKL_TXL_QUOTE_LINES_V (view) — the quote line view, aliased OTQ, supplying line-level amounts, quantities, flags, and flexfield attributes.
• FND_LOOKUPS (view) — aliased FND, joined on LOOKUP_TYPE = 'OKL_QUOTE_LINE_TYPE' to translate QLT_CODE into a meaningful line type description.
• OKC_K_LINES_V (view) — aliased KLE, providing the contract line (KLE) name via an outer join on KLE_ID.
• OKL_STRM_TYPE_V (view) — aliased STY, providing stream type name and description via an outer join on STY_ID.
• OKL_TAX_SOURCES (synonym) — the source for the AMCTAX union branch, joined to quotes by QTE_ID.
• FND_GLOBAL and OKL_ACCOUNTING_UTIL (packages) — utility packages invoked in the view definition.

The first UNION branch excludes line codes AMCFIA and AMCTAX; those tax-related amounts are supplied separately by the second branch.

Key Columns

• QUOTE_NUMBER — the user-visible quote identifier from the header.
• MEANING / FULL_DESCRIPTION — the line type lookup meaning, optionally concatenated with the stream type name.
• QLT_CODE — the quote line type lookup code.
• AMOUNT — the line amount (tax total for the AMCTAX branch).
• ACCEPTED_YN — a Yes/No indicator from the quote header (OKL_TRX_QUOTES_B.ACCEPTED_YN) recording whether the quote has been accepted. This is the column matched by the user's search term and is one of the primary status predicates used when filtering quotes.
• MODIFIED_YN, TAXED_YN, DEFAULTED_YN — line-level processing flags.
• ASSET_VALUE, RESIDUAL_VALUE, UNBILLED_RECEIVABLES, ASSET_QUANTITY, QUOTE_QUANTITY, DUE_DATE — financial and scheduling attributes available at both header and line level.
• KLE_ID / KLE_NAME, STY_ID / STREAM_TYPE_NAME — contract line and stream type context.
• ORG_ID and the ATTRIBUTE1–ATTRIBUTE15 columns — multi-org and descriptive flexfield values.
• WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent request identifiers (REQUEST_ID, PROGRAM_ID, etc.).

Common Use Cases and Queries

The view is typically queried to report accepted quote amounts, to reconcile residual and asset values against line amounts, or to drive downstream integration. A representative query filtering on the acceptance flag is:

SELECT quote_number, meaning, amount, accepted_yn, stream_type_name FROM okl_am_quote_amounts_uv WHERE accepted_yn = 'Y' AND org_id = :p_org_id ORDER BY quote_number;

Other frequent patterns include aggregating amounts by line type, listing only tax-derived (AMCTAX) lines, or restricting output to non-modified lines for audit purposes. Because the view is a UNION, queries should account for rows where LINE_NUMBER and OBJECT_VERSION_NUMBER return NULL.