Results for “set_desc”

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

Overview

WMS_LABEL_SET_FORMATS_V is an APPS-owned database view in the Oracle E-Business Suite Warehouse Management (WMS) module. It presents denormalized information describing the relationship between label sets and the individual label formats that belong to them, together with the descriptive names of both the set and the format. In the Oracle EBS 12.1.1 and 12.2.2 data models, label definitions are stored across WMS_LABEL_FORMATS and the association table WMS_LABEL_SET_FORMATS; this view joins those objects so that report writers, integrations, and extensions can resolve set-to-format membership without re-implementing the join logic. The view is registered as VALID in the ETRM metadata and is documented as storing "information about set and format." Because it exposes both SET_ID/FORMAT_ID identifier pairs and their human-readable names, it is frequently the object referenced when a user searches for label_format_name in the context of WMS label configuration.

Underlying Base Objects

The ETRM 12.2.2 metadata documents two referenced base objects, both exposed through synonyms: WMS_LABEL_FORMATS and WMS_LABEL_SET_FORMATS. The view text selects from WMS_LABEL_SET_FORMATS (aliased WLSF) joined twice to WMS_LABEL_FORMATS — once as WLF1 to resolve the set header and once as WLF2 to resolve the member format. The join predicates are:

• WLSF.FORMAT_ID = WLF2.LABEL_FORMAT_ID AND NVL(WLF2.LABEL_ENTITY_TYPE, 0) = 0 (the member is a format-level entity)
• WLSF.SET_ID = WLF1.LABEL_FORMAT_ID AND WLF1.LABEL_ENTITY_TYPE = 1 (the parent is a set-level entity)

The view therefore inherits the association rows from WMS_LABEL_SET_FORMATS and enriches them with descriptive attributes from WMS_LABEL_FORMATS. ROWID is carried through as ROW_ID to provide a stable row handle for the underlying association record.

Key Columns

• ROW_ID — ROWID of the WMS_LABEL_SET_FORMATS row, usable as a unique row identifier.
• SET_ID — LABEL_FORMAT_ID of the parent label set (WLF1).
• FORMAT_ID — LABEL_FORMAT_ID of the member label format (WLF2).
• SET_DOCUMENT_ID — WLF1.DOCUMENT_ID, the document identifier associated with the set.
• LABEL_SET_NAME — WLF1.LABEL_FORMAT_NAME; the name of the label set.
• SET_DESC — WLF1.FORMAT_DESCRIPTION; description of the set.
• LABEL_FORMAT_NAME — WLF2.LABEL_FORMAT_NAME; the name of the individual format. This is the column most often targeted when users search on label_format_name.
• FORMAT_DESC — WLF2.FORMAT_DESCRIPTION; description of the member format.
• DISABLE_DATE — date on which the set/format association is disabled.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include validating label set composition before printing or shipping, building custom label administration reports, and migrating label configuration between environments. A representative query listing all formats in non-disabled sets is:

• SELECT LABEL_SET_NAME, LABEL_FORMAT_NAME, FORMAT_DESC, DISABLE_DATE FROM APPS.WMS_LABEL_SET_FORMATS_V WHERE DISABLE_DATE IS NULL ORDER BY LABEL_SET_NAME, LABEL_FORMAT_NAME;
• SELECT SET_ID, FORMAT_ID, LABEL_FORMAT_NAME FROM APPS.WMS_LABEL_SET_FORMATS_V WHERE LABEL_FORMAT_NAME = :p_format_name;
• SELECT DISTINCT LABEL_SET_NAME FROM APPS.WMS_LABEL_SET_FORMATS_V WHERE FORMAT_ID = :p_format_id AND DISABLE_DATE IS NULL;

Because the view filters on LABEL_ENTITY_TYPE values (0 for formats, 1 for sets), it returns only valid set-to-format pairings and excludes unrelated label entity rows in WMS_LABEL_FORMATS. Report authors should still apply their own DISABLE_DATE filter to exclude retired associations.