Search Results cz_itemmaster_hgrid_v




Overview
Explore in AI Chat

Overview

CZ_ITEMMASTER_HGRID_V is an APPS-owned database view in the Oracle E-Business Suite Configurator (CZ) module. It presents a hierarchical, grid-oriented result set of configurator item master data, combining item type records with presentation attributes such as alternate text and image paths. The view is designed to feed user interface grid components and reporting layers that display configurator item hierarchies, rather than to store transactional data itself. Because Configurator relies heavily on item types and their related UI definitions, this view acts as a read-only projection that joins model and presentation metadata into a single flattened structure suitable for HGrid-style rendering.

The view carries STATUS VALID in both EBS 12.1.1 and 12.2.2, indicating it remains a supported, compiled object across these releases. It is not a table; consumers cannot perform DML against it and must treat the output as derived data.

Underlying Base Objects

The documented ETRM metadata lists four referenced base objects: CZ_ITEM_MASTERS (SYNONYM), CZ_ITEM_TYPES (SYNONYM), CZ_RPOBJECTTYPES_LKV (VIEW), and CZ_UI_PATHED_IMAGES_V (VIEW). The view text reveals a two-branch UNION ALL structure. The first branch synthesizes a root node with OBJECT_ID 0, OBJECT_TYPE 'NUL', and NAME 'ITEM MASTER', joining CZ_RPOBJECTTYPES_LKV and CZ_UI_PATHED_IMAGES_V on the 'ITY' object type code with IMAGE_USAGE_CODE 30 and UI_DEF_ID 0. The second branch selects actual item type rows from CZ_ITEM_TYPES, joined to the same lookup and image views, restricted by DELETED_FLAG = '0'. This design produces a synthetic parent row plus its child item type rows, forming the hierarchical grid.

Key Columns

Common Use Cases and Queries

Typical usage includes custom grid extensions, Configurator UI diagnostics, and reporting on item type hierarchies with their associated imagery. A representative query filters the synthetic root and lists active item types:

  • SELECT OBJECT_ID, OBJECT_TYPE, NAME, ALT_TEXT, FULL_IMAGE_PATH FROM APPS.CZ_ITEMMASTER_HGRID_V WHERE OBJECT_TYPE = 'ITY' ORDER BY NAME;
  • To isolate the root node: SELECT * FROM APPS.CZ_ITEMMASTER_HGRID_V WHERE OBJECT_TYPE = 'NUL';
  • To audit node count per type: SELECT OBJECT_TYPE, COUNT(*) FROM APPS.CZ_ITEMMASTER_HGRID_V GROUP BY OBJECT_TYPE;

Because ALT_TEXT and FULL_IMAGE_PATH derive from UI definition joins, results depend on properly configured image usage and lookup data; missing configurations yield null presentation attributes.