Search Results okl_trx_quotes_b




Overview
Explore in AI Chat

Overview

The OKL_TRX_QUOTES_B table is a core data object within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It serves as the primary transactional repository for generating and storing quotes associated with major contract lifecycle events, specifically terminations, restructures, and repurchases. This table is fundamental to managing the financial and contractual renegotiation processes for lease and finance agreements. Each record represents a formal quote proposal that can be reviewed, adjusted, and ultimately accepted to create a new or modified contractual obligation, facilitating complex asset and financial restructuring within the application.

Key Information Stored

While the provided metadata does not list all columns, the defined keys reveal critical data relationships. The primary identifier is the ID column. A unique key on QUOTE_NUMBER ensures a business-friendly identifier for each quote. The table's foreign keys are essential for contextualizing the quote: the KHR_ID links the quote to its originating contract in the OKL_K_HEADERS table. The PDT_ID associates the quote with a specific product definition from OKL_PRODUCTS. For asset returns, the ART_ID connects to the OKL_ASSET_RETURNS_B table. The CONSOLIDATED_QTE_ID is a self-referencing foreign key, indicating the table's capability to support consolidated or parent-child quote hierarchies, which is common in complex restructuring scenarios.

Common Use Cases and Queries

The primary use case is the generation and tracking of quotes for contract modifications. A typical operational query would retrieve all active quotes for a specific contract to support decision-making. For reporting, a common pattern is to join the quote header to its detailed lines and the original contract to analyze quote volumes, values, and statuses.

  • Sample Query (Fetching Quotes for a Contract):
    SELECT qte.quote_number, qte.id, khr.contract_number
    FROM okl_trx_quotes_b qte,
    okl_k_headers khr
    WHERE qte.khr_id = khr.id
    AND khr.contract_number = '<CONTRACT_NUM>';
  • Reporting Use Case: Generating a list of all termination quotes created within a date range, including the associated contract and product details, for financial analysis and audit trails.

Related Objects

The OKL_TRX_QUOTES_B table is a central hub with several key dependencies, as shown by its foreign key relationships. It is the parent table for detailed line items stored in OKL_TXL_QUOTE_LINES_B. Upon quote acceptance, it seeds downstream transactional documents; the OKL_TRX_CONTRACTS table references the quote to create a new contract version, and the OKL_TRX_AP_INVOICES_B table may reference it for payable items. The OKL_TERMNT_INTERFACE link suggests integration points for termination processing. Furthermore, the self-referencing CONSOLIDATED_QTE_ID indicates that quotes can be related to each other, supporting complex multi-quote transactions.