Search Results salvage_value




Overview
Explore in AI Chat

Overview

OKL_AM_ASSET_DETAILS_UV is an APPS-owned database view within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 Oracle Leasing and Finance Management (OKL) module. It consolidates contract line, asset line, contract header, line style, and fixed asset category information into a single denormalized reporting structure. The view presents a flattened picture of leased assets tied to contracts, exposing descriptive and financial attributes such as original cost, in-service date, manufacturer, model, depreciation category, and the human-readable depreciation category description.

Its principal role is to support reporting and integration scenarios where an asset's contract context must be joined with its fixed asset depreciation classification without requiring the caller to construct multiple joins manually. In 12.2.2 the view remains VALID under the APPS schema and continues to reference the same underlying objects documented in 12.1.1. Because the view exposes DEPRN_CATEGORY_DESC through a description lookup against FA_CATEGORIES_VL, it is particularly relevant to users querying the search term "deprn_category_desc," which is the friendly description resolved from the numeric depreciation category on the asset line.

Underlying Base Objects

The view is defined over five referenced objects, each contributing a distinct portion of the result set:

  • OKL_K_LINES_FULL_V (VIEW) – Supplies the contract line identifier, line name, item description, change request ID, start and end dates, and line-level status code.
  • OKX_ASSET_LINES_V (VIEW) – Supplies asset-specific attributes such as original cost, serial number, in-service date, manufacturer name, model number, asset type, useful life in months, new/used indicator, salvage value, depreciation category, and depreciation start date. It is outer-joined on PARENT_LINE_ID.
  • OKC_K_HEADERS_B (SYNONYM) – Supplies the contract number and contract status code, joined via CHR_ID.
  • OKC_LINE_STYLES_V (VIEW) – Restricts rows to free-form line styles through the LTY_CODE = 'FREE_FORM1' predicate.
  • FA_CATEGORIES_VL (VIEW) – Provides the depreciation category description (FAC.DESCRIPTION) resolved from OALV.DEPRECIATION_CATEGORY via an outer join on CATEGORY_ID.

The outer joins on OKX_ASSET_LINES_V and FA_CATEGORIES_VL ensure that contract lines without a corresponding asset line, or asset lines without a matching fixed asset category, are retained with NULL asset or description values rather than being dropped.

Key Columns

Common Use Cases and Queries

Typical usage includes asset depreciation reporting, contract-to-asset reconciliation, and integration extracts where downstream systems require both the category code and its description. The following sample returns the contract, asset, and depreciation category details for free-form leased asset lines:

  • SELECT contract_number, name, item_description, serial_number, original_cost, depreciation_category, deprn_category_desc FROM okl_am_asset_details_uv WHERE deprn_category_desc IS NOT NULL;
  • SELECT contract_number, asset_type, life_in_months, new_used, salvage_value, deprn_start_date FROM okl_am_asset_details_uv WHERE line_status = 'ACTIVE';
  • SELECT deprn_category_desc, COUNT(*), SUM(original_cost) FROM okl_am_asset_details_uv GROUP BY deprn_category_desc ORDER BY deprn_category_desc;

Because the view already performs the FA_CATEGORIES_VL lookup, callers searching for "deprn_category_desc" can filter directly on that column without re-joining fixed asset category tables, reducing query complexity and improving consistency across reports. Note that the outer join nature of DEPRECIATION_CATEGORY means rows lacking a valid category will return a NULL description and should be handled explicitly in any grouping or filter logic.