Search Results okl_txd_assets_v




Overview
Explore in AI Chat

Overview

OKL_TXD_ASSETS_V is a concurrent-programmable, translation-aware view owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment. It belongs to the OKL product family, Oracle Leasing and Finance Management, which manages lease contracts, asset funding, and the downstream creation of fixed assets. The view exposes tax-book asset attributes that must be recorded before a contract is activated and before the associated asset records are pushed into the Oracle Assets (FA) module. In addition, it stores split-asset transaction attributes required when a single leased asset is allocated across multiple fixed assets.

Functionally, OKL_TXD_ASSETS_V acts as a reporting and integration surface over the OKL tax-book asset transaction data. It shields the underlying base and translation tables from external consumers, presents a single denormalized row per asset line, and resolves the language-specific descriptive text through the translation table. Because it is defined with a language bind based on USERENV('LANG'), the view returns the description appropriate to the session language, which makes it suitable for both EBS forms-based inquiry and custom SQL reporting.

Underlying Base Objects

The documented metadata identifies two referenced base objects, exposed to the view as synonyms in the APPS schema:

  • OKL_TXD_ASSETS_B — the base table holding the non-translatable, transactional columns of the tax-book asset record, including identifiers, quantities, cost, depreciation attributes, split percentage, currency information, and the descriptive flexfield (attribute1 through attribute15).
  • OKL_TXD_ASSETS_TL — the translation table holding language-dependent descriptions, joined to the base table on the common ID column and filtered by the session language.

The view definition joins the two tables with ASDB.ID = ASDTL.ID AND ASDTL.LANGUAGE = USERENV('LANG'), ensuring exactly one translated row per base record for the active language. It also propagates the ROWID of the base table as ROW_ID, enabling updatable or row-identifying access patterns from client tooling such as Oracle Forms.

The view status is VALID, and its structure corresponds to Release 12.2.2 ETRM documentation; the same definition applies to 12.1.1.

Key Columns

Common Use Cases and Queries

Typical uses include pre-activation validation of tax-book attributes, reconciliation of asset records pushed to Oracle Assets, and reporting on split-asset allocations. A representative query retrieves all active tax-book asset lines for a contract:

SELECT tal_id, asset_number, description, quantity,
       cost, tax_book, deprn_method_tax, split_percent
FROM   apps.okl_txd_assets_v
WHERE  tal_id = :p_tal_id
ORDER  BY line_detail_number;

For currency validation, filter on conversion attributes where a rate is expected but missing:

SELECT id, asset_number, currency_code
FROM   apps.okl_txd_assets_v
WHERE  currency_code IS NOT NULL
AND    currency_conversion_rate IS NULL;

Because the view resolves DESCRIPTION through OKL_TXD_ASSETS_TL using the session language, reporting tools must set the language context appropriately to receive the intended translation.