Results for “book_name”

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

Overview

The OKL_ASSET_DEPRN_UV view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL - Lease and Finance Management product. Its design purpose is to present, in a single flattened result set, the depreciation-related attributes of fixed assets as they are recorded in Oracle Assets (FA) and consumed by Lease and Finance Management. The "UV" suffix denotes a user-facing view intended for query and reporting rather than for direct DML.

Because lease accounting frequently requires the depreciation profile of an underlying asset to be associated with a contract, this view consolidates asset identity, book assignment, cost, life, salvage, method, and rate information. Its most significant column in the context of depreciation analysis is DEPRECIATION_RATE, which is derived by multiplying the adjusted rate stored on the asset book by 100 and converting the result to a character string. This makes the view a convenient source for users searching on the term "depreciation_rate," since the underlying numeric value resides in FA_BOOKS.ADJUSTED_RATE and is only surfaced here in a pre-scaled, display-ready form.

Underlying Base Objects

The view is defined with a synonym-based join across five Oracle Assets base objects, all referenced under the APPS schema:

• FA_ADDITIONS_B — the base asset definition table, supplying ASSET_ID, ASSET_NUMBER, and ASSET_CATEGORY_ID.
• FA_ADDITIONS_TL — the translated asset description table, joined with LANGUAGE = USERENV('LANG') to return the asset description in the session language.
• FA_BOOKS — the per-book asset assignment table, supplying cost, life in months, in-service date, salvage values, depreciation method code, and the adjusted rate that drives DEPRECIATION_RATE.
• FA_BOOK_CONTROLS — the book definition table, providing BOOK_TYPE_NAME and BOOK_CLASS, and enforcing that only currently effective books are returned via the DATE_INEFFECTIVE predicate.
• FA_CATEGORIES_B — the asset category table, supplying the concatenated DEPRECIATION_CATEGORY_NAME built from SEGMENT1 through SEGMENT7.

The join predicates additionally restrict output to active asset book rows: TRANSACTION_HEADER_ID_OUT must be null, DATE_INEFFECTIVE on the book row must be null, and PERIOD_COUNTER_FULLY_RETIRED must be null, ensuring fully retired assets and reversed transactions are excluded.

Key Columns

• ASSET_ID / ASSET_NUMBER / ASSET_DESCRIPTION — asset identification and the language-specific description.
• BOOK_TYPE_CODE / BOOK_NAME / BOOK_CLASS — the depreciation book identifier, its display name, and its class.
• DEPRECIABLE_COST — the asset cost from FA_BOOKS.COST.
• LIFE_IN_MONTHS — the depreciable life, formatted as character data.
• IN_SERVICE_DATE — the date placed in service.
• DEPRECIATION_CATEGORY_ID / DEPRECIATION_CATEGORY_NAME — the category identifier and the dotted concatenation of the category key flexfield segments.
• SALVAGE_VALUE / PERCENT_SALVAGE_VALUE — either an absolute salvage value or a percentage scaled by 100.
• DEPRECIATION_METHOD — the method code from FA_BOOKS.DEPRN_METHOD_CODE.
• DEPRECIATION_RATE — the adjusted rate multiplied by 100, expressed as a character string, being the column most directly associated with depreciation_rate searches.

Common Use Cases and Queries

Typical scenarios include reconciling lease assets to their depreciation profiles, extracting rates for downstream lease accounting calculations, and validating that asset books are correctly configured before contract processing.

A representative query to retrieve depreciation rate and related attributes for a given book is:

• SELECT asset_number, asset_description, book_type_code, depreciable_cost, depreciation_method, depreciation_rate FROM okl_asset_deprn_uv WHERE book_type_code = :book;
• SELECT asset_id, depreciation_rate, life_in_months, in_service_date FROM okl_asset_deprn_uv WHERE depreciation_rate IS NOT NULL ORDER BY asset_number;
• SELECT depreciation_category_name, COUNT(*) FROM okl_asset_deprn_uv GROUP BY depreciation_category_name;

Note that DEPRECIATION_RATE is a character column and may be empty where ADJUSTED_RATE is null; consumers performing arithmetic should cast and handle the empty string explicitly.