Results for “model_line”

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

Overview

OKL_LA_ASSET_CAT_UV is a user interface (UI) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL — Leasing and Finance Management module. Its documented purpose is to serve the asset category list of values (LOV) page presented to users within the leasing application. The view consolidates contract line, line style, item master, asset, and taxonomy information into a single denormalized result set so that the LOV can present the asset categories associated with a given lease or finance contract.

In Oracle EBS reporting and integration contexts, the view functions as a convenience layer that abstracts a complex eleven-table join into a flat, query-friendly structure. Rather than requiring report authors or interface developers to reconstruct the OKC and OKL line hierarchies, the view exposes the relevant columns directly. The leading column of the view, TOP_LINE, is derived from OKC_K_LINES_TL.ID and is the first attribute returned, which explains why a search for "top_line" maps to this object. Because the view is a standard dictionary object with VALID status, it can be referenced in custom reports, OAF-based pages, and SQL*Plus or BI Publisher queries without requiring compilation.

Underlying Base Objects

The documented base objects referenced by the view are all accessed through synonyms in the APPS schema. These comprise MTL_SYSTEM_ITEMS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_LINE_STYLES_B, OKL_K_LINES, and OKL_TXL_ASSETS_B.

• OKC_K_LINES_B — the contract line base table, joined multiple times (aliased CLE, CLE_FL, and CLE_ML) to represent the parent line, the fixed-asset line, and the model line respectively.
• OKC_K_LINES_TL — the translation table supplying the asset number (NAME) and the TOP_LINE identifier, filtered by the session language via USERENV('LANG').
• OKC_LINE_STYLES_B — the line style definitions, filtered by LTY_CODE values 'FREE_FORM1', 'ITEM', and 'FIXED_ASSET' to ensure the correct line type is selected.
• OKC_K_ITEMS — the line-to-item association, linking contract lines to inventory items.
• MTL_SYSTEM_ITEMS_B — the item master, supplying ASSET_CATEGORY_ID and joined on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• OKL_K_LINES — the leasing-specific line table, providing OEC and RESIDUAL_VALUE.
• OKL_TXL_ASSETS_B — the tax/asset table supplying the USED_ASSET_YN flag.

Key Columns

The view exposes ten columns. TOP_LINE is the row identifier inherited from the translation table and typically serves as the LOV's primary key. ASSET_NUMBER carries the contract line name, while DESCRIPTION holds the item description. OEC and RESIDUAL_VALUE convey the leasing financial attributes (original equipment cost and residual value). ASSET_CATEGORY_ID links the row to the Oracle Assets category, and FIXED_ASSET_LINE and MODEL_LINE expose the corresponding contract line identifiers. USED_ASSET_YN indicates whether the asset is a used asset, and DNZ_CHR_ID carries the contract header identifier used throughout the OKC data model.

Common Use Cases and Queries

Typical uses include populating asset category LOVs, validating asset category assignments during lease booking, and building reports that join lease lines to Oracle Assets categories. A representative query follows:

• SELECT top_line, asset_number, asset_category_id FROM okl_la_asset_cat_uv WHERE dnz_chr_id = :contract_id;
• SELECT asset_number, oec, residual_value FROM okl_la_asset_cat_uv WHERE used_asset_yn = 'Y';
• SELECT asset_category_id, COUNT(*) FROM okl_la_asset_cat_uv GROUP BY asset_category_id;

Because the view is confined to UI LOV purposes, consumers should avoid treating it as a high-volume reporting source without appropriate indexing or materialization strategies.