Search Results okl_trx_quotes_all_b




Overview
Explore in AI Chat

Overview

The OKL_TRX_QUOTES_ALL_B table is a core transactional entity within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary repository for all quotes generated for significant contract lifecycle events, namely terminations, restructures, and repurchases. This table is fundamental to the quoting engine, capturing the financial and contractual terms proposed for modifying an existing lease or finance agreement. Its role is to act as the central source of truth for a quote throughout its lifecycle, from creation through approval and eventual implementation, interfacing with downstream processes like contract creation and invoicing.

Key Information Stored

The table stores the essential attributes that define a quote. The primary identifier is the ID column, which is the system-generated primary key. A critical business identifier is the unique QUOTE_NUMBER, which provides a human-readable reference. The table links the quote to the originating contract via the KHR_ID foreign key to the OKL_K_HEADERS table. It also references the specific product (PDT_ID to OKL_PRODUCTS) and asset (ART_ID to OKL_TRX_QUOTES_ALL_B, a self-reference) involved. A notable structural feature is the CONSOLIDATED_QTE_ID column, which allows for a self-referential relationship, enabling the grouping of multiple related quotes into a consolidated parent quote for complex transactions.

Common Use Cases and Queries

This table is central to reporting and data validation for quote management. Common operational queries include retrieving all quotes for a specific contract to review its modification history, or finding quotes of a particular type (e.g., termination) within a date range for month-end processing. A typical reporting query might join to the contract header and product tables to provide a comprehensive view.

  • Sample Query: SELECT q.QUOTE_NUMBER, q.ID, k.CONTRACT_NUMBER, p.NAME PRODUCT_NAME FROM OKL_TRX_QUOTES_ALL_B q, OKL_K_HEADERS k, OKL_PRODUCTS p WHERE q.KHR_ID = k.ID AND q.PDT_ID = p.ID AND q.KHR_ID = :contract_id ORDER BY q.ID;
  • Use Cases: Generating audit trails of quote activity, feeding data into custom termination or restructuring reports, and providing source data for interfaces to downstream financial systems.

Related Objects

The OKL_TRX_QUOTES_ALL_B table is a central hub with extensive relationships to other key OKL transactional entities, as documented by its foreign key constraints.