Search Results p_mutable_flag

Overview

CZ_EXPLNODES_AVAILVALUES_CV is a configuration view owned by the APPS schema within the Oracle Configurator (CZ) product family. It presents a filtered projection of the CZ_EXPLNODES_WITHIMAGES_V view and enriches it with a computed availability indicator derived from node property values, type relationships, and system properties. The suffix "CV" denotes a "custom view" convention in Configurator, signaling that the object is intended for reporting and integration consumption rather than for direct application DML.

Its primary role is to expose configuration model nodes — with their images, effective dating, hierarchy, and type metadata — alongside a derived flag indicating whether a node has available values. This makes the view valuable when building extract reports, integration interfaces, or diagnostic queries that need to determine, in a single pass, which configurator nodes are populated versus unpopulated. Because the view resolves relationships across signature, type, and property tables, it encapsulates complex Configurator metadata logic that would otherwise require multiple correlations.

Underlying Base Objects

The view is defined over the following documented base objects:

• CZ_EXPLNODES_WITHIMAGES_V (VIEW) — The primary source of node rows, supplying PS_NODE_ID, NAME, hierarchy columns, images, and effectivity attributes.
• CZ_TYPE_RELATIONSHIPS (SYNONYM) — Referenced repeatedly to resolve "CNV" (component-node-value) relationships between signatures, data types, system properties, and detailed types.
• CZ_PSNODE_PROPVAL_V (VIEW) — Provides node property values used to correlate node IDs against their data types.
• CZ_SYSTEM_PROPERTIES_V (VIEW) — Supplies system property definitions joined through SPREL relationships.
• CZ_SIGNATURES (SYNONYM) — Connects signature IDs to type relationships for property and node resolution.
• CZ_DEVELOPER_UTILS_PVT, CZ_TYPES, CZ_UTILS (PACKAGES) — Supporting programmatic utilities referenced by the broader Configurator metadata model.
• DUAL (SYNONYM) — Used in the scalar subquery that computes the availability indicator.

The computed availability column is produced by a scalar subquery returning 1 minus a count, aggregating over a UNION ALL of three EXISTS branches that test property values, detailed-type relationships, and system properties respectively.

Key Columns

• PS_NODE_ID, NAME, PARENT_ID — Core node identity and hierarchical placement within the configuration model.
• PS_NODE_TYPE, FEATURE_TYPE, DETAILED_TYPE_ID — Classify the node's configurator semantics and link it to type definitions.
• INITIAL_VALUE, MINIMUM, MAXIMUM, MINIMUM_SELECTED, MAXIMUM_SELECTED — Value constraints and selection bounds.
• EFFECTIVE_FROM, EFFECTIVE_UNTIL, EFFECTIVITY_SET_ID, EFFECTIVE_USAGE_MASK — Date and usage effectivity governing node applicability.
• XPL_VIRTUAL_FLAG, NODE_DEPTH, TREE_SEQ — Structural attributes describing virtual nodes and tree ordering.
• FULL_IMAGE_PATH, ALT_TEXT — Presentation metadata inherited from the underlying images view.
• NO_VALUE (derived) — Availability indicator computed from property, type-relationship, and system-property predicates. Although the search term "p_mutable_flag" does not appear as a column name in this view, the underlying relationship filters (such as MFLAG and CFLAG conditions in CZ_TYPE_RELATIONSHIPS) govern mutability-related behavior reflected in the availability computation.

Common Use Cases and Queries

Typical usage includes auditing node populations, validating configuration model integrity, and feeding downstream reporting. The availability column supports identifying nodes lacking any resolved values.

• Node inventory by model: SELECT PS_NODE_ID, NAME, NODE_DEPTH, NO_VALUE FROM APPS.CZ_EXPLNODES_AVAILVALUES_CV WHERE PARENT_EXPL_NODE_ID IS NULL;
• Nodes with no available values: SELECT PS_NODE_ID, NAME FROM APPS.CZ_EXPLNODES_AVAILVALUES_CV WHERE NO_VALUE = 1;
• Effectivity-scoped listing: SELECT PS_NODE_ID, NAME, EFFECTIVE_FROM, EFFECTIVE_UNTIL FROM APPS.CZ_EXPLNODES_AVAILVALUES_CV WHERE SYSDATE BETWEEN EFFECTIVE_FROM AND EFFECTIVE_UNTIL;