Search Results cz_localized_texts_vl




Overview
Explore in AI Chat

Overview

CZ_LOCALIZED_TEXTS_VL is a multi-language (ML) view owned by the APPS schema and delivered as part of the Oracle Configurator (CZ) product module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to present a multi-language view of localized texts — the translated UI strings, model captions, page element labels, and related textual content that Configurator stores and renders across different session languages.

The view operates as a language-filtering projection over the base localized texts entity. Rather than requiring callers to explicitly filter on language, the view applies the standard EBS language predicate LANGUAGE = USERENV('LANG'), so any query issued against it automatically returns only those rows whose language matches the language of the current database session. This makes the view the canonical read interface for code, concurrent programs, and integration layers that need to display localized Configurator text appropriate to the logged-in user, without hard-coding a language value.

Because the view is a read-only, denormalized projection of a single base entity, it has no independent storage, no triggers, and no unique index of its own; all transactional behavior is inherited from the underlying table.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: CZ_LOCALIZED_TEXTS, which is exposed to the APPS schema through a synonym. The view definition selects its columns directly from that table, applying column aliasing for the text content column (LOCALIZED_STR is exposed as TEXT_STR) and a WHERE clause restricting rows to the session language. No joins to other tables are present in the documented view text, so the view is a one-to-one, row-preserving projection for the matching language.

  • Base table: CZ_LOCALIZED_TEXTS (accessed via synonym).
  • Filtering predicate: CZ_LOCALIZED_TEXTS.LANGUAGE = USERENV('LANG').
  • Projection: direct column list with the single alias LOCALIZED_STR AS TEXT_STR.
  • Ownership: APPS; status VALID in the documented environment.

Key Columns

The view exposes the following columns, all inherited from CZ_LOCALIZED_TEXTS:

  • INTL_TEXT_ID — primary identifier for the localized text record; the key used to join back to other Configurator entities.
  • TEXT_STR — the localized string itself (source column LOCALIZED_STR), the principal payload of the view.
  • LANGUAGE — the language of the row; constrained to the session language by the view predicate.
  • SOURCE_LANG — the language from which the text was translated, supporting translation lineage.
  • PERSISTENT_INTL_TEXT_ID — stable identifier linking translated variants of the same logical text across languages.
  • ORIG_SYS_REF — reference to the originating external or legacy system, relevant for imported configurations.
  • UI_DEF_ID, UI_PAGE_ID, UI_PAGE_ELEMENT_ID, MODEL_ID — foreign keys identifying the UI definition, UI page, page element, or model to which the text belongs.
  • DELETED_FLAG — soft-delete indicator; rows are logically removed rather than physically purged.
  • SEEDED_FLAG — distinguishes Oracle-seeded content from customer-created content.
  • CHECKOUT_USER — user holding the record in a checked-out state during authoring.
  • EFF_FROM, EFF_TO, EFF_MASK, SECURITY_MASK — date-effectivity and access-control attributes governing row visibility and validity.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include validating that translated Configurator labels exist for the deployment language, auditing seeded versus customer text, and joining localized strings to model or UI structures for reporting. Because the view is language-filtered, callers get session-appropriate results automatically.

Retrieve all localized texts for the current session language:

SELECT INTL_TEXT_ID, TEXT_STR, LANGUAGE, SOURCE_LANG
FROM APPS.CZ_LOCALIZED_TEXTS_VL
WHERE DELETED_FLAG = 'N';

Join localized text to its model context:

SELECT m.model_id, t.INTL_TEXT_ID, t.TEXT_STR
FROM APPS.CZ_LOCALIZED_TEXTS_VL t, APPS.CZ_MODELS m
WHERE t.MODEL_ID = m.model_id
AND t.DELETED_FLAG = 'N';

Identify untranslated or source-language-only records for QA:

SELECT INTL_TEXT_ID, TEXT_STR, SOURCE_LANG
FROM APPS.CZ_LOCALIZED_TEXTS_VL
WHERE LANGUAGE = SOURCE_LANG
AND SEEDED_FLAG = 'Y';

Note that the view cannot be used to read text in a language other than the session language; cross-language extraction requires querying CZ_LOCALIZED_TEXTS directly with an explicit language predicate.