Search Results property_type




Overview
Explore in AI Chat

Overview

APPS.CZ_NODE_USER_PROPERTIES_V is a reporting and integration view in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, belonging to the ETRM (Enterprise Tax and Regulatory Management, historically the Configurator/Contracts "CZ" schema family). The view presents properties attached to configuration nodes ("ps_nodes") from the perspective of user-facing property definitions. Each row exposes a property identifier, its name, the node to which it applies, the data type, and control flags describing how the property behaves. The view is a UNION of four SELECT branches, each joining the same property definition table against a different association path — direct node values, node-type reference relationships, item-master item-type properties, and additional node-reference relationships.

A constant literal property_type = '2' is emitted in every branch, which is significant given the user's search term "property_type". This constant classifies all rows returned by this view as a single property type (value '2'), allowing callers to distinguish this view's output from other property views that emit different property_type values. Other literals include mutable_flag = '0', collection_flag = '0', and viewrev set to '2006-01-12', a version marker indicating the view revision date. These constants make the view a stable, read-only projection suitable for reporting rather than transactional updates.

Underlying Base Objects

The documented referenced base objects are CZ_PROPERTIES, CZ_PS_NODES, CZ_PS_PROP_VALS, CZ_TYPE_RELATIONSHIPS, CZ_ITEM_MASTERS, and CZ_ITEM_TYPE_PROPERTIES, all resolved as SYNONYMs owned by APPS. The view is defined strictly over these synonyms, consistent with EBS convention that public apps-level views sit on top of synonyms to underlying CZ tables.

  • CZ_PROPERTIES — supplies property definitions; joined on property_id and filtered by deleted_flag = '0'. Provides name and data_type.
  • CZ_PS_NODES — supplies the node context; joined on ps_node_id (or via reference_id, item_id) and filtered by deleted_flag = '0'.
  • CZ_PS_PROP_VALS — supplies the actual property values assigned to a node; joined on ps_node_id and property_id, filtered by deleted_flag = '0'.
  • CZ_TYPE_RELATIONSHIPS — provides the resolved data type through subject_type, filtered by rel_type_code = 'CNV' and deleted_flag = '0'.
  • CZ_ITEM_MASTERS and CZ_ITEM_TYPE_PROPERTIES — used in the item-master branch to associate properties defined at the item-type level.

Key Columns

  • prop_id — property identifier from CZ_PROPERTIES.property_id.
  • name — the user-facing property name.
  • ps_node_id — the configuration node the property applies to.
  • data_type — resolved type from CZ_TYPE_RELATIONSHIPS.subject_type via the CNV relationship.
  • mutable_flag — constant '0', indicating the property is not treated as mutable in this projection.
  • collection_flag — constant '0', indicating no collection semantics.
  • property_type — constant '2' across all branches, the discriminator key for this view.
  • viewrev — constant '2006-01-12', the view revision marker.

Common Use Cases and Queries

The view is typically used to enumerate user properties per node for reporting, integrations, or migration extracts. Filtering on property_type confirms the row source, and joining back to CZ_PS_NODES enriches with node metadata.

Enumerate properties for a given node:

SELECT prop_id, name, ps_node_id, data_type, property_type
FROM apps.cz_node_user_properties_v
WHERE ps_node_id = :p_node_id AND property_type = '2';

Group by data type to profile property usage:

SELECT data_type, COUNT(*) FROM apps.cz_node_user_properties_v GROUP BY data_type;

Because all branches enforce deleted_flag = '0' on the underlying tables, the view inherently excludes logically deleted properties, nodes, values, and relationships, making it safe for operational reporting without additional soft-delete predicates.