Results for “okl_fa_dep_ref_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_FA_DEP_REF_VL is a translatable, language-aware database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It resides in the OKL (Leasing and Finance Management) product family and serves as a reporting and integration interface that exposes depreciation reference data linking Oracle Leasing contracts to Oracle Assets fixed asset depreciation records. The view is specifically filtered to the FA_DEPRN_SUMMARY source table, which is the Oracle Assets table storing periodic depreciation amounts and depreciation run identifiers for capitalized assets. Because OKL contracts frequently involve leased assets that flow into Oracle Assets, this view provides a denormalized, translated projection of the extension records that map a leasing transaction to its corresponding depreciation summary line.

The _VL suffix denotes a view that joins a base table with its translation (_TL) counterparts, filtering rows to the caller's session language. In this case the view joins two translation tables, ensuring that the contract status and inventory organization descriptions are returned in the appropriate language for the reporting user.

Underlying Base Objects

The view is defined over three documented base objects, all referenced through APPS synonyms:

• OKL_EXT_FA_LINE_SOURCES_B — the base (non-translated) line-level extension table that holds the depreciation and asset identifiers. This is the driving table and supplies the SOURCE_TABLE filter value of FA_DEPRN_SUMMARY.
• OKL_EXT_FA_LINE_SOURCES_TL — the translated line-level table, supplying language-specific descriptive attributes such as the inventory organization name.
• OKL_EXT_FA_HEADER_SOURCES_TL — the translated header-level table, supplying contract-level attributes such as contract status.

The joins are keyed on LINE_EXTENSION_ID (line base to line translation) and HEADER_EXTENSION_ID (line base to header translation), with a further join on matching LANGUAGE columns between the two translation tables so that only rows in a consistent language are returned.

Key Columns

• OKL_DEPRN_RUN_ID — aliased from FXL.FA_TRANSACTION_ID; identifies the Oracle Assets depreciation run / transaction associated with the leasing line.
• OKL_ASSET_ID — aliased from FXL.ASSET_ID; the fixed asset identifier in Oracle Assets.
• OKL_ASSET_BOOK_TYPE_CODE — the asset book type code, identifying which depreciation book the asset belongs to.
• OKL_PERIOD_COUNTER — the depreciation period counter, indicating the accounting period of the depreciation summary record.
• LANGUAGE — the language code from the header translation table, used to filter and align translated descriptions.
• OKL_CONTRACT_STATUS — the translated contract status of the associated leasing contract.
• OKL_INVENTORY_ORG_NAME — the translated inventory organization name associated with the line.

Note that the documented column list shows TEHL_CONTRACT_STATUS and TELL_INVENTORY_ORG_NAME; these correspond to the aliased columns OKL_CONTRACT_STATUS and OKL_INVENTORY_ORG_NAME in the view text.

Common Use Cases and Queries

This view is typically used by OKL-to-Assets reconciliation reports and integration extracts, allowing a leasing contract line to be tied back to the specific asset, book, and depreciation period. A representative query follows:

SELECT okl_deprn_run_id, okl_asset_id, okl_asset_book_type_code,
okl_period_counter, okl_contract_status, okl_inventory_org_name
FROM apps.okl_fa_dep_ref_vl
WHERE okl_asset_id = :p_asset_id;

Because the view already filters on SOURCE_TABLE = 'FA_DEPRN_SUMMARY', consumers do not need to add that predicate themselves; the view returns only depreciation-summary-derived reference rows. It is especially useful when diagnosing whether a leasing contract's depreciation data has been correctly transferred into Oracle Assets for a given period.