Results for “cz_psnode_refrule_images_v”

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

Overview

CZ_PSNODE_REFRULE_IMAGES_V is a reporting view owned by the APPS schema within the Oracle EBS Configurator product (CZ). It is defined over two other Configurator views — CZ_PSNODE_RULE_REFS_V and CZ_RULETYPE_IMAGES_V — and is designed to expose the presentation metadata (icons, images, labels, and alternative text) associated with rule types and rule references in a Configurator model structure. In effect, the view joins the rule-reference explosion of a model's product structure nodes with the image registry that describes how each rule type should be rendered in a Configurator runtime or modeling UI. It is a read-only, VALID object in the 12.1.1 / 12.2.2 code lines and carries no data of its own beyond what the contributing views supply.

Underlying Base Objects

ETRM metadata lists the following referenced base objects:

• CZ_EFFECTIVITY_SETS (SYNONYM) — provides effectivity set context used by the rules being resolved.
• CZ_PSNODE_RULE_REFS_V (VIEW) — the driving view, aliased P2RUL, which supplies the product-structure node, rule, and rule-reference columns (MODEL_ID, PS_NODE_ID, RULE_ID, RULE_NAME, RULE_TYPE, DETAILED_RULE_TYPE, and the many effectivity and message attributes).
• CZ_RULETYPE_IMAGES_V (VIEW) — aliased RIMG, providing IMAGE_USAGE_CODE, ENTITY_CODE, REFERENCED_USAGE_FLAG, IMAGE_FILE, FULL_IMAGE_PATH, DATA_VALUE, VALUE_LABEL, and ALT_TEXT.
• CZ_UTILS (PACKAGE) and FND_PROFILE (PACKAGE) — utility and profile-option APIs used indirectly by the underlying views.

The primary join is an outer join from P2RUL to RIMG, matching REFERENCED_USAGE_FLAG to REFERENCED_RULE_FLAG and ENTITY_CODE to DETAILED_RULE_TYPE. This means each rule reference row is preserved even when no image definition exists. A UNION clause is present in the view text, indicating a second branch (typically the root or presentation rule set) that feeds the same column projection.

Key Columns

• MODEL_ID, MODEL_REF_EXPL_ID, PS_NODE_ID, PARENT_ID, PS_NODE_NAME — identity and hierarchy of the product structure node owning the rule.
• RULE_ID, RULE_NAME, RULE_TYPE, DETAILED_RULE_TYPE, RULE_TEXT, RULE_FOLDER_ID, RULE_FOLDER_TYPE — the rule definition and its classification.
• RULETYPE_DATATYPE and EXPR_ROOT_RULE_TEMPLATE_ID — DECODE-derived columns that normalize rule type and presentation flag into a datatype/template identifier.
• IMAGE_USAGE_CODE, ENTITY_CODE, IMAGE_FILE, FULL_IMAGE_PATH — the icon/image location used to render the rule type.
• DATA_VALUE, VALUE_LABEL, ALT_TEXT — the code value, user-facing label, and accessibility/alternative text for the image.
• RULE_TYPE_CODE, RULE_TYPE_LABEL, RULE_TYPE_DESCRIPTION — aliases of the image columns exposed specifically for rule-type rendering.
• DISABLED_FLAG, REFERENCED_RULE_FLAG, EFFECTIVE_FROM, EFFECTIVE_UNTIL, EFFECTIVE_USAGE_MASK, EFFECTIVITY_SET_ID, EFFECTIVITY_FILTER — status and effectivity context for filtering active rules.
• SEEDED_FLAG, INVALID_FLAG, MUTABLE_FLAG, PRESENTATION_FLAG, TEMPLATE_PRIMITIVE_FLAG — governance and template attributes.

Common Use Cases and Queries

The view is typically used when generating Configurator model documentation or UI metadata that must pair each rule with its icon and label. A common pattern is to enumerate all rule references for a given model and resolve their images:

SELECT RULE_ID, RULE_NAME, RULE_TYPE, RULETYPE_DATATYPE, RULE_TYPE_LABEL, IMAGE_FILE, ALT_TEXT FROM CZ_PSNODE_REFRULE_IMAGES_V WHERE MODEL_ID = :model_id AND NVL(DISABLED_FLAG,'N') = 'N' AND EFFECTIVITY_FILTER = 'N';

Because the image side is an outer join, reporting must apply NVL or LEFT-JOIN semantics when a rule type has no registered icon. A second typical query lists missing images:

SELECT MODEL_ID, PS_NODE_ID, RULE_NAME, DETAILED_RULE_TYPE FROM CZ_PSNODE_REFRULE_IMAGES_V WHERE IMAGE_FILE IS NULL;

Querying the underlying base view CZ_PSNODE_RULE_REFS_V takes the view's dependency on the effectivity model into account; therefore filters on EFFECTIVE_FROM/UNTIL and EFFECTIVITY_SET_ID should be applied when retrieving currently effective rules. The absence of any column relating to human figures or artistic drawings means the view is unrelated to the search term that produced this lookup; it deals strictly with graphical rule-type images used by Oracle Configurator.