Results for “okl_system_items_uv”

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

Overview

OKL_SYSTEM_ITEMS_UV is a seed data view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL – Lease and Finance Management product family. In EBS 12.1.1 and 12.2.2 the view is documented as VALID and is classified as a user-facing validation view (the "_UV" suffix conventionally denotes a validation view used by Oracle Forms LOVs and concurrent programs). Its role is to expose the set of inventory items that are valid for use by Oracle Lease and Finance Management, filtered according to the system-level defaults configured in OKL_SYSTEM_PARAMS. Because the view joins inventory, asset category, and lease parameter data, it represents the intersection of Oracle Inventory master data and OKL system configuration. The original search term "okl_system_params" is directly relevant: OKL_SYSTEM_PARAMS is the driving table that determines which organization and which asset book type the view restricts its results to.

Underlying Base Objects

The documented view text references six objects, five of which are exposed as APPS synonyms in the ETRM metadata: FA_CATEGORY_BOOK_DEFAULTS, MTL_PARAMETERS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL, and OKL_SYSTEM_PARAMS. MTL_SYSTEM_ITEMS_B appears twice — once as the primary item definition (alias B) and once as the master organization item (alias BM).

• OKL_SYSTEM_PARAMS (OSP) — Supplies ITEM_INV_ORG_ID and ASST_ADD_BOOK_TYPE_CODE, which anchor the entire query.
• MTL_SYSTEM_ITEMS_B (B, BM) — The item master; B is the enabled item in the OKL inventory organization, BM is the corresponding row in the master organization used to resolve ASSET_CATEGORY_ID.
• MTL_PARAMETERS (MP) — Inventory organization parameters; MASTER_ORGANIZATION_ID links the operating organization to its master.
• FA_CATEGORY_BOOK_DEFAULTS (FA) — Fixed Assets category/book defaults; restricts items to categories defined for the OKL asset book type.
• MTL_SYSTEM_ITEMS_TL (T) — The translated item descriptions, filtered by USERENV('LANG') for the session language.

Key Columns

The ETRM documentation lists two exposed columns, although the view text also selects ID1 and ID2:

• ITEM_NUMBER — MTL_SYSTEM_ITEMS_B.SEGMENT1, the user-visible item number.
• DESCRIPTION — MTL_SYSTEM_ITEMS_TL.DESCRIPTION in the session language.
• ID1 — Inventory item identifier (INVENTORY_ITEM_ID), used as the hidden value column behind ITEM_NUMBER in LOVs.
• ID2 — Organization identifier (ORGANIZATION_ID), the second key component required to uniquely identify an item in a multi-org context.

Common Use Cases and Queries

The view is typically queried by OKL setup and validation logic to confirm which items may be selected for lease transactions, asset additions, and contract lines. A typical ad hoc query is:

• SELECT item_number, description FROM okl_system_items_uv ORDER BY item_number;
• SELECT id1, id2, item_number, description FROM okl_system_items_uv WHERE item_number LIKE 'LEASE%';

Because results are driven by OKL_SYSTEM_PARAMS, a common diagnostic is to compare the view output against the parameter row: if ITEM_INV_ORG_ID or ASST_ADD_BOOK_TYPE_CODE is misconfigured, or if no FA category book default exists for the configured book type, the view returns no rows even though items are enabled in Inventory. The view therefore serves as both a functional LOV source and a quick sanity check on OKL system parameter setup.