Search Results attached_to_node_type




Overview
Explore in AI Chat

Overview

APPS.CZ_GLOBAL_DISPCOND_PROPS_V is a PL/SQL view in the Oracle E-Business Suite Applications schema that exposes metadata describing the property definitions used by Oracle's configuration and rules engine — historically associated with the Configurator/Configurator Developer and the broader CZ object family. In Oracle EBS 12.1.1 and 12.2.2 this view filters and reshapes the underlying global property catalog so that only properties of the "discrete condition" or global property class are surfaced for runtime evaluation and administrative reporting. The view's status is VALID and it carries FND Design Data identifier CZ.CZ_GLOBAL_DISPCOND_PROPS_V, confirming it is a seed-delivered, supported database object rather than a custom artefact.

The presence of the ATTACHED_TO_NODE_TYPE column — the term for which this object is most frequently searched — reflects the view's role in describing where a property may be attached within the configuration model hierarchy. It is a read-only projection: APPS.CZ_GLOBAL_DISPCOND_PROPS_V is not referenced by any other database object, so consumers query it directly rather than treating it as a dependency of further code.

Underlying Base Objects

The view is defined over three documented dependencies:

  • CZ_GLOBAL_PROPERTIES_V (VIEW) — supplies the master list of global properties, including identifiers, names and labels.
  • CZ_DATA_TYPES_V (VIEW) — supplies the datatype classification used to interpret each property's value domain.
  • FND_PROFILE (PACKAGE) — the standard EBS profile option API, typically invoked to apply language or security context when resolving labels and descriptive text.

Because two of the three dependencies are themselves views rather than base tables, the object is a layered abstraction. Physical storage resides in the CZ property and datatype tables beneath those views, and the FND_PROFILE package is called for context resolution rather than for row-level data. This layering is important operationally: performance tuning must target the lower-level CZ tables and their indexes, since no tuning can be applied directly to the view.

Key Columns

  • PROPERTY_ID (NUMBER) — primary identifier for the property; joins to other CZ property references.
  • PROPERTY_NAME (VARCHAR2, 255) — internal name used by the rules engine, typically non-translatable.
  • PROPERTY_LABEL (VARCHAR2, 290) — the user-facing, translatable label; the wider length accommodates concatenated or decorated display text.
  • DATA_TYPE (NUMBER) — numeric foreign key into the datatype definition, indicating how the value is validated and stored.
  • ATTACHED_TO_NODE_TYPE (NUMBER) — indicates the node or model level to which the property is bound, governing where it can be instantiated in a configuration hierarchy.
  • MUTABLE_FLAG (VARCHAR2) — indicates whether the property value may change after creation.
  • COLLECTION_FLAG (VARCHAR2) — indicates whether the property represents a collection/multi-value rather than a scalar.

Common Use Cases and Queries

The view is used for metadata auditing, integration extraction into downstream rules or configuration engines, and troubleshooting why a property does not appear at a given node type. A representative query is:

SELECT PROPERTY_ID, PROPERTY_NAME, PROPERTY_LABEL, DATA_TYPE, ATTACHED_TO_NODE_TYPE FROM APPS.CZ_GLOBAL_DISPCOND_PROPS_V WHERE ATTACHED_TO_NODE_TYPE = :node_type AND MUTABLE_FLAG = 'Y';

Join DATA_TYPE to CZ_DATA_TYPES_V to resolve human-readable type names, and filter on COLLECTION_FLAG to separate scalar from multi-value properties when generating interface definitions.