Results for “czbv_config_region_attributes”

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

Overview

CZBV_CONFIG_REGION_ATTRIBUTES is a Bills of Material (BOM) view in Oracle EBS 12.1.1 and 12.2.2 that exposes configuration region attribute metadata used by Oracle's Configurator and the ETRM (Enterprise Territory and Resource Management, in this context a configuration metadata repository) framework. The view joins attributes and regions defined through the AK (Application Kit) descriptive flexfield metadata model to application names, labels, and display characteristics. Because it is documented as "Retrofitted," the object was reconciled from an earlier release into the current ETRM data model rather than newly designed for 12.2.2. Reporting and integration tools reference this view to enumerate the attributes associated with a configuration region, including the user-facing label, the display sequence, and the required-flag lookup string.

The metadata further states "Not implemented in this database." This indicates that in the specific EBS environment from which the ETRM metadata was extracted, the view is defined in the data dictionary but is not deployed or populated, so results depend on whether the object exists (or is valid) in a given instance. Practitioners should verify deployment status before relying on it.

Underlying Base Objects

The view text selects from five documented base objects:

• AK_REGION_ITEMS (aliased REIT) — the driving table of region-item definitions.
• AK_REGION_ITEMS_TL (aliased RETL) — the translated region-item labels; joined on REGION_APPLICATION_ID, REGION_CODE, ATTRIBUTE_CODE, and ATTRIBUTE_APPLICATION_ID, restricted to RETL.LANGUAGE = USERENV('LANG').
• AK_REGIONS_VL (aliased RE) — region definitions and names.
• AK_ATTRIBUTES_VL (aliased AT) — attribute definitions and names.
• FND_APPLICATION_VL (aliased AP1 and AP2) — resolves the region and attribute application display names.

All joins are restricted to REGION_APPLICATION_ID = 702 and ATTRIBUTE_APPLICATION_ID = 702 (Application ID 702 corresponds to the BOM/Configurator application context). The view is created WITH READ ONLY, so no DML is permitted.

Key Columns

• REGION_ID / REGION_NAME / REGION_APPLICATION_NAME — the region and the display name of its owning application.
• ATTRIBUTE_ID / ATTRIBUTE_NAME / ATTRIBUTE_APPLICATION_NAME — the attribute and its owning application name.
• SEQUENCE — maps to DISPLAY_SEQUENCE, controlling attribute ordering within the region.
• DISPLAY_LENGTH — maps to DISPLAY_VALUE_LENGTH, the rendered width/value length of the attribute. This is the column most relevant to the user's "display_length" search: it governs how much of an attribute value is displayed in the region layout.
• REQUIRED_FLAG (labeled "_LA:...") — a lookup-derived required indicator resolved via FND_LOOKUPS:YES_NO:MEANING.
• LONG_LABEL / LABEL_LENGTH — the translated long label and its length.
• REGION_APPLICATION_ID / ATTRIBUTE_APPLICATION_ID — foreign keys to FND_APPLICATION.
• CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY — audit columns.

Note that the documented column list uses names such as REGION_ID and SEQUENCE, which are aliases applied over the underlying AK_REGION_ITEMS columns.

Common Use Cases and Queries

Typical use cases include auditing region layout, verifying display-length settings, and building integration extracts of configurator metadata.

• List attributes for a region ordered by display sequence: SELECT region_name, attribute_name, sequence FROM CZBV_CONFIG_REGION_ATTRIBUTES ORDER BY region_name, sequence;
• Inspect display length for a specific attribute: SELECT attribute_name, display_length FROM CZBV_CONFIG_REGION_ATTRIBUTES WHERE display_length IS NOT NULL;
• Identify required attributes: SELECT region_name, attribute_name FROM CZBV_CONFIG_REGION_ATTRIBUTES WHERE "_LA:REQUIRED_FLAG" = 'Yes';

Because the view is read-only and may be unimplemented, confirm its existence via ALL_VIEWS and ALL_TAB_COLUMNS before embedding it in reports.