Results for “cz_im_item_types_v”

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

Overview

CZ_IM_ITEM_TYPES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the CZ (Configurator) product family. It presents item type definitions maintained in the Configurator data model together with their associated descriptive text, localized value descriptions, and UI image references. The view is exposed for use by Configurator runtime logic, concurrent reporting, and integration interfaces that need to resolve an item type to its displayable description and its corresponding UI image asset.

Its primary role is to flatten the join between the core Configurator item type entity and several lookup and image resolution objects, so that consumers can retrieve a ready-to-render record containing keys, dates, standard WHO audit columns, and presentation attributes. Because it exposes OBJECT_TYPE_DESC and ALT_TEXT explicitly, it is commonly referenced when a caller needs a human-readable object type description rather than a raw lookup code — the exact attribute that led users to search for the term "object_type_desc".

Underlying Base Objects

The ETRM metadata documents three referenced objects underlying this view:

• CZ_ITEM_TYPES (SYNONYM) — the primary Configurator item type table (aliased CZITEMTYPESEO in the view text). It supplies the item type identifier, name, description text, originating system reference, audit columns, and the soft-delete flag.
• CZ_RPOBJECTTYPES_LKV (VIEW) — a lookup view providing the object type value descriptions used to populate ALT_TEXT and OBJECT_TYPE_DESC. The join is anchored on DATA_VALUE = 'ITY'.
• CZ_UI_PATHED_IMAGES_V (VIEW) — a view resolving UI image file names and full image paths for the object type, joined via ENTITY_CODE = NUMERIC_ID_VALUE, with IMAGE_USAGE_CODE = 30 and UI_DEF_ID = 0.

The view text applies a soft-delete restriction (CZITEMTYPESEO.DELETED_FLAG = '0'), so only active, non-deleted item types are surfaced. Because two of the three sources are themselves views, the object provides an abstraction layer over the Configurator lookup and image-resolution mechanism.

Key Columns

• ITEM_TYPE_ID — primary key of the underlying item type, used for filtering and joins.
• NAME and DESC_TEXT — the item type name and its stored descriptive text.
• ORIG_SYS_REF — originating system reference, relevant for integration and provenance.
• DELETED_FLAG — soft-delete indicator; the view restricts output to '0'.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO audit columns.
• ALT_TEXT and OBJECT_TYPE_DESC — both map to CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION, giving the object type value description. This is the column most relevant to users searching "object_type_desc".
• IMAGE_FILE and FULL_IMAGE_PATH — image asset name and resolved path for UI rendering.

Common Use Cases and Queries

Typical scenarios include resolving an item type to its display description, populating Configurator UI elements with associated images, and validating item type lookups during integration loads.

• Retrieve all active item types with descriptions and images.
• Filter a single item type by identifier.
• Audit last-updated records.

SELECT item_type_id, name, desc_text, object_type_desc,
       image_file, full_image_path
FROM   apps.cz_im_item_types_v
WHERE  deleted_flag = '0';

SELECT item_type_id, name, object_type_desc
FROM   apps.cz_im_item_types_v
WHERE  item_type_id = :p_item_type_id;

SELECT item_type_id, name, last_update_date, last_updated_by
FROM   apps.cz_im_item_types_v
WHERE  last_update_date > SYSDATE - 30
ORDER  BY last_update_date DESC;

Note that although the view text includes the DELETED_FLAG = '0' predicate, the column remains selectable in the projection, as shown above.