Results for “okl_quote_type”

50+ results




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

Overview

The view APPS.OKL_H_AM_QUOTES_UV belongs to the Oracle E-Business Suite (EBS) Enterprise Contracts / Lease Management (formerly ETRM — Enterprise Trading and Risk Management) module. Its name follows the standard EBS convention: the _UV suffix indicates a user-named validation or LOV (List of Values) view, while the _H_ segment and the AM reference associate it with the lease/asset management functional area in which transaction quotes are captured.

The view presents a de-duplicated list of quote types drawn from the OKL_TRX_QUOTES_B table, paired with their translated display values from the FND_LOOKUPS view. Because it joins the lookup codes against the Flexfield/Lookup infrastructure using the lookup type OKL_QUOTE_TYPE, it exposes the descriptive meaning of each quote type rather than the bare internal code. This makes it directly suitable for LOV definitions, concurrent report parameters, and integration payloads that must present a business-readable quote type.

In the context of the search term "okl_quote_type", this view is the canonical source that links the OKL_QUOTE_TYPE lookup to actual quote records, ensuring only quote types that have been used on non-consolidated quotes appear in the returned list.

Underlying Base Objects

The documented metadata identifies three referenced base objects:

  • OKL_TRX_QUOTES_B (SYNONYM) — the base table holding transaction quote definitions. It supplies the QTP_CODE and the CONSOLIDATED_YN columns used in the view logic.
  • FND_LOOKUPS (VIEW) — the standard EBS lookup view. Although the view text references FND_LOOKUPS directly, the documented dependency is recorded against the view form. It filters on LOOKUP_TYPE = 'OKL_QUOTE_TYPE'.
  • FND_GLOBAL (PACKAGE) — the session context package. EBS views that depend on FND_GLOBAL typically rely on FND_GLOBAL.USER_ID or ORG_ID for security or organization context within the view definition (not visible in the excerpted SELECT, but present in the documented dependency list).

The join key is OTQ.QTP_CODE = FL2.LOOKUP_CODE, restricted to lookup type OKL_QUOTE_TYPE. The predicate OTQ.CONSOLIDATED_YN = 'N' excludes quotes that have been consolidated, so the view reflects only unconsolidated (individually managed) quotes.

Key Columns

  • QUOTE_TYPE — sourced from OKL_TRX_QUOTES_B.QTP_CODE. This is the internal lookup code identifying the quote type.
  • QUOTE_TYPE_DESCRIPTION — sourced from FND_LOOKUPS.MEANING. This is the translatable, user-facing description corresponding to the lookup code. Because it derives from FND_LOOKUPS, the value respects the installed language and the lookup's current definition.

The view is intentionally narrow: it exposes only two columns, reinforcing its role as a validation/LOV source rather than a general reporting view.

Common Use Cases and Queries

Typical uses include populating an LOV attached to a quote-type field, driving a report parameter, or feeding an interface that must map internal quote-type codes to business descriptions. A representative query is:

  • SELECT QUOTE_TYPE, QUOTE_TYPE_DESCRIPTION FROM APPS.OKL_H_AM_QUOTES_UV ORDER BY QUOTE_TYPE_DESCRIPTION;
  • Filtering for a specific type: SELECT QUOTE_TYPE_DESCRIPTION FROM APPS.OKL_H_AM_QUOTES_UV WHERE QUOTE_TYPE = :p_quote_type;
  • Used as an LOV query with the description displayed and the code returned, ensuring consistency with the seeded OKL_QUOTE_TYPE lookup.

Because the view restricts to CONSOLIDATED_YN = 'N', results may differ from a query directly on the lookup table when consolidated quotes are present. Consumers requiring all quote types, regardless of consolidation status, should query FND_LOOKUPS for LOOKUP_TYPE = 'OKL_QUOTE_TYPE' instead. This distinction is a frequent source of confusion when reconciling LOV contents against the underlying quote data in both EBS 12.1.1 and 12.2.2.