Results for “wms_label_fields_vl”

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

Overview

WMS_LABEL_FIELDS_VL is a multilingual (MLS) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It represents the MLS database entity WMS_LABEL_FIELDS and belongs to the Warehouse Management (WMS) product family. The view provides a language-resolved, read-oriented projection of warehouse label field definitions, allowing label fields configured against a label document to be queried in the session's current language without the caller having to join the translation table manually. The trailing "_VL" suffix denotes a "view with language" — a standard EBS construct that masks the underlying _B (base) and _TL (translation) table pair. This makes the view particularly relevant to users searching for field_description, since the descriptive text for a label field is sourced from the translation table and surfaced through the FIELD_DESCRIPTION column.

Underlying Base Objects

The view is defined over two documented base objects, both exposed to APPS as synonyms: WMS_LABEL_FIELDS_B, which holds language-independent attributes, and WMS_LABEL_FIELDS_TL, which holds translatable text. The join condition is B.LABEL_FIELD_ID = T.LABEL_FIELD_ID AND T.LANGUAGE = USERENV('LANG'), so each row returned corresponds to the current runtime language. The view text selects B.ROWID as ROW_ID plus all significant columns from the base table and the two translated columns (FIELD_NAME and FIELD_DESCRIPTION) from the translation table. Because it is a view rather than a table, it carries no independent storage and no Who columns of its own beyond those projected from WMS_LABEL_FIELDS_B; it is not directly updatable through the standard MLS view mechanism, and DML should be directed at the base tables or their supported APIs.

Key Columns

• LABEL_FIELD_ID — Primary key linking a label field definition to its translated text; the join key between _B and _TL.
• DOCUMENT_ID — Identifier of the label document to which the field belongs.
• COLUMN_NAME — The underlying database column from which the label field derives its value.
• FIELD_NAME — Translated short name of the label field (from WMS_LABEL_FIELDS_TL).
• FIELD_DESCRIPTION — Translated descriptive text for the label field; this is the column users seek when searching for "field_description."
• SQL_STMT — The SQL statement associated with the label field, supporting dynamic field resolution.
• WMS_EXCLUSIVE — Flag indicating the field is exclusive to Warehouse Management.
• FIELD_LIST_UPDATED_FLAG — Indicator that the field list has changed since last processing.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Descriptive flexfield (DFF) columns available for customer extensions.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and the concurrent program columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include building label-printing reports, validating label field configuration against a document, extracting descriptive text for localization review, and integrating warehouse label metadata into external barcode or print systems. A representative query retrieving field descriptions for a given document is:

• SELECT label_field_id, column_name, field_name, field_description FROM apps.wms_label_fields_vl WHERE document_id = :p_document_id ORDER BY field_name;
• SELECT label_field_id, field_description FROM apps.wms_label_fields_vl WHERE column_name = 'ITEM_NUMBER';
• SELECT l.label_field_id, l.field_description FROM apps.wms_label_fields_vl l WHERE l.wms_exclusive = 'Y';

Because language resolution depends on USERENV('LANG'), reports should either run in the intended session language or query the underlying _TL table directly when a specific target language must be forced regardless of session context.