Results for “list_attribute_datatype”
2 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CZFV_CONFIGURATION_ATTRIBUTES is a read-only Oracle E-Business Suite view residing in the Bills of Material (BOM) product module. It exposes configuration attribute definitions used by Oracle's configuration engine, allowing configuration attributes, their associated values, labels, and list-of-values (LOV) region mappings to be queried through a single denormalized interface. The view is documented in ETRM as "Retrofitted," indicating it was introduced or re-pointed to support a later code line while retaining a stable public name for downstream consumers. The metadata explicitly notes "Not implemented in this database," meaning the object may not exist in every environment; its presence depends on whether the BOM/configurator schema components have been deployed. The view carries the Oracle Proprietary, Confidential Information designation, and is declared WITH READ ONLY, so consumers must treat it exclusively as a query surface. Because it joins attribute definitions with translated labels and application names, it serves reporting, data extraction, and integration scenarios that require configuration attribute metadata without navigating the underlying AK (Application Object Library attributes) and FND tables directly.
Underlying Base Objects
The view text is defined over four base objects: FND_APPLICATION_VL, AK_REGIONS_VL, AK_ATTRIBUTES_TL, and AK_ATTRIBUTES. AK_ATTRIBUTES and its translation table AK_ATTRIBUTES_TL are joined on ATTRIBUTE_APPLICATION_ID and ATTRIBUTE_CODE, with the translation restricted to ATTL.LANGUAGE = USERENV('LANG') so labels reflect the session language. FND_APPLICATION_VL supplies the APPLICATION_NAME via APPLICATION_ID. AK_REGIONS_VL supplies region metadata (RE.NAME) through an outer join on LOV_REGION_CODE and LOV_REGION_APPLICATION_ID. The ETRM "Referenced base objects" field lists none documented, but the view text unambiguously identifies these four sources. All joins are anchored to ATTRIBUTE_APPLICATION_ID = 702, the BOM application identifier, and the LOV region association is also constrained to application 702. Notably, the user search term "ak_regions_vl" corresponds directly to one of these underlying objects, confirming the view's dependency on the region value-list table.
Key Columns
- CONFIGURATION_ATTRIBUTE_ID — Surrogate identifier for the configuration attribute.
- APPLICATION_NAME — Owning application name derived from FND_APPLICATION_VL.
- CONFIGURATION_ATTRIBUTE_NAME — The attribute's translated NAME from AK_ATTRIBUTES_TL.
- _LA:DATA_TYPE — Dynamic value-set column (prefixed _LA) populated from AK_LOOKUP_CODES, keyed on DATA_TYPE.
- VALUE_LENGTH — Maximum attribute value length (ATTRIBUTE_VALUE_LENGTH).
- _LA:UPPERCASE_FLAG — Dynamic list column (prefixed _LA) resolving UPPER_CASE_FLAG against FND_LOOKUPS.
- LABEL / LABEL_LENGTH — Display label and its length from ATTRIBUTE_LABEL_LONG/LENGTH.
- DEFAULT_CHARACTER_VALUE / DEFAULT_NUMBER_VALUE — Default values (varchar2 and number variants).
- LIST_ATTRIBUTE_DATATYPE — Region-derived list attribute datatype (RE.NAME).
- _DF — Descriptive flexfield column bound to AK_ATTRIBUTES via the AK:AK_ATTRIBUTES reference.
- ATTRIBUTE_APPLICATION_ID, LOV_REGION_CODE, LOV_REGION_APPLICATION_ID — Owning application and LOV region join keys.
- CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY — Standard audit columns.
Common Use Cases and Queries
Typical usage centers on metadata reconciliation and reporting of configuration attribute definitions. A common pattern extracts attribute names, labels, and data types for auditing or migration:
SELECT configuration_attribute_id,
application_name,
configuration_attribute_name,
value_length,
label
FROM czfv_configuration_attributes
WHERE value_length > 0
ORDER BY configuration_attribute_name;
Another frequent scenario joins the view to AK_REGIONS_VL to verify LOV region wiring for the BOM application:
SELECT c.configuration_attribute_name, c.lov_region_code FROM czfv_configuration_attributes c WHERE c.lov_region_application_id = 702;
Because the view is read-only and constrained to application 702, it is well suited for read-only extracts feeding configuration documentation, upgrade comparisons, and interface validation. Where the object is not implemented in a given database, callers should fall back to querying AK_ATTRIBUTES_TL and AK_REGIONS_VL directly using the same join keys.
-
- Retrofitted
Not implemented in this database·Explore BOM module →
-
- Retrofitted
Not implemented in this database·Explore BOM module →