Results for “okx_assets_v”

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

Overview

The OKX_ASSETS_V view is a source view within the Oracle E-Business Suite (EBS) Contracts Integration module (OKX), owned by the APPS schema. It serves as the data source for Fixed Asset Lines in Oracle Contracts when a lease contract is created or processed. In EBS 12.1.1 and 12.2.2, this view bridges the Oracle Assets (FA) schema and the Contracts integration layer, exposing asset attributes in a denormalized, contracts-oriented format that the OKX integration APIs consume.

The view presents a consolidated picture of a fixed asset as it relates to a corporate depreciation book, including asset identification, financial book values, depreciation parameters, and physical attributes. Its status is VALID in the documented environment, indicating it is compiled and free of errors. Because the view filters to corporate book controls and active book assignments, it returns only the asset records eligible for lease contract association.

Underlying Base Objects

OKX_ASSETS_V is defined over four base objects in the FA schema (accessed via APPS synonyms):

• FA_ADDITIONS_B – the base asset table holding primary asset identifiers such as ASSET_ID, ASSET_NUMBER, and TAG_NUMBER.
• FA_ADDITIONS_TL – the translated asset table supplying the ASSET description, joined by language using USERENV('LANG').
• FA_BOOKS – the asset books table supplying financial and depreciation attributes such as ORIGINAL_COST, ADJUSTED_COST, DEPRN_METHOD_CODE, and DATE_PLACED_IN_SERVICE.
• FA_BOOK_CONTROLS – the book controls table supplying ORGANIZATION_ID and SET_OF_BOOKS_ID and enforcing the corporate book scope.

The join is driven by BOOK_TYPE_CODE between FA_BOOK_CONTROLS and FA_BOOKS, and by ASSET_ID between FA_BOOKS, FA_ADDITIONS_B, and FA_ADDITIONS_TL. The view restricts results to CORPORATE book class records still in effect and excludes assets with a pending outbound transaction (TRANSACTION_HEADER_ID_OUT IS NULL).

Key Columns

The view exposes numerous columns; the most significant include:

• ASSET_ID / ASSET_NUMBER / TAG_NUMBER – unique asset identifiers used to link back to Oracle Assets.
• CURRENT_UNITS – the number of units associated with the asset, frequently targeted by users searching for lease quantity information.
• ORIGINAL_COST, COST, ADJUSTED_COST, RECOVERABLE_COST – financial values carried from FA_BOOKS.
• BOOK_TYPE_CODE, SET_OF_BOOKS_ID, ORG_ID – book and organization context for the asset line.
• DEPRN_METHOD_CODE, LIFE_IN_MONTHS, BASIC_RATE, ADJUSTED_RATE – depreciation parameters.
• SALVAGE_VALUE, PERCENT_SALVAGE_VALUE, REVAL_CEILING – residual and revaluation values.
• IN_SERVICE_DATE, DEPRN_START_DATE – placement and depreciation start dates.
• STATUS – derived via DECODE, returning 'A' for active or 'I' for inactive based on DATE_EFFECTIVE and DATE_INEFFECTIVE.
• OWNED_LEASED, PROPERTY_TYPE_CODE, IN_USE_FLAG – asset classification flags relevant to lease processing.

Common Use Cases and Queries

This view is typically queried when investigating how asset lines flow into lease contracts, when validating asset quantities, or when reconciling contract lines back to Oracle Assets.

To retrieve assets with their current units and book values:

• SELECT asset_number, tag_number, current_units, adjusted_cost, book_type_code FROM okx_assets_v ORDER BY asset_number;
• SELECT asset_id, asset_number, current_units FROM okx_assets_v WHERE current_units > 1;
• SELECT a.asset_number, a.description, b.set_of_books_id, b.org_id FROM okx_assets_v b, okx_assets_v a WHERE a.asset_id = b.asset_id AND b.org_id = :p_org_id;

Because the view already filters to active corporate books and excludes outbound transactions, queries against it require no additional book-scope predicates, making it convenient for Contracts integration diagnostics and operational reporting.