Search Results rule_type_description




Overview
Explore in AI Chat

Overview

APPS.CZ_PSNODE_REFRULE_IMAGES_V is a reporting and integration view within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Oracle Configurator and Oracle Advanced Product Catalog schema. It exposes configuration rule definitions from the model structure (PS node rules) joined with the imagery, labels, and descriptive text associated with rule types. The view is designed to present presentation-layer metadata — icons, alternate text, and human-readable labels — alongside the technical definitions of rules attached to nodes in a configuration model.

The view is particularly relevant when applications or reports require a descriptive representation of rule types rather than internal numeric codes. The column rule_type_description is derived from RIMG.ALT_TEXT aliased as RULE_TYPE_DESCRIPTION, mapping an image record's alternate text to a rule type so that user-facing text can be surfaced for a given rule node. This makes the view useful for documentation, catalog rendering, and rule auditing interfaces.

Underlying Base Objects

The view is defined over two principal sources: CZ_PSNODE_RULE_REFS_V (aliased P2RUL) and CZ_RULETYPE_IMAGES_V (aliased RIMG). The join is an outer join on two image-selection criteria: rimg.referenced_usage_flag(+) = P2RUL.REFERENCED_RULE_FLAG and rimg.entity_code(+) = P2RUL.detailed_rule_type. This ensures rule rows are preserved even where no matching image record exists.

The documented dependencies include CZ_EFFECTIVITY_SETS (synonym), CZ_PSNODE_RULE_REFS_V (view), CZ_RULETYPE_IMAGES_V (view), and the CZ_UTILS and FND_PROFILE packages, which are used for effectivity and profile-option handling in configuration contexts. The union-all structure suggests a second branch supplies additional rule rows (annotation or component-attached rules) sharing the same column projection. Effects are governed by the effective_from and effective_until ranges, with EFFECTIVITY_FILTER set to 'N' in the exposed query branch.

Key Columns

Common Use Cases and Queries

A typical use is to retrieve user-facing descriptions for rule types attached to nodes, which is where the rule_type_description column is most valuable:

SELECT ps_node_name, rule_name, rule_type,
       rule_type_code, rule_type_label, rule_type_description
FROM   apps.cz_psnode_refrule_images_v
WHERE  model_id = :p_model_id
ORDER BY seq_nbr;

Another scenario lists rules with their associated images for catalog rendering:

SELECT rule_id, rule_name, image_file, full_image_path
FROM   apps.cz_psnode_refrule_images_v
WHERE  referenced_rule_flag = 'Y'
AND    effective_from <= SYSDATE;

The view also supports effectivity and audit reporting, filtering on effective_until or invalid_flag, and is commonly queried through CZ_UTILS profile context to honor the active operating unit or configuration context. Because the view aliases multiple source columns to consumer-friendly names, it is well suited as a foundation for custom reports, OAF/ADF pages, and integration extracts that require both technical rule identifiers and descriptive imagery metadata.