Search Results level_value_id

Overview

The WMS_BFLOW_LABEL_TYPE table is a core configuration table within the Oracle E-Business Suite Warehouse Management (WMS) module. It functions as a mapping table that establishes a mandatory relationship between specific business flows and the types of labels that can be printed during those operations. This relationship is essential for enabling automated label printing from key warehouse processes such as receipt, inspection, and cross-docking. Without a defined entry in this table for a given business flow, label generation for that process will not occur, making it a critical component for warehouse labeling and compliance.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each valid business flow-to-label type mapping. The key columns are:

• BUSINESS_FLOW_CODE: Identifies the specific warehouse process (e.g., receipt, inspection).
• DOCUMENT_ID: References the specific document or transaction type within the business flow.
• LEVEL_TYPE_CODE: Defines the categorization or context level for the label mapping.
• LEVEL_VALUE_ID: A critical identifier that provides the specific value for the given LEVEL_TYPE_CODE. This field is central to the user's search and acts as the precise point of application for the label rule, such as a specific organization, subinventory, locator, or item identifier.

Together, these columns configure precisely when and where a particular label type is applicable during transactional execution.

Common Use Cases and Queries

A primary use case is troubleshooting label printing failures. If labels are not generating for a receiving transaction, a consultant would verify a configuration exists in this table for the relevant business flow. A typical diagnostic query would join to label definition tables:

• Finding configured label types for a business flow: SELECT * FROM wms_bflow_label_type WHERE business_flow_code = 'RECEIPT';
• Validating configuration for a specific item and organization: SELECT bflt.* FROM wms_bflow_label_type bflt WHERE bflt.level_type_code = 'ITEM' AND bflt.level_value_id = <item_id>;

Reporting often involves joining this table to WMS_LABEL_TYPES_B to list all enabled label types per process, which is vital for audit and setup verification.

Related Objects

The table's primary key defines its relationships. It is heavily referenced by labeling engine APIs and likely by internal WMS packages that determine label eligibility at runtime. While the provided metadata does not list explicit foreign keys, the LEVEL_VALUE_ID column typically joins to various dimension tables based on the LEVEL_TYPE_CODE. For example, if the level type is 'ORGANIZATION', the LEVEL_VALUE_ID would correspond to ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_ID. The table is central to the label configuration subsystem and is a prerequisite for the WMS_LABEL_PUB and related printing APIs.