Results for “okl_asset_components_v”

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

Overview

OKL_ASSET_COMPONENTS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL – Leasing and Finance Management (Oracle Lease and Finance Management, or OLFM) product family. The view presents descriptive and financial attributes of asset components — the individual itemized elements that make up a leased or financed asset — in a single denormalized result set. Its primary role is to decouple consuming code (forms, concurrent programs, OAF pages, and external integrations) from the physical storage model, which is split between a base table holding the operational columns and a translation table holding language-dependent descriptive text.

The view is documented as VALID for both EBS 12.1.1 and 12.2.2, and its definition is reproduced in the ETRM reference under the heading "View for OKL_ASSET_COMPONENTS_V and OKL_ASSET_COMPONENTS_TL." Because it joins the translation table on the session language, the view returns short description, description, and comment fields in the language of the querying session, while the underlying numeric, cost, and identifier columns remain language-neutral. This makes it suitable for both same-language transactional reporting and multi-language deployments where users in different locales must see component text in their own language.

Underlying Base Objects

The ETRM metadata documents two referenced base objects, both exposed through synonyms in the APPS schema:

• OKL_ASSET_COMPONENTS_B — the base (operational) table. It carries the surrogate key ID, the OBJECT_VERSION_NUMBER used for optimistic locking, the WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), the DFF flexfield columns ATTRIBUTE_CATEGORY through ATTRIBUTE15, and the substantive business attributes including ASSET_ID, INV_ITEM_ID, SUPPLIER_ID, PRIMARY_COMPONENT, UNIT_COST, NUMBER_OF_UNITS, MANUFACTURER_NAME, YEAR_MANUFACTURED, and MODEL_NUMBER.
• OKL_ASSET_COMPONENTS_TL — the translation table, which supplies SHORT_DESCRIPTION, DESCRIPTION, and COMMENTS.

The join predicate is ASO.ID = ASOT.ID AND ASOT.LANGUAGE = USERENV('LANG'), so exactly one translation row per component is returned for the current language setting. The view exposes ASO.ROWID as ROW_ID, a construct commonly used by Oracle Forms and OAF for row identification and update processing.

Key Columns

• ID / ROW_ID — surrogate primary key of the component and the base-table row identifier.
• ASSET_ID — the parent asset to which the component belongs; the principal foreign key used to group components under a lease or financed asset.
• INV_ITEM_ID — reference to the inventory item master (MTL_SYSTEM_ITEMS_B), linking the component to a defined item.
• SUPPLIER_ID — the supplier (PO vendor) associated with the component, referencing PO_VENDORS / AP_SUPPLIERS.
• PRIMARY_COMPONENT — flag indicating whether the component is the primary constituent of the asset.
• UNIT_COST and NUMBER_OF_UNITS — the per-unit cost and quantity of units; their product yields the extended component value used in asset valuation.
• MANUFACTURER_NAME, YEAR_MANUFACTURED, MODEL_NUMBER — asset identification attributes widely used in lease origination, residual valuation, and equipment tracking. YEAR_MANUFACTURED is the column most commonly sought by users searching this view.
• SHORT_DESCRIPTION, DESCRIPTION, COMMENTS — language-specific text sourced from OKL_ASSET_COMPONENTS_TL.
• OBJECT_VERSION_NUMBER and the WHO columns — audit and concurrency-control information.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — the descriptive flexfield (DFF) context and segment columns for customer-defined attributes.

Common Use Cases and Queries

Typical uses include asset component detail inquiry from OLFM asset pages, valuation and residual analysis, supplier and inventory reporting, and data extraction into external asset-management or analytics platforms. The following query lists components for a given asset, including manufacture details:

SELECT id, asset_id, inv_item_id, manufacturer_name,
       year_manufactured, model_number, unit_cost, number_of_units,
       short_description, description
  FROM apps.okl_asset_components_v
 WHERE asset_id = :p_asset_id
 ORDER BY primary_component DESC, id;

To identify components by year of manufacture, for example in age-based valuation or obsolescence reporting:

SELECT asset_id, manufacturer_name, year_manufactured, model_number,
       unit_cost * number_of_units AS extended_value
  FROM apps.okl_asset_components_v
 WHERE year_manufactured < :p_cutoff_year;

Aggregate component values per asset for reconciliation with the asset's recorded cost:

SELECT asset_id, SUM(unit_cost * number_of_units) total_component_cost
  FROM apps.okl_asset_components_v
 GROUP BY asset_id;

Because the view filters translations on USERENV('LANG'), reports executed by users with different language settings return correspondingly localized descriptions without any change to the query text.