Search Results okl_txl_quote_lines_b

Overview

The table OKL_TXL_QUOTE_LINES_B is a core data object within the Oracle E-Business Suite (EBS) module OKL (Leasing and Finance Management). It serves as the primary repository for line-level detail associated with quotes generated for key transactional events: asset termination, contract restructure, or asset repurchase. Each record in this table represents a specific financial component or adjustment line that collectively forms the complete commercial offer (quote) to a customer for one of these events. Its role is critical for capturing the granular financial breakdown, which feeds into downstream contract modifications, journal entries, and settlement calculations in the leasing lifecycle.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships define the essential contextual data stored in each record. The primary identifier is the ID column, which is the table's primary key. Each line must be associated with a parent quote header via the QTE_ID, linking to OKL_TRX_QUOTES_B. The financial substance of the line is tied to a source contract line via KLE_ID, referencing the OKL_K_LINES table. For restructuring scenarios, a SPLIT_KLE_ID may also reference OKL_K_LINES to denote a new or split contract line. The line's transaction type (TRY_ID referencing OKL_TRX_TYPES_B) and revenue/expense stream type (STY_ID referencing OKL_STRM_TYPE_B) are stored to classify the nature of the charge or credit, such as a termination penalty, unearned interest reversal, or asset repurchase price.

Common Use Cases and Queries

This table is central to generating and analyzing quotes for lease-end or mid-lease transactions. A common operational use case is retrieving all quote lines for a specific customer quote to display in a review screen or to calculate the total quote amount. For reporting, analysts may query this table to summarize volumes and values of termination or restructuring activity by stream type or contract line category. A typical SQL pattern involves joining to the quote header and contract lines to provide context.

SELECT qtl.id, qtl.qte_id, qh.quote_number, kl.line_number,
       tt.name transaction_type, st.name stream_type
FROM okl_txl_quote_lines_b qtl,
     okl_trx_quotes_b qh,
     okl_k_lines kl,
     okl_trx_types_b tt,
     okl_strm_type_b st
WHERE qtl.qte_id = qh.id
AND qtl.kle_id = kl.id
AND qtl.try_id = tt.id
AND qtl.sty_id = st.id
AND qh.quote_status = 'APPROVED';

Related Objects

The table maintains defined foreign key relationships with several key OKL tables, as documented in the ETRM metadata:

• OKL_TRX_QUOTES_B: The parent quote header. Joined via OKL_TXL_QUOTE_LINES_B.QTE_ID = OKL_TRX_QUOTES_B.ID.
• OKL_K_LINES (two relationships): The original contract line item. Joined via OKL_TXL_QUOTE_LINES_B.KLE_ID = OKL_K_LINES.ID. For restructuring, a separate relationship exists via OKL_TXL_QUOTE_LINES_B.SPLIT_KLE_ID = OKL_K_LINES.ID.
• OKL_TRX_TYPES_B: Defines the transaction type (e.g., TERMINATION, RESTRUCTURE). Joined via OKL_TXL_QUOTE_LINES_B.TRY_ID = OKL_TRX_TYPES_B.ID.
• OKL_STRM_TYPE_B: Defines the accounting stream type (e.g., INTEREST, PRINCIPAL, FEE). Joined via OKL_TXL_QUOTE_LINES_B.STY_ID = OKL_STRM_TYPE_B.ID.