Search Results okl_quick_quote_lines_b




Overview
Explore in AI Chat

Overview

OKL_QUICK_QUOTE_LINES_B is a base table in the OKL (Leasing and Finance Management) schema of Oracle E-Business Suite, holding the individual line records that make up a quick quote. Quick quotes are lightweight, pre-contract pricing constructs used within Oracle Lease and Finance Management to model pricing scenarios, lease rate factors, and cost structures before a full lease or loan contract is created. Each row in this table represents a single pricing line — for example, a basis, a value, an end-of-term adjustment, or a cost allocation — attached to a parent quick quote header.

The table is classified in the documented physical schema with a primary key named OKL_QQL_PK on the ID column. The ETRM metadata lists the object as VALID and part of the OKL product module. Under the heuristic Data Vault classification mined from the foreign key structure, the object is treated as standalone. As a modeling suggestion, this implies the table behaves primarily as a satellite-like record dependent on its parent quick quote, rather than acting as an independent hub or a resolving link. Analysts should therefore treat OKL_QUICK_QUOTE_LINES_B as a detail-level extension of the quick quote header, not as a standalone reference entity.

Key Information Stored

The table contains 33 documented columns. The most operationally significant are:

  • ID — the surrogate primary key defined by the OKL_QQL_PK constraint; system-generated and not a business key.
  • QUICK_QUOTE_ID — the foreign reference to the parent quick quote header row; this is the principal join path linking lines to their quote.
  • TYPE — classifies the line (for example, the nature of the pricing or cost element).
  • BASIS — defines the calculation basis on which the line value is derived.
  • VALUE — the numeric value associated with the line's basis and type.
  • PERCENTAGE_OF_TOTAL_COST — expresses the line's share of the overall quote cost.
  • END_OF_TERM_VALUE and END_OF_TERM_VALUE_DEFAULT — capture the residual or terminal value and its default setting.
  • LEASE_RATE_FACTOR — the rate factor used in lease pricing calculations.
  • ITEM_CATEGORY_ID and ITEM_CATEGORY_SET_ID — identify the item category and its set, supporting category-driven pricing or cost allocation.
  • OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent updates.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield columns for extensible, customer-defined attributes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit ("WHO") columns tracking record creation and modification.

No additional unique business-key index is documented beyond the primary key, so ID remains the only documented unique identifier; QUICK_QUOTE_ID plus line characteristics serve as the practical logical key in queries.

Common Use Cases and Queries

Typical use cases include retrieving all lines for a given quick quote, reporting pricing components and end-of-term values, and reconciling cost allocations across a quote. A representative query joining lines to their parent quote is:

  • SELECT l.id, l.quick_quote_id, l.type, l.basis, l.value, l.lease_rate_factor FROM okl.okl_quick_quote_lines_b l WHERE l.quick_quote_id = :p_quick_quote_id;
  • Aggregating cost share: SELECT quick_quote_id, SUM(percentage_of_total_cost) FROM okl.okl_quick_quote_lines_b GROUP BY quick_quote_id;
  • Filtering by category: SELECT * FROM okl.okl_quick_quote_lines_b WHERE item_category_id = :p_category_id;

Because the table uses descriptive flexfields, any reporting that surfaces customer-specific attributes must join to the flexfield definition sources to interpret ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 correctly.

Related Objects

The documented relationship data classifies this object as standalone, and only the primary key OKL_QQL_PK is formally recorded. The most significant related objects, based on the column semantics, are:

  • OKL_QUICK_QUOTE_HEADERS (or equivalent quick quote header table) — joined via QUICK_QUOTE_ID to obtain quote-level context; the natural parent of every line.
  • OKL_QUICK_QUOTE_LINES_TL — the translation table companion, where multilingual line text is stored, joined via ID.
  • OKL_ITEM_CATEGORIES / category reference tables — joined via ITEM_CATEGORY_ID and ITEM_CATEGORY_SET_ID.
  • OKL lease pricing and rate factor tables — related through LEASE_RATE_FACTOR for pricing derivation.
  • FND descriptive flexfield metadata — referenced by ATTRIBUTE_CATEGORY and ATTRIBUTE1–15.

Direct foreign keys beyond QUICK_QUOTE_ID were not enumerated in the supplied metadata; analysts should confirm any additional FK constraints against the deployed dictionary before relying on implicit join assumptions.