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:

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:

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.