Results for “cz_im_items_v”

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

Overview

The CZ_IM_ITEMS_V view is an APPS-owned database object within the Oracle E-Business Suite Configurator (CZ) module. It presents a consolidated, denormalized read model of Configurator item masters, exposing core item attributes alongside descriptive lookup text and associated image metadata. In Oracle EBS 12.1.1 and 12.2.2, the view serves as a convenient reporting and integration interface over the underlying CZ_ITEM_MASTERS table, which stores model, option class, and option definitions used by the Configurator runtime and its user interface. Because it joins item data to lookup descriptions and image paths, the view is particularly useful for extracting presentation-ready item records without requiring callers to reconstruct the joins themselves.

Underlying Base Objects

Per the documented ETRM metadata, CZ_IM_ITEMS_V is defined over three referenced objects:

• CZ_ITEM_MASTERS (exposed via a synonym) — the primary source of item rows, supplying identification, description, status, lead time, UOM, and audit columns. The defining query aliases this object as CZITEMMASTERSEO.
• CZ_RPOBJECTTYPES_LKV (a view) — a lookup source filtered to DATA_VALUE = 'ITM', supplying descriptive text for the object type through the VALUE_DESCRIPTION column, aliased as both ALT_TEXT and OBJECT_TYPE_DESC.
• CZ_UI_PATHED_IMAGES_V (a view) — supplies image file names and full image paths, joined on entity code, image usage code 30, and UI definition ID 0.

The join predicates restrict output to non-deleted item masters (DELETED_FLAG = '0'), require the lookup to resolve to a non-null object type value, and require a matching image row. This means the view returns only items that satisfy all three conditions.

Key Columns

• ITEM_ID — Primary identifier of the Configurator item master record.
• ITEM_TYPE_ID — Reference to the item's type classification.
• DESC_TEXT — Descriptive text for the item.
• REF_PART_NBR — Reference part number.
• ITEM_STATUS — The status value of the item, relevant to availability and lifecycle state. Callers searching for "item_status" will find this column directly exposed.
• QUOTEABLE_FLAG — Indicates whether the item may be quoted.
• LEAD_TIME and PRIMARY_UOM_CODE — Planning attributes for the item.
• DELETED_FLAG, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, LAST_UPDATE_DATE — Standard audit columns.
• ALT_TEXT, OBJECT_TYPE_DESC — Lookup-derived descriptive values.
• IMAGE_FILE, FULL_IMAGE_PATH — Image presentation attributes.

Common Use Cases and Queries

The view is commonly used for Configurator item reporting, UI-oriented extracts, and integration feeds that require item status, part numbers, and imagery in a single query. A typical status report:

SELECT item_id, ref_part_nbr, desc_text, item_status, primary_uom_code
FROM   apps.cz_im_items_v
WHERE  item_status = 'A';

A listing of quoteable items with their images:

SELECT i.item_id, i.ref_part_nbr, i.object_type_desc, i.image_file
FROM   apps.cz_im_items_v i
WHERE  i.quoteable_flag = 'Y'
ORDER BY i.ref_part_nbr;

Because the view already filters deleted records and enforces lookup and image joins, queries against it are simpler and less error-prone than equivalent joins across the base objects, though callers should be aware that items lacking matching image or lookup rows will not appear in the result set.