Search Results cz_psnode_property_details_v

Overview

CZ_PSNODE_PROPERTY_DETAILS_V is an APPS-owned view within the Oracle Configurator (CZ) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It presents the property details associated with configuration model nodes, commonly referred to as PS nodes (configuration "problem space" nodes). Each row describes a single property attached to a node, including the property's identity, data type, current value, numeric value, defaults, translated text, and image metadata.

The view is a reporting and integration layer over the Configurator property repository. Where the underlying model captures normalized relationships among nodes, properties, and values, this view flattens them into a single result set keyed by PS_NODE_ID and PROPERTY_ID. The PS_NODE_NAME column it exposes is the primary attribute administrators and developers search on, matching the common lookup term "ps_node_name". This makes the view useful for diagnostics, data extraction, and custom reporting that must resolve a node's literal name alongside its property definitions without navigating the normalized Configurator tables directly.

Because the object is a view rather than a table, it is read-only; consumers cannot perform DML against it. All access is subject to the privileges granted on the APPS synonym and, where applicable, row-level security in underlying Configurator objects.

Underlying Base Objects

The documented metadata identifies a single referenced object: CZ_PSNODE_DIRECTPROP_INFO_V, itself a view. The view text confirms this direct dependency through a simple SELECT that projects columns from CZ_PSNODE_DIRECTPROP_INFO_V, aliased as PSNODE_PROP_DETAILS. No base tables are referenced directly by CZ_PSNODE_PROPERTY_DETAILS_V; any physical tables it ultimately reads are accessed transitively through CZ_PSNODE_DIRECTPROP_INFO_V, which joins the Configurator node and property entities. Consequently, the physical footprint of this object is entirely dependent on the definition of its parent view, and any change to CZ_PSNODE_DIRECTPROP_INFO_V propagates into this view. Consumers should treat CZ_PSNODE_DIRECTPROP_INFO_V as the authoritative intermediate object when diagnosing data discrepancies.

Key Columns

• PS_NODE_ID / PS_NODE_NAME — Identifier and literal name of the configuration node owning the property.
• PROPERTY_ID / PROPERTY_NAME — Identifier and name of the property attached to the node.
• DATA_TYPE — Declared data type governing the property's value semantics.
• PROPERTY_VALUE / PROPERTY_NUM_VALUE — Character and numeric representations of the current property value.
• DEFAULT_VALUE / DEF_NUM_VALUE — Character and numeric representations of the default value.
• ITEM_ID / ITEM_TYPE_ID — References to the associated item and item type in the inventory model.
• PROP_ATTACHES — Attachment information for the property.
• ORIG_SYS_REF, VALUE_ORIG_SYS_REF, PROPERTY_ORIG_SYS_REF — Original-system references supporting external or legacy origin tracking.
• TRANSLATED_TEXT / DEF_TRANSLATED_TEXT — Translated display text for the value and default.
• IMAGE_FILE, FULL_IMAGE_PATH, ALT_TEXT — Image asset metadata and alternate text for the property.
• PS_NODE_TYPE, INHERITED_FLAG, SRC_APPLICATION_ID — Node classification, inheritance indicator, and source application identifier.

Common Use Cases and Queries

Typical uses include auditing the properties attached to a named configuration node, extracting model property values for migration or comparison, and validating inherited versus directly defined property values.

Locating all properties for a named node:

SELECT ps_node_id, ps_node_name, property_id, property_name,
       data_type, property_value, default_value, inherited_flag
FROM   apps.cz_psnode_property_details_v
WHERE  ps_node_name = :node_name
ORDER  BY property_name;

Filtering by property name and data type:

SELECT ps_node_id, ps_node_name, property_name, property_value
FROM   apps.cz_psnode_property_details_v
WHERE  property_name LIKE 'COLOR%'
AND    data_type = 'String';

Reporting only explicitly defined properties:

SELECT ps_node_name, property_name, property_value, property_num_value
FROM   apps.cz_psnode_property_details_v
WHERE  inherited_flag = 'N';

Because all access passes through CZ_PSNODE_DIRECTPROP_INFO_V, performance tuning should focus on the underlying joins rather than on this projection layer.