Search Results year_of_manufacture




Overview
Explore in AI Chat

Overview

The OKL_LA_ITEM_DTLS_UV view is a user-facing (UV) reporting object owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 / 12.2.2 environment. It belongs to the OKL – Leasing and Finance Management product family and is described simply as Item Details. The view consolidates lease-contract line information with inventory item master data, presenting a flattened, denormalized picture of the individual items attached to a lease or finance agreement. Its presence in the OKL module makes it a convenient access point for reporting on leased assets without requiring the caller to reconstruct the complex multi-table joins between contract lines, contract items, and inventory definitions. Because it exposes manufacturer, model, and YEAR_OF_MANUFACTURE attributes, the view is frequently targeted by users searching for asset-aging and equipment-identification information. As a "_UV" view, it is intended for read-only querying in custom reports, extracts, and integration interfaces rather than for direct DML operations.

Underlying Base Objects

The view is defined over eight documented base objects, all accessed through APPS synonyms: OKL_K_LINES, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_K_ITEMS, OKC_LINE_STYLES_B, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL, and OKC_K_PARTY_ROLES_B. OKL_K_LINES supplies the leasing-specific item attributes, including MANUFACTURER_NAME, MODEL_NUMBER, and YEAR_OF_MANUFACTURE. OKC_K_LINES_B and OKC_K_LINES_TL provide the contract line header and translated comments, joined on the line ID and the session language (USERENV('LANG')). OKC_K_ITEMS represents the item instance on the contract via OBJECT1_ID1/ID2 and the JTOT_OBJECT1_CODE discriminator. OKC_LINE_STYLES_B restricts results to lines whose style code is 'ADD_ITEM'. MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_TL supply item NAME and DESCRIPTION from the inventory master. OKC_K_PARTY_ROLES_B is outer-joined to resolve the vendor role identified by the role code 'OKL_VENDOR'.

Key Columns

  • ID – Primary line identifier (CLE.ID) for the leased item.
  • PARENT_LINE_ID – The parent contract line (CLE.CLE_ID), enabling hierarchical grouping.
  • UNIT_COST – Character-converted unit price from the contract line.
  • DNZ_CHR_ID – The contract header identifier linking lines to the agreement.
  • OBJECT_CODE – Discriminator (JTOT_OBJECT1_CODE), typically 'OKX_SYSITEM'.
  • QUANTITY – Number of items on the line.
  • NAME / DESCRIPTION – Inventory item descriptions from MTL_SYSTEM_ITEMS_B and _TL.
  • MANUFACTURER_NAME / MODEL_NUMBER / YEAR_OF_MANUFACTURE – Asset identification attributes sourced from OKL_K_LINES.
  • VENDOR_ID / VENDOR_NAME / CPL_ID – Vendor resolution from the party role join; VENDOR_NAME is currently a NULL literal.
  • NOTES – Line-level translated comments.

Common Use Cases and Queries

Typical usage includes asset registers by manufacturer or model year, vendor-linked asset reporting, and item-level lease extracts. A representative query filtering on the searched attribute is:

SELECT id, parent_line_id, name, manufacturer_name, model_number, year_of_manufacture, quantity, unit_cost FROM apps.okl_la_item_dtls_uv WHERE year_of_manufacture = '2019' ORDER BY manufacturer_name, model_number;

To aggregate leased quantities by model year, wrap the view in a GROUP BY on YEAR_OF_MANUFACTURE. To report vendor participation, join on VENDOR_ID. Because the view already enforces the 'ADD_ITEM' line style and the OKL_VENDOR role filter, no additional predicate for those conditions is required. Always query through the APPS synonym and avoid modifying the view, as it is a seeded, VALID dictionary object subject to Oracle's proprietary and confidential terms.