Search Results okl_ext_ap_line_sources_b




Overview
Explore in AI Chat

Overview

The table OKL_OKL_EXT_AP_LINE_SOURCES_B is a core extension table within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as a detailed repository for line-level information that extends standard Oracle Payables (AP) transaction data. Its primary role is to capture and maintain the specific leasing and financial attributes associated with individual invoice lines, linking them to the broader leasing contract structures managed within OKL. This table is essential for integrating procurement and payables processes with complex lease accounting and asset management workflows, ensuring financial data integrity across modules.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which dictate the critical data it holds. The primary identifier is the LINE_EXTENSION_ID. The most significant columns are foreign keys that establish essential relationships: HEADER_EXTENSION_ID links the line to its parent extension record in OKL_EXT_AP_HEADER_SOURCES_B. The KLE_ID column is a crucial link to the contract line in the OKC_K_LINES_B table, connecting the payable item directly to a specific line of a leasing contract. The STY_ID column references the stream type (OKL_STRM_TYPE_B), classifying the nature of the payment stream (e.g., rent, maintenance). Finally, the ASSET_VENDOR_ID links to the AP_SUPPLIERS table, identifying the vendor associated with the leased asset or service.

Common Use Cases and Queries

This table is central to reporting and reconciliation tasks between Payables and Leasing. A common use case is tracing payables invoice lines back to their originating lease contract lines for audit purposes or to validate payment terms. Another scenario involves generating reports on vendor payments categorized by lease stream type. A typical analytical query would join this table to contract and supplier information:

  • SELECT lns.kle_id, lns.sty_id, sup.vendor_name, hdr.invoice_id FROM okl_ext_ap_line_sources_b lns JOIN okl_ext_ap_header_sources_b hdr ON lns.header_extension_id = hdr.header_extension_id JOIN ap_suppliers sup ON lns.asset_vendor_id = sup.vendor_id WHERE hdr.invoice_date BETWEEN :p_start_date AND :p_end_date;

Data in this table is primarily created and maintained by the application's internal APIs and integration flows when payables invoices are interfaced or created in conjunction with lease contracts.

Related Objects

OKL_EXT_AP_LINE_SOURCES_B is a child table with defined foreign key relationships to several key EBS objects, as documented in the ETRM metadata:

  • OKL_EXT_AP_HEADER_SOURCES_B: Joined via HEADER_EXTENSION_ID. This is the parent header extension table for the payables transaction.
  • OKC_K_LINES_B: Joined via KLE_ID. This links the payable line to the specific contract line in the Contracts Core module.
  • OKL_STRM_TYPE_B: Joined via STY_ID. This provides the stream type classification for the payment.
  • AP_SUPPLIERS: Joined via ASSET_VENDOR_ID. This provides the vendor details for the asset or service being invoiced.

The primary key constraint OKL_EXT_AP_LINE_SOURCES_B_PK on LINE_EXTENSION_ID ensures uniqueness for each record in this table.