Results for “long_label”

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

Overview

CZFV_CONFIG_REGION_ATTRIBUTES is a read-only Oracle EBS view that belongs to the Bills of Material (BOM) product family and is classified in the ETRM metadata as "Retrofitted." In Oracle EBS 12.1.1 and 12.2.2 it exposes configuration region attributes drawn from the Oracle Application Framework (OAF) / AK (Application Knowledge) repository, presenting each region item together with its region, attribute name, owning application, display sequencing, label, and required-flag metadata. The view is defined WITH READ ONLY, confirming it is intended purely for querying and reporting rather than for DML operations.

The user search term "region_application_name" corresponds directly to the REGION_APPLICATION_NAME column, which is populated by joining AK_REGION_ITEMS to FND_APPLICATION_VL (alias AP1) on REGION_APPLICATION_ID. This column identifies the application that owns the configuration region, an important dimension when filtering region attributes by owning module. The view is frequently used as a look-up source for configuration/attribute metadata in BOM configuration and extensibility contexts.

Underlying Base Objects

Although the ETRM metadata records "no documented base objects" and notes "Not implemented in this database," the documented view text reveals the actual defining query. The view is built over the following base objects:

• AK_REGION_ITEMS (alias REIT) — the driving table holding region/attribute membership and sequence data.
• AK_REGION_ITEMS_TL (RETL) — the translation table supplying language-specific attribute labels; joined on LANGUAGE = USERENV('LANG').
• AK_REGIONS_VL (RE) — supplies the region name.
• AK_ATTRIBUTES_VL (AT) — supplies the attribute name.
• FND_APPLICATION_VL (AP1 and AP2) — supplies the region and attribute application names respectively.

The joins enforce both REGION_APPLICATION_ID = 702 and ATTRIBUTE_APPLICATION_ID = 702, restricting output to the BOM application context. The metadata also records a "_DF" derived column referencing AK_REGION_ITEMS.

Key Columns

• REGION_ID / REGION_NAME — identifier and descriptive name of the configuration region.
• REGION_APPLICATION_NAME — the application owning the region (from AP1); the column matching the user's search.
• ATTRIBUTE_ID / ATTRIBUTE_NAME — identifier and name of the region attribute.
• ATTRIBUTE_APPLICATION_NAME — owning application of the attribute (from AP2).
• SEQUENCE / DISPLAY_LENGTH — display order and value length for the attribute.
• "_LA:REQUIRED_FLAG" — a derived look-up column resolving REQUIRED_FLAG via FND_LOOKUPS (YES_NO).
• LONG_LABEL / LABEL_LENGTH — the translated long attribute label and its length.
• REGION_APPLICATION_ID / ATTRIBUTE_APPLICATION_ID — numeric application identifiers.
• CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

Typical scenarios include reporting on configuration region attributes for BOM, validating attribute labels and required flags, and integration extracts that map region attributes to owning applications. Because the view already filters to application 702, results are scoped to BOM.

Sample query listing region attributes and their applications:

• SELECT REGION_NAME, REGION_APPLICATION_NAME, ATTRIBUTE_NAME, ATTRIBUTE_APPLICATION_NAME, SEQUENCE, LONG_LABEL FROM CZFV_CONFIG_REGION_ATTRIBUTES ORDER BY REGION_NAME, SEQUENCE;

Filtering by the searched term:

• SELECT REGION_NAME, ATTRIBUTE_NAME FROM CZFV_CONFIG_REGION_ATTRIBUTES WHERE REGION_APPLICATION_NAME = 'Bills of Material';

Because implementation status is recorded as "Not implemented in this database," deployments should confirm the view's existence before relying on it in reports.