Results for “iay_id_new”

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

Overview

The OKL_AM_OFF_LEASE_TRX_UV view is a user-facing database object owned by the APPS schema within Oracle Lease and Finance Management (OKL). It presents off-lease asset transaction data, consolidating attributes from the transaction, asset, and asset-line layers into a single denormalized structure. Its principal role in Oracle EBS 12.1.1 and 12.2.2 is as a reporting and integration source: it exposes the state of leased assets that are scheduled for or have undergone off-lease processing, including depreciation configuration, salvage and residual values, retirement quantities, and sale proceeds. Because it joins descriptive columns resolved from lookups and reference tables (for example, depreciation method names and financial asset category descriptions) alongside stored business keys, the view is well-suited to ad-hoc queries, Oracle Discoverer/BI Publisher datasets, and downstream interfaces that must consume asset lifecycle data without traversing the normalized OLTP tables directly. The name suffix "UV" follows the Oracle convention for user views, indicating it is intended for query access rather than direct DML.

Underlying Base Objects

Per the documented 12.2.2 metadata, the view is defined over the following objects:

• OKL_TRX_ASSETS — the primary transaction asset table (aliased TALB), supplying asset-level identification, cost, location, and depreciation controls.
• OKL_TXD_ASSETS_B — the transaction asset details base table (aliased TALT), contributing descriptive text such as asset description.
• OKL_TXL_ASSETS_B and OKL_TXL_ASSETS_TL — asset line base and translation tables, supplying line-level data such as SFWT flag.
• OKC_K_HEADERS_B — the contract header table, providing CONTRACT_NUMBER for the associated lease.
• FA_METHODS — the Oracle Assets depreciation method table, resolving DEPRN_METHOD_NAME from DEPRN_METHOD.
• FA_CATEGORIES_VL — the Assets asset category view, supplying FA_CATEGORY_DESCRIPTION for the assigned IAY (asset category) identifier.
• FND_LOOKUPS — lookup source for TAS_TYPE_MEANING.
• FA_BOOK_CONTROLS and FND_GLOBAL — supporting references for assets book context and environment/security values.

The view therefore sits above the OKL transaction asset family and resolves code values from Oracle Assets and FND reference objects, presenting a business-friendly projection of the underlying rows.

Key Columns

• TAL_ID / TAL_TYPE / TAS_TYPE — asset transaction identifier and its type, with TAS_TYPE_MEANING decoding the type via FND_LOOKUPS.
• CONTRACT_NUMBER / LINE_NUMBER / ILO_ID / ILO_ID_OLD — links the asset to its lease contract and line, plus current and prior contract (ILO) identifiers.
• ASSET_NUMBER, TAG_NUMBER, MODEL_NUMBER, MANUFACTURER_NAME, YEAR_MANUFACTURED, DATE_PURCHASED — physical asset identification attributes.
• ORIGINAL_COST, CURRENT_UNITS, USED_ASSET_YN, IN_SERVICE_DATE, LIFE_IN_MONTHS — cost and lifecycle basis.
• DEPRECIATION_ID, DEPRECIATION_COST, DEPRN_METHOD, DEPRN_METHOD_NAME, DEPRN_RATE, SALVAGE_VALUE, PERCENT_SALVAGE_VALUE — depreciation setup, with DEPRN_METHOD_NAME resolved from FA_METHODS.
• DEPRECIATE_YN — the depreciation indicator (the column most frequently queried by users); it flags whether depreciation applies to the asset transaction. It is commonly filtered alongside DEPRN_METHOD and SALVAGE_VALUE to isolate depreciating assets.
• OLD_SALVAGE_VALUE, NEW_RESIDUAL_VALUE, OLD_RESIDUAL_VALUE, UNITS_RETIRED, COST_RETIRED, SALE_PROCEEDS, REMOVAL_COST — off-lease termination and residual accounting values.
• DNZ_ASSET_ID / DNZ_KHR_ID — non-standard (DNZ) asset and key references used in off-lease transfer processing.

Common Use Cases and Queries

Typical uses include identifying assets that will depreciate after off-lease, reconciling salvage and residual adjustments, and feeding asset retirement data into Oracle Assets.

• List all depreciating off-lease assets for a contract.
• Report assets by depreciation method and rate.
• Reconcile retired units against sale proceeds and removal costs.
• Export asset category and contract data for interfaces.

Sample SQL:

SELECT contract_number, asset_number, tas_type_meaning,
       depreciate_yn, deprn_method_name, deprn_rate,
       original_cost, salvage_value, new_residual_value
FROM   apps.okl_am_off_lease_trx_uv
WHERE  depreciate_yn = 'Y'
AND    org_id = :p_org_id
ORDER BY contract_number, line_number;

Additional filters on TAS_TYPE_MEANING, FA_CATEGORY_DESCRIPTION, or COST_RETIRED support operational and analytical reporting requirements.