Results for “attached_to_node_type”

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

Overview

The CZ_GLOBAL_DISPCOND_PROPS_V view is a reporting and integration object within the Oracle E-Business Suite Configurator (CZ) module. It is owned by the APPS schema and holds a VALID status in both EBS 12.1.1 and 12.2.2. The view exposes the set of global properties associated with display conditions in the Configurator data model — specifically those properties whose system property type is 'JSY'. Its principal role is to present a flattened, human-readable projection of configurator property metadata so that display-condition logic, constraint definitions, and UI rendering rules can be authored, inspected, and validated without navigating the highly normalized Configurator base schema.

The view does not store data; it derives all of its content at runtime from other Configurator views. This makes it an ideal read-only integration point for reporting, for form-level LOV queries, and for building the developer-facing property inventory used by Configurator modeling tools.

Underlying Base Objects

According to the documented ETRM metadata, CZ_GLOBAL_DISPCOND_PROPS_V is defined over the following referenced objects:

• CZ_GLOBAL_PROPERTIES_V (VIEW) — the primary source, aliased as MAINPROP in the view definition. All projected rows originate here, filtered by SYSTEM_PROPERTY_TYPE = 'JSY'.
• CZ_DATA_TYPES_V (VIEW) — joined (via a correlated subquery on SIGNATURE_ID) to resolve the data-type signature name used to build the display label.
• FND_PROFILE (PACKAGE) — the standard EBS profile-option API, referenced by the underlying Configurator views for environment or session context.

Because every dependency is itself a view, the object inherits the Configurator's runtime security and profile-driven filtering. It performs no DML and therefore carries no integrity constraints of its own.

Key Columns

The view exposes seven columns:

• PROPERTY_ID — the unique numeric identifier of the global property; the logical primary key for reporting purposes.
• PROPERTY_NAME — the internal name of the property as defined in the Configurator model.
• PROPERTY_LABEL — a derived, user-facing label. It concatenates PROPERTY_TOKEN with the data-type signature name (from CZ_DATA_TYPES_V) formatted as ' [Signature Name]', but only when a duplicate property with a different PROPERTY_ID shares the same name. This disambiguates otherwise identically named properties.
• DATA_TYPE — the data-type identifier linking to the data-type signature; it drives value validation and display formatting.
• ATTACHED_TO_NODE_TYPE — indicates the configurator node type to which the property is bound.
• MUTABLE_FLAG — indicates whether the property value may be changed at runtime.
• COLLECTION_FLAG — indicates whether the property represents a collection (multiple values) rather than a scalar.

Common Use Cases and Queries

Typical scenarios include auditing display-condition properties, driving custom validation, and generating property inventories for model documentation. The DISTINCT keyword in the view text ensures duplicate rows are suppressed when the correlated subquery matches multiple signatures.

A basic inventory query:

• SELECT property_id, property_name, property_label, data_type FROM cz_global_dispcond_props_v ORDER BY property_name;

Identifying mutable collection properties attached to a node type:

• SELECT property_name, property_label FROM cz_global_dispcond_props_v WHERE mutable_flag = 'Y' AND collection_flag = 'Y';

Joining to a node-type reference to scope properties for a specific configuration context:

• SELECT p.property_name, p.attached_to_node_type FROM cz_global_dispcond_props_v p WHERE p.attached_to_node_type = :node_type;

Because the view is read-only and schema-owned by APPS, access should be granted through standard EBS responsibility and menu configuration rather than direct object grants.