Results for “cle_ml”

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

Overview

OKL_LA_ASSET_CAT_UV is an APPS-owned reporting view in the Oracle E-Business Suite lease and asset management (ETRM/OKL) schema. It exposes a consolidated, denormalized projection of lease contract lines that are associated with fixed assets and inventory model items, joining contract header, line style, transaction asset, and item master data into a single queryable structure. The view is primarily consumed by Oracle Lease and Asset Management reporting and integration logic that needs to resolve, for a given lease contract, the relationship between a model line (the leased item or "ITEM" style line), its fixed asset line (the "FIXED_ASSET" style line), and the corresponding inventory item and asset category.

Because it flattens data drawn from the OKC contract tables and OKL lease-specific tables together with MTL_SYSTEM_ITEMS_B, it is useful wherever downstream processes or reports require asset category assignment and residual value information without having to replicate complex multi-table joins. The view is defined with the USERENV('LANG') predicate on the translated contract line table, meaning it returns descriptions in the session language of the querying user.

The user search term "cle_fl" corresponds directly to the FIXED_ASSET line alias in the view definition (CLE_FL), which is the OKC_K_LINES_B instance filtered by the FIXED_ASSET line style.

Underlying Base Objects

The view is defined over the following documented base objects (all exposed to APPS through synonyms):

• OKC_K_LINES_B — the core contract line table, used three times (aliases CLE, CLE_ML, CLE_FL) to represent the free-form anchor line, the model/ITEM line, and the fixed-asset line respectively.
• OKC_K_LINES_TL — the translated contract line table (CLT), providing the asset number and item description.
• OKC_LINE_STYLES_B — the line style definitions (LSE, LSE_ML, LSE_FL), filtered on style codes FREE_FORM1, ITEM, and FIXED_ASSET.
• OKC_K_ITEMS — the contract item association (CIM), linking the model line to an inventory item.
• OKL_K_LINES — the lease-specific line extension (KLE), supplying OEC and residual value.
• OKL_TXL_ASSETS_B — the transaction asset table (TXL), supplying the used-asset indicator.
• MTL_SYSTEM_ITEMS_B — the inventory item master (MTL), supplying the asset category.

The join predicates enforce that the model line carries the ITEM style, the fixed-asset line carries the FIXED_ASSET style, and the anchor line carries FREE_FORM1, with the item master keyed by inventory item and organization.

Key Columns

• TOP_LINE — the top-level contract line identifier (CLT.ID), aligned with the lease line.
• ASSET_NUMBER — the contract line name, typically the asset identifier.
• DESCRIPTION — the item description from the translated line table.
• OEC and RESIDUAL_VALUE — lease-line economics sourced from OKL_K_LINES.
• ASSET_CATEGORY_ID — the fixed asset category from MTL_SYSTEM_ITEMS_B.
• FIXED_ASSET_LINE — the OKC_K_LINES_B identifier of the FIXED_ASSET line (the cle_fl alias).
• MODEL_LINE — the OKC_K_LINES_B identifier of the ITEM model line.
• USED_ASSET_YN — flag indicating whether the asset is used.
• DNZ_CHR_ID — the contract header identifier, useful for grouping all lines of a contract.

Common Use Cases and Queries

Typical usage includes resolving asset category assignment for lease lines, reconciling fixed-asset lines to model lines, and feeding downstream fixed-asset creation or reporting processes.

SELECT asset_number,
       description,
       oec,
       residual_value,
       asset_category_id,
       used_asset_yn
FROM   apps.okl_la_asset_cat_uv
WHERE  used_asset_yn = 'Y';

SELECT dnz_chr_id,
       asset_number,
       fixed_asset_line,
       model_line,
       asset_category_id
FROM   apps.okl_la_asset_cat_uv
WHERE  dnz_chr_id = :contract_id;

The first query isolates used assets for asset-management review; the second returns all asset-category lines for a specific contract header, exposing the fixed-asset/model line pairing that the cle_fl alias was constructed to resolve. All results are returned in the runtime session language.