Search Results okl_k_headers_v




Overview
Explore in AI Chat

Overview

OKL_K_HEADERS_V is an APPS-owned view in the Oracle Leasing and Finance Management (OKL) module, exposed in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the Oracle Lease Management shadow header view, presenting descriptive and financial attributes that belong to lease and finance contracts created in OKL but that do not fit within the standard Oracle Contracts Core header tables, OKC_K_HEADERS_B and OKC_K_HEADERS_TL. The view therefore bridges the OKL contract extension data with the Contracts Core model, giving both reporting and integration layers a single, denormalized read surface for lease-specific header information.

Because the view carries the OKL-specific attribute set, it is the primary reference for consumers that need to read leasing financial parameters — such as yield figures and implicit interest rates — alongside standard contract identity and audit columns. ETRM lists the view as VALID with APPS as owner and OKL_K_HEADERS (SYNONYM) as the referenced base object. The user search term implicit_non_idc_interest_rate maps directly to a column exposed by this view, which is why it surfaces as the relevant object for that lookup.

Underlying Base Objects

Per the documented view text, OKL_K_HEADERS_V is defined as a direct projection over the OKL_K_HEADERS shadow table, filtered through the synonym listed in the ETRM metadata. The view selects KHR.ROWID as ROW_ID together with every relevant column of OKL_K_HEADERS, including the surrogate identifiers ID, KHR_ID, PDT_ID, and ISG_ID, the object version number, and the standard WHO audit trail columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN). No joins, unions, or filters are applied; the view is effectively a column-aliasing layer that preserves the shadow table structure while presenting a stable attribute name for each field.

OKL_K_HEADERS itself extends OKC_K_HEADERS_B and OKC_K_HEADERS_TL, so an OKL lease contract is simultaneously represented in the Contracts Core header tables and supplemented here. ROW_ID is carried forward to support updatable or row-identified access patterns, and the descriptor flexfield columns ATTRIBUTE_CATEGORY through ATTRIBUTE15 preserve the DFF context for the lease header.

Key Columns

The view exposes a compact but functionally important column set. The most relevant columns include:

Common Use Cases and Queries

The view is typically queried to reconcile lease accounting rates, report yield data, or extract leasing header attributes for downstream warehousing. A first common pattern is isolating contracts by their implicit rate, which directly answers the searched term:

SELECT id, khr_id, implicit_interest_rate, implicit_non_idc_interest_rate, pre_tax_yield, after_tax_yield FROM apps.okl_k_headers_v WHERE implicit_non_idc_interest_rate IS NOT NULL;

A second pattern retrieves active contracts whose accrual generation has been overridden, useful in accounting control reviews:

SELECT id, khr_id, generate_accrual_yn, generate_accrual_override_yn, term_duration FROM apps.okl_k_headers_v WHERE generate_accrual_override_yn = 'Y';

A third pattern supports yield and pricing analysis by ordering lease headers on pre-tax yield, while a fourth extracts the audit trail and flexfield context for integration or data-quality checks:

SELECT id, khr_id, pre_tax_yield, after_tax_yield, last_updated_by, last_update_date FROM apps.okl_k_headers_v ORDER BY pre_tax_yield DESC;

Because the view maps one-to-one to OKL_K_HEADERS, joins to OKC_K_HEADERS_B or OKC_K_HEADERS_TL on the contract identifier are required whenever standard Contracts Core columns such as contract number or title are needed alongside these lease-specific attributes.