Results for “czfv_config_system_types”

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

Overview

CZFV_CONFIG_SYSTEM_TYPES is a Bills of Material (BOM) configuration view that exposes Oracle EBS common lookup data for the CZ_SYSTEM_TYPES lookup type. It is documented in ETRM as "Retrofitted," indicating it is a compatibility object that mirrors an earlier forms-based construct rather than a purely new 12.1.1/12.2.2 entity. The view presents configuration system types — the classification used by Oracle Configurator / configured items to distinguish the basis on which a configurable model or option is defined (for example, model, option class, or system type) — together with the descriptive metadata maintained against the underlying lookup values.

Functionally, the view acts as a reporting and integration surface over FND_LOOKUPS and FND_COMMON_LOOKUPS data limited to a single lookup type (CZ_SYSTEM_TYPES) and a single view application (VIEW_APPLICATION_ID = 3). It carries the standard descriptive-flexfield (_DF) pointer and label-association (_LA) pointer columns that the ETRM dictionary exposes for common lookup views, allowing applications to resolve the source table and the meaning of the ENABLED_FLAG. ETRM records no implementation in the source database and documents no referenced base objects, so the view should be treated as a read-only reporting convenience whose definition is authoritative only as published.

Underlying Base Objects

The published view text defines the view over three dictionary objects:

• FND_COMMON_LOOKUP_TYPES COTY — supplies the lookup type definition, restricted by COTY.APPLICATION_ID = 702.
• FND_APPLICATION_VL AP — supplies APPLICATION_NAME, joined on CO.VIEW_APPLICATION_ID = AP.APPLICATION_ID.
• FND_LOOKUP_VALUES CO — supplies the actual lookup codes, meanings, descriptions, and effective dates, filtered to LOOKUP_TYPE = 'CZ_SYSTEM_TYPES', VIEW_APPLICATION_ID = 3, and the session language.

Language and security-group predicates are applied: CO.LANGUAGE = USERENV('LANG'), and SECURITY_GROUP_ID is resolved through a subquery over FND_LOOKUP_TYPES that admits group 0 or the group derived from the CLIENT_INFO session context. The view is declared WITH READ ONLY. ETRM documents no other base objects.

Key Columns

• APPLICATION_NAME — application owning the lookup, resolved from FND_APPLICATION_VL.
• TYPE / TYPE_DESCRIPTION — the lookup type and its meaning (CZ_SYSTEM_TYPES).
• CODE / MEANING — the lookup code and its user-facing meaning; these are the values consumed by Configurator logic.
• _LA:ENABLED_FLAG — label-association column resolving ENABLED_FLAG against FND_LOOKUPS YES_NO meanings.
• DESCRIPTION — free-text description of the lookup value.
• START_EFFECTIVE_DATE / END_EFFECTIVE_DATE — activation window derived from START_DATE_ACTIVE and END_DATE_ACTIVE.
• APPLICATION_ID — the view application identifier (3).
• _DF — descriptive-flexfield pointer identifying FND:FND_COMMON_LOOKUPS:CO.
• CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

Typical uses include validating configured-item system types during BOM/configurator reporting, driving value lists in extensions, and auditing lookup changes. A basic query is:

• SELECT code, meaning, description, start_effective_date, end_effective_date FROM czfv_config_system_types WHERE enabled_flag = 'Y' ORDER BY meaning;
• SELECT meaning FROM czfv_config_system_types WHERE code = :b_code;
• SELECT code, meaning, last_updated_by, last_updated_date FROM czfv_config_system_types;

Because ETRM documents the view as retrofitted and not implemented in the base database, verify availability against the target instance before embedding it in custom code, and prefer the underlying FND_LOOKUP_VALUES query for portability when the object is absent.