Search Results rule_type_string




Overview
Explore in AI Chat

Overview

CZ_PSNODE_RULE_REFS_V is a Configurator (CZ) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents the relationships between Product Structure nodes (PS nodes) within an exploded model and the rules that reference or participate in those nodes. The view denormalizes data drawn from the rule definition, rule participant, and exploded model node structures into a single flattened result set that can be queried directly for diagnostics, impact analysis, and custom reporting.

The view is particularly significant because it surfaces the derived column REFERENCED_RULE_FLAG, which indicates whether a given rule is defined within the top-level model context or originates from a different development project. This distinction is central to understanding rule inheritance, model reuse, and rule resolution behavior across nested or referenced models. The companion column RULE_IN_ENCLOSING_MODEL_FLAG provides a related indicator of whether the rule resides in the enclosing model itself. Together these flags allow implementers to distinguish locally authored rules from externally referenced ones without traversing the underlying tables manually.

Because it is a view and not a table, the object is read-only and intended for query access. It is commonly consumed by validation utilities, migration scripts, and diagnostic reports that must reconcile rule-to-node assignments after model changes or during environment promotion.

Underlying Base Objects

The definition of CZ_PSNODE_RULE_REFS_V joins four primary sources: CZ_RULES, CZ_RULE_PARTICIPANTS_V, CZ_EXPLMODEL_NODES_V, and CZ_MODEL_REF_EXPLS. CZ_RULES supplies the rule header attributes, including rule name, type, description, effectivity, and template-related flags. CZ_RULE_PARTICIPANTS_V supplies the participant role list and the linkage between a rule and the model reference node it applies to. CZ_EXPLMODEL_NODES_V supplies the exploded model node structure, including node name, type, parent identifiers, and the development project context. CZ_MODEL_REF_EXPLS provides the model reference explosion records that connect participants to their descendant nodes.

Supporting objects include CZ_DETAILEDRULETYPES_LKV, which resolves the numeric detailed rule type into a descriptive value label; CZ_RULE_FOLDERS, used in a scalar subquery to retrieve the display tree sequence for the rule; and CZ_FUNC_COMP_SPECS, referenced in the view metadata for functional component specification resolution. The CZ_UTILS package is also listed as a dependency for helper logic. The join enforces DELETED_FLAG = '0' on both CZ_RULES and CZ_MODEL_REF_EXPLS, ensuring that logically deleted records are excluded from results.

Key Columns

Common Use Cases and Queries

A frequent task is identifying which rules apply to a product structure node and whether those rules are local or referenced. The following query filters by node and flags referenced rules.

SELECT ps_node_name, rule_name, rule_type_string, referenced_rule_flag FROM cz_psnode_rule_refs_v WHERE ps_node_id = :node_id AND referenced_rule_flag = '1' ORDER BY seq_nbr;

Impact analysis queries count rules per model to assess reuse:

SELECT model_id, COUNT(*) total_rules, SUM(DECODE(referenced_rule_flag,'1',1,0)) referenced_rules FROM cz_psnode_rule_refs_v GROUP BY model_id;

Diagnostic reports commonly filter on disabled_flag = '0' and invalid_flag = '0' to isolate active rule assignments, and join to CZ_RULES for effectivity checks. Because the view exposes both V columns and participant roles, it supports configuration audit reporting without requiring custom joins to the base tables.