Search Results okl_txl_extension_b




Overview
Explore in AI Chat

Overview

The OKL_TXL_EXTENSION_B table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as a lease transaction lines extension table, providing a structured repository for supplementary attributes and details associated with individual lease transaction lines. This table is integral to the transactional data model of the leasing application, enabling the capture of extended information beyond the standard line-level data. Its role is to support complex leasing operations by storing critical vendor and subsidy-related details that are essential for accurate financial tracking, vendor management, and subsidy processing within lease contracts.

Key Information Stored

The table's primary key is the LINE_EXTENSION_ID, which uniquely identifies each extension record. Based on the documented foreign key relationships, the table stores several key pieces of information that link the lease transaction line to other EBS entities. The TEH_ID column establishes a relationship within the extension hierarchy itself. Crucially, the table holds vendor identifiers: the VENDOR_SITE_ID links to a specific supplier site in the AP_SUPPLIER_SITES_ALL table, while the SUBSIDY_VENDOR_ID and ASSET_VENDOR_ID columns link to supplier master records in the AP_SUPPLIERS table. These columns are fundamental for associating lease transaction lines with the correct vendors for subsidy payments and asset procurement.

Common Use Cases and Queries

A primary use case is generating reports or building interfaces that require a consolidated view of lease transaction lines along with their associated vendor details. For instance, a report to audit all subsidy-related transactions would join this table to the core transaction line table and the supplier master. A common query pattern involves fetching vendor information for a specific lease line. The following SQL exemplifies this, joining to the relevant AP tables:

  • SELECT txl.line_id, ext.SUBSIDY_VENDOR_ID, sup.VENDOR_NAME FROM OKL_TXL_EXTENSION_B ext, AP_SUPPLIERS sup, [Core_Transaction_Line_Table] txl WHERE ext.SUBSIDY_VENDOR_ID = sup.VENDOR_ID(+) AND ext.LINE_EXTENSION_ID = txl.LINE_EXTENSION_ID;

This table is also critical during the processing of vendor payments for subsidies or during the asset procurement lifecycle, where the system references the stored vendor IDs to populate payment documents or asset records.

Related Objects

The OKL_TXL_EXTENSION_B table has defined relationships with several key EBS tables, primarily within the Payables and Leasing modules. The documented foreign keys are:

  • AP_SUPPLIER_SITES_ALL: Linked via the VENDOR_SITE_ID column. This joins lease transaction line extensions to the physical or remit-to address of a supplier.
  • AP_SUPPLIERS (Two Relationships): Linked via the SUBSIDY_VENDOR_ID and ASSET_VENDOR_ID columns. These relationships connect the lease line to the master supplier records for the entities providing subsidies and selling the leased asset, respectively.
  • Self-Referential Relationship: The TEH_ID column references the same table (OKL_TXL_EXTENSION_B), indicating a potential hierarchical structure within the extension data itself.

This table is typically a child of a core lease transaction line table (not explicitly named in the metadata) via the LINE_EXTENSION_ID, which serves as the primary key for this extension entity.