Search Results okl_k_lines

Overview

The OKL_K_LINES table is a core data object within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. It functions as a shadow table to the Oracle Contracts Core (OKC) line tables, OKC_K_LINES_B and OKC_K_LINES_TL. Its primary role is to extend the standard contract line functionality by storing attributes unique to lease and finance contracts that are not accommodated by the generic Contracts Core data model. This design allows the OKL module to leverage the foundational contract engine while maintaining specialized data for complex leasing transactions, asset management, and financial calculations.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's description and foreign key relationships define its critical purpose. The table's primary key is the ID column, which serves as the foreign key to the base contract line table (OKC_K_LINES_B.ID), establishing a one-to-one relationship with the core contract line. Other significant columns are inferred from the foreign key relationships, such as CLG_ID for linking to other lines within the same structure, and SUBSIDY_ID for associating subsidy information. Fundamentally, the table holds line-level attributes critical to lease accounting, including data for insurance policies, asset conditions, returns, tax calculations, payment streams, and portfolio management, which are not relevant to standard sales or service contracts.

Common Use Cases and Queries

This table is central to any process requiring lease-specific line details. Common use cases include generating asset schedules, calculating lease-specific tax or subsidy amounts, managing insurance tracking at the asset level, and supporting portfolio valuation reporting. A fundamental query pattern involves joining OKL_K_LINES to the core contract lines to retrieve a complete view of a lease line.

SELECT okl.*, okc.object_version_number, okc.sts_code
FROM OKL_K_LINES okl,
OKC_K_LINES_B okc
WHERE okl.id = okc.id
AND okc.dnz_chr_id = :p_contract_id;

Another common scenario is querying lines associated with a specific financial stream or asset condition for reporting purposes, leveraging the numerous foreign key references from tables like OKL_STREAMS or OKL_ASSET_CNDTNS.

Related Objects

The OKL_K_LINES table has extensive integration within the OKL module, as evidenced by its foreign key relationships. Key related objects include:

• OKC_K_LINES_B: The core contract line table, joined on ID.
• OKL_STREAMS: For payment stream data linked to a line (KLE_ID).
• OKL_INS_POLICIES_ALL_B: For insurance policy details (KLE_ID).
• OKL_ASSET_CNDTNS_ALL: For asset condition records (KLE_ID).
• OKL_TXL_ASSETS_B: For tax asset information (KLE_ID).
• OKL_SUBSIDIES_ALL_B: For subsidy agreements (SUBSIDY_ID).
• OKL_PRTFL_LINES_B: For portfolio management line details (KLE_ID).
• OKL_TXL_AR_INV_LNS_B / OKL_TXL_AP_INV_LNS_B: For accounts receivable and payable invoice lines (KLE_ID).

These relationships illustrate that OKL_K_LINES acts as a central hub connecting lease contract lines to nearly all specialized leasing sub-processes.