Results for “cz_constr_attr_right_v”

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

Overview

CZ_CONSTR_ATTR_RIGHT_V is a Bills of Material (BOM) module view in Oracle EBS 12.1.1 and 12.2.2 that exposes the right-hand side (RHS) of constraint clauses used by Oracle's constraint-based configuration and configuration rule engine. In constraint expressions of the form left-hand attribute operator right-hand attribute/value, this view materializes the right-hand operand together with the clause definition, the constraint assignment, the affected inventory item, and the resolved attribute value. Its ETRM description — "Right hand side of constraint clauses" — confirms that its purpose is to provide a queryable, denormalized projection of constraint clause operands for reporting and integration, rather than to store data itself.

Because the view joins configuration-modeling tables (CZ_CONSTRAINT_CLAUSES, CZ_CONSTRAINT_ASSIGNMENTS) with attribute-value tables (AK_ATTRIBUTES_VL, AK_INST_ATTRIBUTE_VALUES, AK_OBJECT_ATTRIBUTES) and item master and BOM explosion data, it functions as a bridge between constraint metadata and the concrete item/BOM context in which a constraint applies. This makes it useful for configuration validation, rule-impact analysis, and diagnostics.

Underlying Base Objects

The ETRM metadata for 12.2.2 documents no referenced base objects, and the same source records "Not implemented in this database." The view text, however, reveals the underlying objects joined to produce the RHS projection:

• CZ_CONSTRAINT_CLAUSES (CCC) — supplies CLAUSE_ID, NAME, ATTRIBUTE_CODE2, and DB_OBJECT_NAME2.
• CZ_CONSTRAINT_ASSIGNMENTS (CCA) — supplies assignment, constraint, inventory item, organization, and effectivity/disable dates.
• AK_OBJECT_ATTRIBUTES (AOA) — maps the attribute code to an application ID and database object name.
• AK_ATTRIBUTES_VL (AAV) — provides the RHS attribute name, description, and data type.
• AK_INST_ATTRIBUTE_VALUES (AIAV) — supplies the actual value, decoded by data type into VALUE_VARCHAR2, VALUE_NUMBER, or VALUE_DATE.
• MTL_SYSTEM_ITEMS_KFV (MSI) — item concatenated segments and description.
• BOM_BILL_OF_MATERIALS (BOM) and BOM_EXPLOSIONS (BE) — assembly items, optional explosion types, and effectivity windows.

Key Columns

• ASSIGNMENT_ID, CONSTRAINT_ID, CLAUSE_ID — identifiers of the constraint assignment and clause.
• CLAUSE_NAME, RHS_ATTRIBUTE_CODE, RHS_ATTRIBUTE_NAME, RHS_ATTRIBUTE_DESCRIPTION — the right-hand clause attribute definition.
• RHS_ATTRIBUTE_VALUE — DECODE over AK_INST_ATTRIBUTE_VALUES, resolving VARCHAR2, NUMBER, or DATE values.
• ASSIGNMENT_ITEM_ID, ORGANIZATION_ID, ITEM_ID, ITEM_NAME, ITEM_DESCRIPTION — the item/BOM context.
• EFFECTIVITY_DATE, DISABLE_DATE, SORT_ORDER — temporal and ordering metadata.

Common Use Cases and Queries

Typical usage includes auditing the right-hand operands of configuration constraints on a specific assembly, verifying attribute values feeding BOM option validity, and reconciling configuration rules against item masters.

SELECT CONSTRAINT_ID,
       CLAUSE_NAME,
       RHS_ATTRIBUTE_CODE,
       RHS_ATTRIBUTE_VALUE,
       ITEM_NAME,
       EFFECTIVITY_DATE
  FROM CZ_CONSTR_ATTR_RIGHT_V
 WHERE ORGANIZATION_ID = :org_id
 ORDER BY CONSTRAINT_ID, SORT_ORDER;

Because the view is not implemented in every database — as recorded in the ETRM metadata — its availability depends on whether Oracle Configurator / constraint modeling is installed and licensed for the instance. Where present, it serves as a read-only reporting interface over the clause assignment model.