Results for “okl_fa_ref_vl”

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

Overview

OKL_FA_REF_VL is a translation-enabled (VL suffix) database view owned by the APPS schema within the Oracle Leasing and Finance Management (OKL) module. It is a member of the ETRM (Enterprise Transaction & Reference Model) reference layer introduced to expose leasing data to external consumers, reporting tools, and integration interfaces in Oracle E-Business Suite 12.1.1 and 12.2.2. The view presents a consolidated, denormalized projection of fixed asset (FA) reference information that originates from the OKL external fixed asset source tables.

Functionally, OKL_FA_REF_VL surfaces the linkage between a leasing contract transaction and the fixed asset record it generates or references. This is significant because asset tracking in OKL spans both the leasing subledger and the Oracle Assets (FA) module. The view acts as a stable read-only access point that shields callers from the underlying base-table joins and provides language-aware translations via the _TL source tables. For users searching on okl_asset_id, this view is the primary vehicle that exposes the asset identifier alongside its parent contract context.

Underlying Base Objects

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

• OKL_EXT_FA_LINE_SOURCES_B — the base table holding fixed asset line-level extension data, including FA_TRANSACTION_ID, ASSET_ID, LINE_EXTENSION_ID, and HEADER_EXTENSION_ID.
• OKL_EXT_FA_LINE_SOURCES_TL — the translatable line-level table supplying language-specific attributes such as INVENTORY_ORG_NAME and TRANS_LINE_DESCRIPTION.
• OKL_EXT_FA_HEADER_SOURCES_TL — the translatable header-level table supplying CONTRACT_STATUS and TRANSACTION_TYPE_NAME.

The joins are established on LINE_EXTENSION_ID (linking B to TL line records) and HEADER_EXTENSION_ID (linking to the TL header records), with an additional language-equality predicate (FXLL.LANGUAGE = FXHL.LANGUAGE) ensuring the line and header translations are returned in the same language. The view itself carries no physical storage; each query resolves against the three source objects at runtime.

Key Columns

• OKL_FA_TRANSACTION_ID — sourced from FXL.FA_TRANSACTION_ID; the fixed asset transaction identifier.
• LANGUAGE — the session/row language governing which translated values are returned.
• OKL_ASSET_ID — sourced from FXL.ASSET_ID; the fixed asset identifier that the search term okl_asset_id targets. This is the key column correlating a lease transaction with an Oracle Assets asset record.
• OKL_CONTRACT_STATUS — the contract status at the header level, translated.
• OKL_TRANSACTION_TYPE_NAME — the descriptive name of the fixed asset transaction type.
• OKL_INVENTORY_ORG_NAME — the inventory organization name associated with the asset line.
• OKL_TRANS_LINE_DESCRIPTION — the descriptive text for the transaction line.
• OKL_INVENTORY_ITEM_NAME — exposed as NULL in the view text, retained for structural completeness.

Common Use Cases and Queries

Typical usage includes reporting on which fixed assets were generated per lease contract, reconciling OKL asset creation against Oracle Assets, and driving downstream integrations that require language-resolved descriptions. A generic query filtering by asset follows:

• SELECT okl_fa_transaction_id, okl_asset_id, okl_contract_status, okl_transaction_type_name FROM okl_fa_ref_vl WHERE okl_asset_id = :p_asset_id;
• SELECT okl_asset_id, okl_inventory_org_name, okl_trans_line_description FROM okl_fa_ref_vl WHERE language = USERENV('LANG');
• SELECT okl_transaction_type_name, COUNT(*) FROM okl_fa_ref_vl GROUP BY okl_transaction_type_name;

Because the view is read-only and translation-aware, it is well suited for concurrent-program extracts, OAF/ADF reporting regions, and BI Publisher data templates without exposing base-table complexity.