Results for “sys_prop_signature_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view APPS.CZ_NODETYPE_SYSPROPS_V is a reporting and integration object within the Oracle Configurator (CZ) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It presents the resolved relationship between configurator node types (detailed types), the system properties that may be attached to those node types, and the signatures that govern property attachment and return typing. In practical terms, the view answers the question: "for a given node type, which system properties exist, what rule drives each property, and what signature governs the value returned by that rule?"

The object is a read-only, denormalized projection assembled from the core Configurator rule, signature, and type-relationship tables. It is not a transactional entity and holds no data of its own; it is intended to be queried by reporting tools, extensions, and diagnostic scripts that need a human-readable inventory of system properties per node type. The user search term propattach_sig_name corresponds directly to a projected column in this view, which exposes the name of the signature that attaches a system property to a node type. This makes the view the natural lookup point for anyone tracing property-attachment signatures.

Underlying Base Objects

The documented base objects referenced by the view are CZ_RULES (synonym), CZ_RULETYPECODES_LKV (view), CZ_SIGNATURES (synonym), and CZ_TYPE_RELATIONSHIPS (synonym). Each plays a distinct role in the join:

• CZ_RULES supplies the system property definitions (aliased PRRUL), including the rule name, rule type, config engine type, and the signature identifier that defines the property's return type.
• CZ_SIGNATURES is referenced four times under distinct aliases: NODSIG (the property-attachment signature, exposed as PROPATTACH_SIG_NAME), SBNTY (the detailed node-type signature), RULSIG (the property's own signature, carrying collection and mutability flags), and RULRET (the return-type signature).
• CZ_TYPE_RELATIONSHIPS is used as SUBND (linking the node type to its object type) and as SYPR (linking the property subject type to the attachment signature).
• CZ_RULETYPECODES_LKV provides the decoded rule-type label and is filtered to the SYS (system) rule type code.

An anti-join (NOT EXISTS) subquery over the same rule, relationship, and node-type tables eliminates duplicate system properties, ensuring that only the canonical, non-duplicated property definition is returned for each node type.

Key Columns

• DETAILED_TYPE_ID / DETAILED_TYPE_NAME — the configurator node type to which properties apply.
• SYS_PROP_NAME — the name of the system property (from CZ_RULES).
• SYS_PROP_SIGNATURE_ID / SYS_PROP_SIGNATURE_NAME — the signature defining the property itself.
• SYS_PROP_RETTYPE_ID / SYS_PROP_RETTYPE_NAME — the return data type of the property value.
• SYS_PROP_RETCOLL_FLAG / SYS_PROP_RETMUTABLE_FLAG — flags indicating whether the returned value is a collection and whether it is mutable.
• PROPATTACH_SIG_NAME — the name of the signature that attaches the property to the node type; this is the columnmost directly associated with the search term propattach_sig_name.
• PROPATTACH_SIGNATURE_ID — the subject-type identifier backing that attachment signature.
• RULE_ID, RULE_TYPE, RULE_TYPE_CODE, RULE_TYPE_LABEL, CONFIG_ENGINE_TYPE — rule metadata used to classify and route the property during configuration.

Common Use Cases and Queries

Typical scenarios include auditing which system properties are exposed on a node type, verifying attachment signatures prior to extending a configuration model, and driving migration or documentation reports. Because the view already resolves signatures to names, it removes the need for manual multi-table joins.

• Find all system properties for a node type by name:
  SELECT sys_prop_name, propattach_sig_name, sys_prop_rettype_name FROM cz_nodetype_sysprops_v WHERE detailed_type_name = 'MyNodeType';
• Locate properties by their attachment signature (directly serving the propattach_sig_name query):
  SELECT detailed_type_name, sys_prop_name, propattach_sig_name FROM cz_nodetype_sysprops_v WHERE propattach_sig_name LIKE '%PROPATTACH%';
• List collection-valued properties only:
  SELECT detailed_type_name, sys_prop_name FROM cz_nodetype_sysprops_v WHERE sys_prop_retcoll_flag = '1';

All queries should be executed in the APPS schema or with appropriate synonym access, respecting the read-only nature of the object.