Search Results cz_psnode_directprop_info_v




Overview
Explore in AI Chat

Overview

The CZ_PSNODE_DIRECTPROP_INFO_V view is an Oracle E-Business Suite Configurator (CZ) reporting and integration object owned by the APPS schema. It exposes the direct property values attached to a configuration model's product structure nodes (PS nodes), together with translated text values, associated UI imagery, and alternate text derived from the seeded "PRP" (Property) object type. In Oracle EBS 12.1.1 and 12.2.2, the Configurator relies on a network of PS node and property definition tables to drive the runtime configuration engine, and this view serves as a denormalized, read-only projection of that model metadata. Its principal role is to present property information in a form suitable for external consumption — whether by reports, integration interfaces, or custom API extensions — where the raw transactional tables would require extensive joins. The view is marked VALID in the ETRM metadata, indicating that its underlying definition compiles cleanly against the referenced objects.

Underlying Base Objects

The view is defined over three referenced views and one synonym, as documented in the ETRM metadata. CZ_PSNODE_PROPVAL_V is the primary source, supplying PS node identifiers, property identifiers, names, data types, values, numeric values, defaults, inherited flags, source application IDs, and original system references. CZ_UI_PATHED_IMAGES_V is joined to provide image file names and full image paths for the property. CZ_RPOBJECTTYPES_LKV supplies the alternate text through its VALUE_DESCRIPTION column and constrains the join to the seeded property object type (DATA_VALUE = 'PRP'). The synonym CZ_INTL_TEXTS is not joined directly in the view text but is used in correlated subqueries to resolve translated text for properties whose DATA_TYPE = 8 (integer-based internationalized text references). The join conditions link the seeded "PRP" object type to the UI image entity, restricted to seeded entries with UI_DEF_ID = 0 and IMAGE_USAGE_CODE = 30, ensuring that only the canonical property image is returned.

Key Columns

The view exposes a comprehensive set of configuration metadata columns. Identity and structure columns include PS_NODE_ID, PS_NODE_NAME, PROPERTY_ID, PROPERTY_NAME, and PS_NODE_TYPE. Value-related columns include DATA_TYPE, PROPERTY_VALUE, PROPERTY_NUM_VALUE, DEFAULT_VALUE, and DEF_NUM_VALUE. Translation columns TRANSLATED_TEXT and DEF_TRANSLATED_TEXT resolve internationalized text strings from CZ_INTL_TEXTS when the property data type is 8. Imagery columns IMAGE_FILE, FULL_IMAGE_PATH, and ALT_TEXT support UI rendering. Context columns ITEM_ID, ITEM_TYPE_ID, PROP_ATTACHES, ORIG_SYS_REF, VALUE_ORIG_SYS_REF, PROPERTY_ORIG_SYS_REF, INHERITED_FLAG, and SRC_APPLICATION_ID provide integration and inheritance tracing, which is essential when reconciling configuration data imported from external systems.

Common Use Cases and Queries

Typical uses include auditing property definitions across a model, extracting translation-ready property data for localization, and building integration extracts that map Configurator properties to external catalogs. A representative query lists all properties for a given node:

  • SELECT PS_NODE_NAME, PROPERTY_NAME, DATA_TYPE, PROPERTY_VALUE, TRANSLATED_TEXT, ALT_TEXT FROM CZ_PSNODE_DIRECTPROP_INFO_V WHERE PS_NODE_ID = :p_node_id;
  • SELECT PS_NODE_NAME, PROPERTY_NAME, PROPERTY_VALUE, DEF_TRANSLATED_TEXT FROM CZ_PSNODE_DIRECTPROP_INFO_V WHERE INHERITED_FLAG = 'Y';
  • SELECT PS_NODE_NAME, PROPERTY_NAME, IMAGE_FILE, FULL_IMAGE_PATH FROM CZ_PSNODE_DIRECTPROP_INFO_V WHERE IMAGE_FILE IS NOT NULL;

Because the view is read-only and pre-joins the international text and image lookups, it is well suited for concurrent program data sources and BI Publisher reports where direct table access would be inefficient. For 12.1.1 and 12.2.2, the definition is consistent, though customers should validate that seeded "PRP" object type rows exist in CZ_RPOBJECTTYPES_LKV to avoid empty result sets.