Results for “date_placed_in_service”

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

Overview

OKL_LKE_REP_ASSET_UV is a supplementary database view owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 / 12.2.2 environment. It belongs to the OKL product family, Oracle Lease and Finance Management, and is documented with a status of VALID. The view is explicitly described as a supplementary view used to simplify user interface coding, which positions it as a convenience layer rather than a transactional or integration-facing object.

Its specific purpose is to surface information about tax book assets that are eligible for processing under the Lease and Finance Management asset reporting functionality. The view joins fixed asset book, asset definition, book control, depreciation method, and lease system accounting option data into a single denormalized result set. This consolidation relieves application code and reporting logic from having to assemble the join chain manually each time the same subset of asset and cost attributes is required.

For users searching on original_cost, this view is directly relevant. Original cost is one of the columns the view exposes, sourced from the FA_BOOKS table, and it is returned alongside the current cost of the asset, allowing comparative reporting between the two values.

Underlying Base Objects

The documented metadata identifies five referenced base objects, all exposed through synonyms in the APPS schema:

• FA_BOOKS — the Fixed Assets book assignment table; supplies original cost, current cost, depreciation method code, life in months, and date placed in service.
• FA_ADDITIONS_B — the Fixed Assets definition table; supplies the asset identifier and asset number.
• FA_BOOK_CONTROLS — the Fixed Assets book control table; validates that the book class is TAX and that the book is currently effective.
• FA_METHODS — the Fixed Assets depreciation method table; provides the descriptive depreciation method name.
• OKL_SYS_ACCT_OPTS — the OKL system accounting options table; supplies the LKE_HOLD_DAYS parameter used to bound the date range window.

The joins are enforced on book type code, asset identifier, depreciation method code, and life in months. Several restrictive predicates shape the result set: the book class must be TAX; the book must not have been made ineffective as of the current date; the asset cost must be greater than zero; outgoing transaction headers must be null; the asset must not carry a retirement identifier in the same book; and the date placed in service must fall within the trailing window defined by SYSDATE minus LKE_HOLD_DAYS through SYSDATE.

Key Columns

• REP_ASSET_ID — sourced from FA_ADDITIONS_B.ASSET_ID, the unique asset identifier.
• REP_ASSET_NUMBER — the user-visible asset number assigned in Fixed Assets.
• BOOK_TYPE_CODE — the tax book to which the asset belongs, derived from FA_BOOKS.
• ASSET_CATEGORY_ID — the Fixed Assets category identifier for the asset.
• ORIGINAL_COST — the original acquisition cost carried in FA_BOOKS; a central column for cost-basis comparisons.
• CURRENT_COST — exposed from FA_BOOKS.COST, reflecting the current cost of the asset.
• DATE_PLACED_IN_SERVICE — the in-service date used both for reporting and for the hold-days filter.
• DEPRN_METHOD — the descriptive name of the depreciation method, from FA_METHODS.NAME.
• LIFE_IN_MONTHS — the depreciable life of the asset in months.

Common Use Cases and Queries

Typical uses include lease asset reporting dashboards, reconciliation between original and current cost for recently placed-in-service tax book assets, and feeding user interface lists where a compact asset cost summary is needed without a multi-table join. A representative query filtering by original cost is shown below.

• SELECT rep_asset_number, book_type_code, original_cost, current_cost, date_placed_in_service FROM okl_lke_rep_asset_uv WHERE original_cost > 10000 ORDER BY original_cost DESC;
• SELECT book_type_code, depr_method, life_in_months, COUNT(*) FROM okl_lke_rep_asset_uv GROUP BY book_type_code, depr_method, life_in_months;
• SELECT rep_asset_id, rep_asset_number, original_cost, current_cost FROM okl_lke_rep_asset_uv WHERE original_cost <> current_cost;

Because the view already enforces the TAX book, active book control, non-retired, positive-cost, and hold-days conditions, consumers inherit those filters automatically and should not restate them.