Search Results cz_node_user_properties_v




Overview
Explore in AI Chat

Overview

CZ_NODE_USER_PROPERTIES_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 reporting view owned by the APPS schema and delivered as part of the Oracle Configurator (CZ) product family. The view exposes the user-defined property assignments that exist on Configurator model nodes, resolving the relationship between a model structure node (PS_NODE), the properties (characteristics) referenced or captured on that node, and the data type of each property. Because Configurator property data is normalized across several base tables, application developers and report authors use this view as a denormalized read-only projection that is simpler to join than the underlying transactional structures.

The view is defined with a status of VALID and is not itself a data-collection object; it is strictly a query-only construct. The presence of a constant VIEWREV literal of '2006-01-12' in the view text indicates the view definition has been stable across the 12.1.1 and 12.2.2 releases, so queries written against it generally port between the two versions without change.

Underlying Base Objects

The documented base objects referenced by the view are:

These are referenced through APPS synonyms over the CZ base tables. The view text is a UNION of several branches. The first branch joins nodes to property values directly (PSN.PS_NODE_ID = PSVAL.PS_NODE_ID). The second branch resolves nodes whose node type is 263 and whose reference points to a property-value node. The third branch derives properties from the item's item type via CZ_ITEM_MASTERS and CZ_ITEM_TYPE_PROPERTIES. A fourth branch resolves properties through referenced nodes (REFND.PS_NODE_ID). In every branch, deleted rows are excluded by DELETED_FLAG = '0' predicates on each participating table, and the data type is obtained by matching PRP.DATA_TYPE to CNV.OBJECT_TYPE where REL_TYPE_CODE = 'CNV'.

Key Columns

  • PROP_ID — the property identifier (aliased from PROPERTY_ID); the primary join key to property master data.
  • NAME — the property name as defined on CZ_PROPERTIES, displayed to the end user.
  • PS_NODE_ID — the model structure node to which the property is attached.
  • DATA_TYPE — the resolved subject type of the property, obtained from CZ_TYPE_RELATIONSHIPS.
  • MUTABLE_FLAG — hard-coded to '0' by the view definition.
  • COLLECTION_FLAG — hard-coded to '0' by the view definition.
  • PROPERTY_TYPE — hard-coded to '2' by the view definition.
  • VIEWREV — the literal view revision date '2006-01-12'.

The constant columns mean the view is intended to expose property-to-node association and data typing only; mutability, collection semantics, and property type classification are not varied by row.

Common Use Cases and Queries

Typical scenarios include generating a listing of user properties defined on a given Configurator model node, auditing which properties are reachable through an item type, and feeding property metadata into integration extracts. A representative query to list properties for a node is:

SELECT p.PS_NODE_ID, p.PROP_ID, p.NAME, p.DATA_TYPE
FROM   APPS.CZ_NODE_USER_PROPERTIES_V p
WHERE  p.PS_NODE_ID = :node_id
ORDER BY p.NAME;

To find all nodes carrying a named property:

SELECT p.PS_NODE_ID, p.PROP_ID, p.DATA_TYPE
FROM   APPS.CZ_NODE_USER_PROPERTIES_V p
WHERE  p.NAME = :property_name;

Because the view already excludes soft-deleted records and resolves the data type, it is preferred over ad-hoc joins against CZ_PS_NODES, CZ_PS_PROP_VALS, and CZ_PROPERTIES for read-only reporting. Queries are best restricted by PS_NODE_ID or PROP_ID to limit the cost of the underlying UNION, and the view should be accessed with APPS privileges or a suitable synonym.