Search Results deprn_method_tax




Overview
Explore in AI Chat

Overview

The view OKL_LA_ASST_TAX_DEPRN_UV is an Oracle E-Business Suite database object owned by the APPS schema within the OKL (Leasing and Finance Management) product family. Per the ETRM metadata, its documented purpose is to serve as the user interface view for the tax book depreciation page. The suffix _UV denotes a "user view," a naming convention Oracle applies to views built specifically to back an OAF (Oracle Application Framework) page or an equivalent UI region. Rather than exposing every column of the underlying transaction tables, the view projects a focused, presentation-ready column set that maps directly to fields rendered on the tax book depreciation page.

Because it is a view and not a table, it holds no data of its own; it is a read-only projection over the tax asset base and translation tables. This makes it relevant to reporting and integration work in both EBS 12.1.1 and 12.2.2, where the OKL schema is largely unchanged. Technical consultants frequently identify this view when tracing the source of tax depreciation attributes displayed on the leasing asset pages, or when building custom extracts that mirror the page layout.

Underlying Base Objects

The documented view text references two base objects, both exposed in the data dictionary as synonyms:

  • OKL_TXD_ASSETS_B — the base ("_B") table holding tax asset records, joined here as ASDB.
  • OKL_TXD_ASSETS_TL — the translation ("_TL") table providing language-specific descriptive text, joined here as ASDTL.

The join predicate is ASDB.ID = ASDTL.ID combined with ASDTL.LANGUAGE = USERENV('LANG'), the standard EBS pattern that returns descriptions in the session's current language. The association is therefore one row per tax asset record, enriched with the translated description. No outer joins or aggregations appear in the documented view text.

Key Columns

The view exposes eleven columns. The most operationally significant include:

  • ID — primary identifier of the tax asset record; correlates to the base table key.
  • TAL_ID — link to the associated leasing asset (TAL) record, connecting tax data to the lease asset context.
  • ASSET_NUMBER — the tax asset number used for identification.
  • DESCRIPTION — translated description sourced from OKL_TXD_ASSETS_TL.
  • QUANTITY and COST — quantity of the asset and its cost; cost is explicitly cast with TO_CHAR.
  • TAX_BOOK — the tax book to which the depreciation record belongs.
  • LIFE_IN_MONTHS_TAX — the tax life in months, wrapped in NVL(TO_CHAR(...), '') so NULLs render as empty strings.
  • DEPRN_METHOD_TAX — the tax depreciation method; this is the column surfaced for the user search term "deprn_method_tax."
  • DEPRN_RATE_TAX — the tax depreciation rate, multiplied by 100 (as a percentage) and similarly NVL-guarded.

The character conversion and NVL wrapping indicate the view is tuned for direct UI binding rather than set-based computation.

Common Use Cases and Queries

Typical uses include reconciling the tax depreciation page against stored data, auditing tax books, and populating custom reports. A representative query follows:

  • List tax depreciation methods per asset:
    SELECT tal_id, asset_number, tax_book, deprn_method_tax, deprn_rate_tax, life_in_months_tax FROM apps.okl_la_asst_tax_deprn_uv ORDER BY asset_number;
  • Filter by tax book: add WHERE tax_book = :p_book to isolate one book.
  • Join to lease assets: join TAL_ID to the TAL asset table to blend tax and lease-book attributes.

Because the view applies USERENV('LANG'), callers should run it within a session whose language is set appropriately to obtain the expected description. In 12.2.2 the object remains VALID and unchanged in structure relative to the documented 12.1.1 behavior.