Results for “primary_quote”
48 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_LEASE_QUOTES_B is the Lease Quote header table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the header-level records for Lease Quotes, which are also referred to as Sales Quotes in Oracle Lease Management (OLM) documentation. Each row represents a single quote created within the context of either a Lease Opportunity or a Lease Application, capturing the commercial terms, pricing parameters, and lifecycle status of the proposed lease arrangement before it is converted into a formal contract.
The table is owned by the OKL schema and holds 74 documented columns in the 12.2.2 physical schema. Its primary key is OKL_LSQ_PK, defined on the ID column, with a secondary unique constraint OKL_LSQ_UK1 on REFERENCE_NUMBER. From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is standalone, suggesting this object functions primarily as a hub-like entity for the lease quote business key, with descriptive attributes carried directly on the table rather than split into separate satellites.
Key Information Stored
The most significant columns in OKL_LEASE_QUOTES_B fall into several functional groups:
- ID – Surrogate primary key (OKL_LSQ_PK) uniquely identifying each lease quote header.
- REFERENCE_NUMBER – Business-key candidate enforced by unique index OKL_LSQ_UK1; the user-facing quote number.
- STATUS – Lifecycle state of the quote (e.g., draft, submitted, approved, converted).
- PARENT_OBJECT_CODE / PARENT_OBJECT_ID – Polymorphic reference identifying the originating Lease Opportunity or Lease Application.
- CUSTOMER_BOOKCLASS / CUSTOMER_TAXOWNER – Customer classification attributes affecting accounting and tax treatment.
- EXPECTED_START_DATE, EXPECTED_FUNDING_DATE, EXPECTED_DELIVERY_DATE – Anticipated milestone dates for the lease.
- PRICING_METHOD, TERM, LEASE_RATE_FACTOR, TARGET_RATE, TARGET_AMOUNT – Core commercial pricing parameters.
- IIR, BOOKING_YIELD, PIRR, AIRR, SUB_IIR, SUB_BOOKING_YIELD, SUB_PIRR, SUB_AIRR – Yield and internal-rate-of-return metrics at quote and sub-quote level.
- PRODUCT_ID – Foreign key to FND_DM_PRODUCTS identifying the financed product.
- LEGAL_ENTITY_ID – Foreign key to FV_LEGAL_ENTITIES identifying the contracting legal entity.
- PRIMARY_QUOTE – Flag indicating whether this is the primary quote among alternatives.
- VALID_FROM / VALID_TO – Effective dating of the quote record.
Common Use Cases and Queries
Typical reporting and integration scenarios include retrieving all quotes associated with a given opportunity or application, extracting pricing terms for rate-card analysis, and tracing quotes to downstream contracts. A common pattern retrieves header details by business key:
SELECT q.ID, q.REFERENCE_NUMBER, q.STATUS, q.TERM, q.TARGET_RATE
FROM OKL.OKL_LEASE_QUOTES_B q
WHERE q.REFERENCE_NUMBER = :ref_num;
Quotes by parent object and product can be listed via joins to FND_DM_PRODUCTS and FV_LEGAL_ENTITIES on the documented foreign keys. Because the table carries standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE), audit and change-tracking extracts are also straightforward, and the ATTRIBUTE1–15 flexfield columns support customer-specific extensions.
Related Objects
The most significant related objects include:
- FND_DM_PRODUCTS – referenced via OKL_LEASE_QUOTES_B.PRODUCT_ID; identifies the financed product.
- FV_LEGAL_ENTITIES – referenced via OKL_LEASE_QUOTES_B.LEGAL_ENTITY_ID; identifies the contracting legal entity.
- OKL_LEASE_QUOTES_TL – translation table for quote descriptive fields.
- OKL_LEASE_QUOTE_LINES – line-level detail belonging to each quote header (keyed by quote ID).
- OKL_LEASE_OPPORTUNITIES / OKL_LEASE_APPLICATIONS – parent objects referenced generically by PARENT_OBJECT_CODE and PARENT_OBJECT_ID.
- OKL_RATE_TEMPLATES / OKL_RATE_CARDS – referenced via RATE_TEMPLATE_ID and RATE_CARD_ID for pricing derivation.
- OKL_CONTRACTS / OKL_K_HEADERS – downstream lease contract headers generated upon quote conversion.
Together these relationships position OKL_LEASE_QUOTES_B as the central header entity connecting opportunity-driven and application-driven quote workflows to downstream contract and pricing components.
-
OKL_LEASE_QUOTES_B is the Lease Quote header table. Lease Quotes (also known as Sales Quotes in OLM documentation) created within the context of either a Lease Opportunity or a Lease Application.
-
View: OKL_LEASE_QUOTES_V 12.2.2
View for okl_lease_quotes_b and okl_lease_quotes_tl
APPS.OKL_LEASE_QUOTES_V·↳ OKL_LEASE_QUOTES_B·↳ OKL_LEASE_QUOTES_TL·Explore OKL module →
-
View: OKL_LEASE_QUOTES_V 12.1.1
View for okl_lease_quotes_b and okl_lease_quotes_tl
APPS.OKL_LEASE_QUOTES_V·↳ OKL_LEASE_QUOTES_B·↳ OKL_LEASE_QUOTES_TL·Explore OKL module →
-
OKL_LEASE_QUOTES_B is the Lease Quote header table. Lease Quotes (also known as Sales Quotes in OLM documentation) created within the context of either a Lease Opportunity or a Lease Application.
-
PACKAGE: APPS.OKL_LSQ_PVT 12.1.1
-
PACKAGE: APPS.OKL_LSQ_PVT 12.2.2
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.2.2
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards