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 theQTP_CODEand theCONSOLIDATED_YNcolumns used in the view logic.FND_LOOKUPS(VIEW) — the standard EBS lookup view. Although the view text referencesFND_LOOKUPSdirectly, the documented dependency is recorded against the view form. It filters onLOOKUP_TYPE = 'OKL_QUOTE_TYPE'.FND_GLOBAL(PACKAGE) — the session context package. EBS views that depend onFND_GLOBALtypically rely onFND_GLOBAL.USER_IDorORG_IDfor 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 fromOKL_TRX_QUOTES_B.QTP_CODE. This is the internal lookup code identifying the quote type.QUOTE_TYPE_DESCRIPTION— sourced fromFND_LOOKUPS.MEANING. This is the translatable, user-facing description corresponding to the lookup code. Because it derives fromFND_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_TYPElookup.
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.
-
Lookup Type: OKL_QUOTE_TYPE 12.1.1
OKL Quote Type
-
Lookup Type: OKL_QUOTE_TYPE 12.2.2
OKL Quote Type
-
View: OKL_H_AM_QUOTES_UV 12.2.2
APPS.OKL_H_AM_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_TRX_QUOTES_B·Explore OKL module →
-
View: OKL_H_AM_QUOTES_UV 12.1.1
APPS.OKL_H_AM_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_TRX_QUOTES_B·Explore OKL module →
-
APPS.OKL_AM_CREATE_RES_QUOTE_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_B·Explore OKL module →
-
APPS.OKL_AM_CREATE_RES_QUOTE_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_B·Explore OKL module →
-
APPS.OKL_AM_RESTRUCTURE_LINES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_B·Explore OKL module →
-
APPS.OKL_AM_RESTRUCTURE_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_ALL_B·Explore OKL module →
-
APPS.OKL_AM_RESTRUCTURE_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_ALL_B·Explore OKL module →
-
View: OKL_SLA_TRX_INFO_V 12.2.2
Transaction object for user transaction identifiers.
APPS.OKL_SLA_TRX_INFO_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
View: OKL_AM_QUOTE_HEADER_UV 12.1.1
Quote header details
APPS.OKL_AM_QUOTE_HEADER_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_AM_QUOTE_HEADER_UV 12.2.2
Quote header details
APPS.OKL_AM_QUOTE_HEADER_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_SLA_TRX_INFO_V 12.1.1
Transaction object for user transaction identifiers.
APPS.OKL_SLA_TRX_INFO_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
APPS.OKL_AM_RESTRUCTURE_LINES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_B·Explore OKL module →
-
VIEW: APPS.OKL_AM_QUOTES_UV 12.2.2
-
VIEW: APPS.OKL_AM_QUOTES_UV 12.1.1
-
View: OKL_AM_QUOTES_UV 12.1.1
APPS.OKL_AM_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_AM_ASSET_QUOTES_UV 12.2.2
APPS.OKL_AM_ASSET_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_B·Explore OKL module →
-
View: OKL_AM_ASSET_QUOTES_UV 12.1.1
APPS.OKL_AM_ASSET_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_B·Explore OKL module →
-
12.1.1 FND Design Data 12.1.1
-
View: OKL_AM_QUOTES_UV 12.2.2
APPS.OKL_AM_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_PARTIES·Explore OKL module →
-
12.2.2 FND Design Data 12.2.2
-
VIEW: APPS.OKL_AEL_GL_QTE_V 12.1.1
-
VIEW: APPS.OKL_AEL_GL_QTE_V 12.2.2