Results for “okl_inventory_item_name”

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

Overview

The view APPS.OKL_FA_REF_VL is a multilingual (language-resolved) reporting view within the Oracle Lease and Finance Management (OLFM) module of Oracle E-Business Suite. Its FND Design Data identifier is OKL.OKL_FA_REF_VL, and in the 12.x schema it holds a VALID status. The view exposes fixed asset reference information tied to lease contracts, presenting translated descriptive attributes alongside numeric identifiers. Because it is a _VL view, it resolves the language-specific _TL tables against the session's LANGUAGE value, returning each row's description in the appropriate installed language rather than requiring the caller to join the translation table manually.

In practice this view serves as a convenience reporting layer. Consultants and developers searching for the column OKL_FA_TRANSACTION_ID will find it as the first projected column, which makes the view a natural starting point for queries that need to correlate a fixed asset transaction with its contract status, transaction type, inventory organization, and item description without traversing the underlying OLFM extension tables directly.

Underlying Base Objects

The view is not defined directly against base tables but is layered over three documented objects, listed in the dependency metadata as synonyms:

• OKL_EXT_FA_HEADER_SOURCES_TL — the translated header-level source records for fixed asset transactions, supplying contract status and transaction type names.
• OKL_EXT_FA_LINE_SOURCES_B — the base (non-translated) line-level source records, providing the transactional identifiers such as OKL_FA_TRANSACTION_ID and OKL_ASSET_ID.
• OKL_EXT_FA_LINE_SOURCES_TL — the translated line-level source records, contributing the description text (TCL_DESCRIPTION_TRANS).

These OKL_EXT_FA_* objects belong to the OLFM external fixed asset integration area, used when lease transactions are pushed to or reconciled with Oracle Assets. Notably, the ETRM dependency section states that OKL_FA_REF_VL is not referenced by any database object, confirming it is a terminal, read-only presentation object rather than a component of a larger dependency chain.

Key Columns

• OKL_FA_TRANSACTION_ID (NUMBER) — the primary transaction identifier linking a fixed asset reference to its originating OLFM transaction. This is the column most frequently used in joins and lookups.
• LANGUAGE (VARCHAR2(12)) — the language code resolved by the _VL mechanism.
• OKL_ASSET_ID (NUMBER) — the asset identifier associated with the transaction.
• TEHL_CONTRACT_STATUS (VARCHAR2(90)) — the contract status derived from the header source record.
• TEHL_TRANSACTION_TYPE_NAME (VARCHAR2(150)) — the translated transaction type name.
• TELL_INVENTORY_ORG_NAME (VARCHAR2(240)) — the inventory organization name for the line.
• TCL_DESCRIPTION_TRANS (VARCHAR2(1995)) — the translated description text.
• TELL_INVENTORY_ITEM_NAME (VARCHAR2) — the inventory item name associated with the line.

Common Use Cases and Queries

Typical usage includes tracing a fixed asset transaction back to its contract context, validating that asset transfers carry the expected status, and building reconciliation reports between OLFM and Oracle Assets.

Retrieve all references for a specific transaction:

SELECT okl_fa_transaction_id,
       okl_asset_id,
       tehl_contract_status,
       tehl_transaction_type_name,
       tell_inventory_org_name,
       tell_inventory_item_name,
       tcl_description_trans
FROM   apps.okl_fa_ref_vl
WHERE  okl_fa_transaction_id = :p_transaction_id;

List references by contract status:

SELECT okl_fa_transaction_id, okl_asset_id, tehl_contract_status
FROM   apps.okl_fa_ref_vl
WHERE  tehl_contract_status = 'ACTIVE';

Because the view is read-only and unaudited, it should be used strictly for queries; no DML is supported against it.