Search Results split_percent

Overview

OKL_SPLIT_ASSET_COMP_UV is a user interface (UI) view owned by the APPS schema within the Oracle Lease and Finance Management (OKL) product family. It is not a standalone reporting object in the traditional sense; rather, it is a presentation-layer view that supplies the Assets List of Values (LOV) on the "Split Asset into Components" page in Oracle E-Business Suite. The view's primary function is to resolve and surface the inventory item details—item name, description, and inventory organization—that are attached to lease assets eligible for splitting into components.

The view carries a status of VALID in both Oracle EBS 12.1.1 and 12.2.2 and is registered in the ETRM metadata repository. Because it joins transactional lease asset data with inventory master data, it serves as a bridge between the OKL contract/asset schema and the inventory (INV) and item master (OKX) schemas. In practice, the view is consumed by Oracle Forms or OAF-based pages that render the split-asset LOV, and it is also a useful access point for technical consultants writing ad hoc reports that need the item description associated with a lease asset.

Underlying Base Objects

The view is defined over four documented base objects, combining lease contract data, lease asset data, inventory item data, and a pre-built asset view:

• OKC_K_LINES_B (SYNONYM) — The contract lines base table from the OKC (Contracts Core) schema. It supplies the top-level contract line identifier (CLE_ID), aliased as TOP_CLE_ID in the view.
• OKL_TXL_ASSETS_B (SYNONYM) — The lease transaction line asset base table. It provides the Financial Accounting contract line identifier (KLE_ID, aliased FA_CLE_ID) and the TAL_ID used to link to the asset view.
• OKL_TXD_ASSETS_V (VIEW) — A pre-built transactional asset view supplying the asset number, description, quantity, cost, split percentage, inventory item ID, TAL_ID, and a primary ID column.
• OKX_SYSTEM_ITEMS_V (VIEW) — A system items view in the OKX namespace that resolves INVENTORY_ITEM_ID into the item NAME, DESCRIPTION, and inventory organization ID (ID2 → INVENTORY_ORG_ID).

A correlated EXISTS subquery against OKL_TRX_ASSETS further restricts the result set to assets whose transaction type is 'ALI' and whose TSU_CODE is 'ENTERED', ensuring only entered (that is, committed) transactions are surfaced in the LOV.

Key Columns

The view exposes thirteen columns that together describe a split-eligible asset and its associated item:

• ID — Primary identifier from OKL_TXD_ASSETS_V; the unique row key for the LOV.
• TOP_CLE_ID — The contract line identifier from OKC_K_LINES_B.
• FA_CLE_ID — The Financial Accounting contract line identifier from OKL_TXL_ASSETS_B.
• TAL_ID — The transaction asset line identifier linking the asset record to its contract line.
• ASSET_NUMBER, DESCRIPTION, QUANTITY, COST, SPLIT_PERCENT — Core asset attributes displayed on the split-components page, including the percentage of the asset being split.
• INVENTORY_ITEM_ID — The item master identifier for the leased item.
• INVENTORY_ITEM_NAME — The item name resolved from OKX_SYSTEM_ITEMS_V, often the most frequently referenced column in reporting.
• INVENTORY_ITEM_DESCRIPTION — This is the column most directly relevant to the user's search term "inventory_item_description." It returns the descriptive text of the inventory item associated with the lease asset, sourced from the OKX_SYSTEM_ITEMS_V view.
• INVENTORY_ORG_ID — The inventory organization context for the item.

Common Use Cases and Queries

The most frequent technical use of this view is to retrieve the inventory item description for assets on a lease that are eligible for splitting. A typical query would resemble the following:

• Retrieve split-eligible assets with item description for a given contract line:

SELECT id, tal_id, asset_number, description, inventory_item_name, inventory_item_description, inventory_org_id, split_percent FROM apps.okl_split_asset_comp_uv WHERE fa_cle_id = :p_kle_id;

• Find all assets tied to a specific inventory item (by name or description):

SELECT asset_number, inventory_item_name, inventory_item_description FROM apps.okl_split_asset_comp_uv WHERE UPPER(inventory_item_description) LIKE '%PUMP%';

Because the view already restricts to TAL_TYPE = 'ALI', TAS_TYPE = 'ALI', and TSU_CODE = 'ENTERED', consultants do not need to re-apply those filters in downstream queries. The view is typically called from the split-asset LOV rather than joined into large reporting queries, since its driving purpose is UI selection. For integration or interface work, the view can be used to validate that item descriptions are populated before assets are submitted for component splitting, and it is a convenient source when reconciling lease assets to inventory items during data migration or audit activities. Note that as a UI view, it may not be optimized for high-volume reporting; in such cases, joining OKL_TXD_ASSETS_V to OKX_SYSTEM_ITEMS_V directly is often preferable.