Search Results image_usage_code




Overview
Explore in AI Chat

Overview

CZ_UI_PATHED_IMAGES_V is an APPS-owned database view within the Oracle E-Business Suite Configurator (CZ) module. Its purpose is to expose image configuration records used by the Configurator user interface, presenting image file references together with a resolved, fully qualified image path suitable for rendering in Configurator UI screens. The view is defined as a single-table projection over CZ_UI_IMAGES, applying a filter that excludes logically deleted rows (DELETED_FLAG = '0'). In EBS 12.1.1 and 12.2.2, the object carries a status of VALID in the ETRM 12.2.2 repository.

For reporting and integration, the view provides a stable, presentation-ready interface to Configurator image metadata. Because it derives the full media path at the database layer, downstream consumers—BI Publisher reports, Forms-based Configurator UI logic, or custom integrations—do not need to reconstruct the /OA_MEDIA/ prefix or interpret relative versus absolute file references themselves.

Underlying Base Objects

The view is documented in ETRM 12.2.2 as being defined over a single referenced base object: CZ_UI_IMAGES (accessed through a synonym). No joins to other CZ tables are present in the documented view text. The owner/schema is APPS, and the definition is a straightforward SELECT with a WHERE clause on DELETED_FLAG. This means the view reflects only active (non-deleted) image definition rows, and any DML or data correction must occur on the base table CZ_UI_IMAGES, not the view. The DELETED_FLAG = '0' predicate implements a soft-delete convention common across Configurator data model tables.

Key Columns

  • UI_DEF_ID — Identifier of the Configurator UI definition to which the image belongs; the primary linking key.
  • MASTER_TEMPLATE_FLAG — Indicates whether the associated UI definition relates to a master template; this is the flag most frequently searched in relation to Configurator UI setup.
  • IMAGE_USAGE_CODE — Classifies how the image is used within the Configurator UI.
  • ENTITY_CODE — Identifies the entity context associated with the image record.
  • IMAGE_FILE — The stored image file reference as entered in the base table.
  • FULL_IMAGE_PATH — Computed column. When the stored path is relative (no leading slash and no URL scheme detected in the first characters), the view prepends /OA_MEDIA/; otherwise the value is returned unchanged.
  • Audit columns — LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, CREATION_DATE.
  • SEEDED_FLAG and DELETED_FLAG — Standard Configurator indicators; the latter is constrained to '0' by the view predicate.

Common Use Cases and Queries

Typical uses include auditing Configurator image assignments, retrieving render-ready paths for custom UI work, and filtering records tied to master templates. The following query lists active images for a given UI definition:

SELECT UI_DEF_ID, MASTER_TEMPLATE_FLAG, IMAGE_USAGE_CODE, IMAGE_FILE, FULL_IMAGE_PATH
FROM APPS.CZ_UI_PATHED_IMAGES_V
WHERE UI_DEF_ID = :ui_def_id;

Because MASTER_TEMPLATE_FLAG is exposed directly, it can be used to separate master template records from ordinary ones:

SELECT UI_DEF_ID, ENTITY_CODE, FULL_IMAGE_PATH
FROM APPS.CZ_UI_PATHED_IMAGES_V
WHERE MASTER_TEMPLATE_FLAG = 'Y';

For seeded data verification, filtering on SEEDED_FLAG and CREATION_DATE supports patch and upgrade impact analysis. All querying should observe APPS security conventions, and any correction of path values must be performed against the underlying CZ_UI_IMAGES table.