Results for “corporate_book”

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

Overview

OKL_LA_BOOK_DEPRN_UV is an APPS-owned database view in the Oracle Lease and Finance Management (OKL) module. It is documented as the user interface view for the asset book depreciation page, meaning it supplies the denormalized, presentation-ready rowset that the depreciation maintenance screen consumes when displaying asset-book depreciation records. The view is classified with a status of VALID in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2, and the base objects referenced are resolved through APPS synonyms.

Because it is a single view rather than a table, it exposes no independent storage; all values are derived at query time from the lease contract line and transaction asset tables. This makes it suitable both for the form-driven depreciation page and for ad hoc reporting and integration extracts that need the same asset, category, cost, and salvage figures that the UI presents. The PERCENT_SALVAGE_VALUE column, which corresponds to the user search term, is one of the value columns projected by the view.

Underlying Base Objects

The view text joins four documented objects, all resolved through APPS synonyms or views:

• OKL_TXL_ASSETS_B — the primary transaction asset table, aliased TXL. It supplies ID, KLE_ID, DNZ_KHR_ID, ASSET_NUMBER, CORPORATE_BOOK, IN_SERVICE_DATE, LIFE_IN_MONTHS, DEPRECIATION_ID, DEPRECIATION_COST, DEPRN_METHOD, DEPRN_RATE, SALVAGE_VALUE, PERCENT_SALVAGE_VALUE, and FA_COST.
• OKX_ASST_CATGRS_V — the asset category view, aliased CAT. It is joined with an outer join (CAT.ID1(+)) on DEPRECIATION_ID = CAT.ID1 and contributes CATEGORY_ID and CATEGORY_NAME.
• OKC_K_LINES_TL — the contract line translation table, aliased CLT, joined on CLT.ID = TXL.KLE_ID with a language restriction (CLT.LANGUAGE = USERENV('LANG')), providing the translated DESCRIPTION.
• OKC_K_LINES_B — the contract line base table, aliased CLEB, joined on CLEB.ID = CLT.ID, contributing ORIG_SYSTEM_ID1.

All joins are inner joins except the category outer join, so an asset row is returned only when a matching contract line exists in both the base and translated line tables.

Key Columns

• ID, KLE_ID, DNZ_KHR_ID — primary identifiers linking the depreciation row back to the asset and its source record.
• ASSET_NUMBER, DESCRIPTION — asset identification and the contract line's translated description.
• CORPORATE_BOOK, IN_SERVICE_DATE, LIFE_IN_MONTHS — book assignment, capitalization date, and depreciable life in months.
• CATEGORY_ID, CATEGORY_NAME — depreciation category, with the outer join allowing unnamed categories.
• DEPRECIATION_COST, FA_COST, DEPRN_METHOD, DEPRN_RATE — cost basis, fixed-asset cost, method, and rate (rate is multiplied by 100 and left null when absent).
• SALVAGE_VALUE, PERCENT_SALVAGE_VALUE — the residual value and its percentage form, both cast to character; PERCENT_SALVAGE_VALUE is the column most often sought for salvage-related reporting.
• ORIG_SYSTEM_ID1 — the originating system identifier, defaulted to -9999 when null.

Common Use Cases and Queries

Typical uses include reconciling book depreciation against Fixed Assets, auditing salvage percentages by category, and feeding downstream extracts. A representative query for salvage analysis:

• SELECT asset_number, corporate_book, category_name, depreciation_cost, salvage_value, percent_salvage_value FROM okl_la_book_deprn_uv WHERE percent_salvage_value IS NOT NULL;
• SELECT corporate_book, category_name, AVG(deprn_rate), SUM(TO_NUMBER(salvage_value)) FROM okl_la_book_deprn_uv GROUP BY corporate_book, category_name;
• SELECT asset_number, description, in_service_date, orig_system_id1 FROM okl_la_book_deprn_uv WHERE kle_id = :p_kle_id;

Because numeric values such as SALVAGE_VALUE and PERCENT_SALVAGE_VALUE are stored as character strings, consumers should apply TO_NUMBER where arithmetic is required, guarding against nulls and empty strings.