Results for “rate_source_rule”

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

Overview

OKX_ASST_DEP_METHODS_V is a view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKX – Contracts Integration product. The view exposes information about asset depreciation methods, providing a simplified, integration-oriented projection of the depreciation method definitions maintained in Oracle Assets. It is intended to supply downstream contract-related processes with the depreciation method attributes required to associate contracted assets with valid depreciation treatment.

The view presents a denormalized, presentation-ready shape. Rather than returning the raw method identifiers, it synthesizes an identifier pair (ID1/ID2), constructs a descriptive NAME by concatenating the method code with its useful life, and supplies constant or virtual values for date range, status, and unit-of-measure columns. This design allows consumers in the Contracts Integration flow to treat the view as a uniform, always-active reference list, without the need to interpret Oracle Assets' effective-dating or enabled/disabled conventions directly. The object holds VALID status in the documented environment.

Underlying Base Objects

The view is defined over a single referenced base object: the FA_METHODS synonym in APPS. FA_METHODS is the Oracle Assets table that stores depreciation method definitions, including the method code, the life expressed in months, the depreciation basis rules, proration conventions, and various control flags governing salvage value treatment and last-year depreciation behavior.

The relationship between the view and its base object is strictly read-only and one-to-one. Each row in FA_METHODS that is visible to the querying session yields exactly one row in the view. No joins, unions, or aggregations are applied. Consequently, the view inherits the effective-dating characteristics of FA_METHODS, but deliberately flattens them: START_DATE_ACTIVE is populated with SYSDATE and END_DATE_ACTIVE with SYSDATE+1, so the view always appears as a currently valid reference set at the moment of query execution.

Key Columns

• NAME – A derived display value formed as METHOD_CODE concatenated with a comma and the value of LIFE_IN_MONTHS, giving a human-readable label such as the method code followed by its life in months.
• LIFE_IN_MONTHS – The useful life of the depreciation method expressed in months. This is the column most directly associated with the search term "life_in_months" and serves as the principal discriminator between methods with the same code family.
• DESCRIPTION – The descriptive name of the depreciation method as stored in FA_METHODS.
• METHOD_CODE – The unique code identifying the depreciation method.
• DEPRECIATE_LASTYEAR_FLAG – Indicates whether the method depreciates in the final year of the asset's life.
• STL_METHOD_FLAG – Identifies whether the method is a straight-line method.
• RATE_SOURCE_RULE – Defines the source from which the depreciation rate is derived.
• DEPRN_BASIS_RULE – The rule governing the depreciation basis calculation.
• PRORATE_PERIODS_PER_YEAR – The number of proration periods applied per fiscal year.
• EXCLUDE_SALVAGE_VALUE_FLAG – Indicates whether salvage value is excluded from the depreciation basis.
• DEPRN_BASIS_FORMULA – The formula used to compute the depreciation basis.
• START_DATE_ACTIVE / END_DATE_ACTIVE – Virtual effective dates set to SYSDATE and SYSDATE+1 respectively.
• STATUS – A constant value of 'A', indicating an active status.
• PRIMARY_UOM_CODE – Always NULL in the view definition.

Common Use Cases and Queries

The view is typically used by Contracts Integration components that must validate or display the depreciation method assigned to an asset under a contract. A representative query lists all available methods with their useful lives:

• SELECT METHOD_CODE, NAME, LIFE_IN_MONTHS FROM OKX_ASST_DEP_METHODS_V ORDER BY LIFE_IN_MONTHS;
• SELECT METHOD_CODE, DESCRIPTION, DEPRN_BASIS_RULE FROM OKX_ASST_DEP_METHODS_V WHERE STL_METHOD_FLAG = 'Y';
• SELECT METHOD_CODE, LIFE_IN_MONTHS FROM OKX_ASST_DEP_METHODS_V WHERE LIFE_IN_MONTHS BETWEEN 12 AND 60;

Because the view is a thin projection over FA_METHODS, it is suitable for lookup and validation purposes rather than transactional processing.