Search Results sys_prop_rettype_name




Overview
Explore in AI Chat

Overview

The view APPS.CZ_SIGNATURE_SYSPROPS_V is a configuration and metadata reporting object within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment. It resides in the APPS schema and is registered under FND Design Data as CZ.CZ_SIGNATURE_SYSPROPS_V with a status of VALID. The view exposes system property assignments linked to signature definitions used by the Oracle Configurator (CZ) product family — specifically the runtime signature and rule engine that governs model behavior, type relationships, and property-driven configuration logic.

In practical terms, the view flattens the relationship between a detailed signature, its associated system property (sys prop), the attached property signature (PROPATTACH_SIGNATURE_ID), the governing rule, and the runtime return type metadata. This makes it a convenient read-only surface for administrators, developers, and integration specialists who must audit how configuration system properties are bound to signatures without traversing the underlying normalized tables. The user's search term, propattach_signature_id, corresponds directly to the PROPATTACH_SIGNATURE_ID column exposed by this view, confirming that the view is the primary documentation source for that identifier.

Underlying Base Objects

The view is defined over the following documented objects, each contributing a distinct facet of the signature and system-property model:

The view is itself referenced by CZ_COMMON_CHILDND_SYSPROPS_V and CZ_NODE_ALL_PROPERTIES_V, indicating it serves as a foundational layer for broader node and property aggregation views.

Key Columns

Common Use Cases and Queries

Typical usage includes auditing signature-to-property bindings, tracing rule assignments, and resolving property-attached signature identifiers during integration or troubleshooting.

To retrieve all system property assignments for a given property-attached signature:

  • SELECT DETAILED_SIGNATURE_NAME, SYS_PROP_NAME, PROPATTACH_SIG_NAME, SYS_PROP_SIGNATURE_NAME, RULE_TYPE_LABEL
  • FROM APPS.CZ_SIGNATURE_SYSPROPS_V
  • WHERE PROPATTACH_SIGNATURE_ID = :p_attach_sig_id;

To enumerate all properties and their rule types for a model:

  • SELECT SYS_PROP_SEQ_NBR, SYS_PROP_NAME, SYS_PROP_TOKEN, RULE_TYPE_CODE
  • FROM APPS.CZ_SIGNATURE_SYSPROPS_V
  • WHERE P_MODEL_ID = :p_model_id
  • ORDER BY SYS_PROP_SEQ_NBR;

Because the view is read-only and defined in the APPS schema, queries should observe standard EBS security and profile-option context, particularly where FND_PROFILE resolution and INSTANCE_SET_FLAG influence the returned rows.