Search Results default_format_flag

Overview

WMS_LABEL_FORMATS_V is a VALID Oracle EBS view owned by the APPS schema within the WMS (Warehouse Management) product. It is documented in ETRM for both Oracle EBS 12.1.1 and 12.2.2. The view is a single-table projection over WMS_LABEL_FORMATS and serves as the base query block for the LABELS_FORMATS block in the Oracle Forms-based label administration UI, WMSLABEL.fmb (starting at version 115.3), where it replaces the older WMS_LABEL_V view. Because the object is a view rather than a table, it exposes underlying label-format configuration rows for query and reporting without providing an independent storage structure.

Underlying Base Objects

The documented base object for this view is the synonym WMS_LABEL_FORMATS, which resolves in APPS to the label format definition table. The view text selects from that table using the alias WLF and projects its columns with no joins or unions, confirming a direct, one-to-one passthrough mapping. The row identifier is exposed as ROW_ID, obtained from WLF.ROWID, and all other columns are direct projections of the underlying table columns. Consequently, any DML or read against the view is governed entirely by the base table and by APPS-level grants on both the synonym and the view.

Key Columns

• LABEL_FORMAT_ID — Primary identifier for each label format definition.
• LABEL_FORMAT_NAME — User-facing name of the label format shown in the LABELS_FORMATS block.
• FORMAT_DESCRIPTION — Descriptive text for the format.
• FORMAT_DISABLE_DATE — Date on which the format becomes inactive.
• DEFAULT_FORMAT_FLAG — Indicates whether the format is the default for its context.
• DOCUMENT_ID — Reference to the associated document definition used by the label.
• FILTER_VALUE — The filter value associated with the label format, relevant to the user's search term and used to constrain which records the format applies to, particularly in EPC and label rule processing.
• GENERATE_EPC — Flag indicating whether Electronic Product Code generation is enabled for the format.
• EPC_RULE_TYPE — Rule type governing how the EPC value is derived.
• EPC_CATEGORY_ID — Identifier of the EPC category associated with the format.
• LABEL_ENTITY_TYPE — Entity type against which the label format operates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield context and segment columns carried through from the base table.
• Audit and concurrency columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include validating label format setup, extracting active formats for integration with label printing or WMS device interfaces, and auditing the EPC and filter configuration tied to each format. A common example filters on FILTER_VALUE, matching the user's search term, and on the default flag or disable date:

• Active formats: SELECT label_format_id, label_format_name, filter_value, default_format_flag FROM wms_label_formats_v WHERE format_disable_date IS NULL OR format_disable_date > SYSDATE;
• Filtered lookup: SELECT label_format_id, label_format_name, filter_value FROM wms_label_formats_v WHERE filter_value = :filter_value;
• Default and EPC-enabled formats: SELECT label_format_id, label_format_name, epc_rule_type, epc_category_id FROM wms_label_formats_v WHERE default_format_flag = 'Y' AND generate_epc = 'Y';

All queries should be executed against the APPS schema or a synonym with appropriate privileges, and results should respect the audit columns for change tracking.