Search Results wms_rule_allocation_mode

Overview

APPS.WMS_RULES_V is a Warehouse Management System (WMS) reporting and integration view that presents rule definitions used by the Oracle Warehouse Management rule engine in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The view consolidates rule headers, their associated input quantity-function parameters, WMS object references, lookup-derived meanings, and rule weighting attributes into a single flattened structure. It exposes organization-scoped and global (common-to-all-organizations) rules, allowing planners, developers, and integration architects to query rule configuration without navigating the normalized underlying tables directly.

The view is central to the query term wms_rule_allocation_mode, since it joins to MFG_LOOKUPS on the lookup type WMS_RULE_ALLOCATION_MODE. This lookup determines how inventory is allocated when a rule executes. Because the view applies nvl(wrvl.allocation_mode_id, 4), a null allocation mode is coerced to lookup code 4, ensuring every returned row carries an effective allocation mode value. A second join to MFG_LOOKUPS constrains results to WMS_ACTION_TYPE lookup code 2, so the view is effectively scoped to allocation-type rules.

Underlying Base Objects

The view draws from the following documented base objects:

• WMS_RULES_VL — the primary source, supplying rule identity, organization, type, name, description, weight, enabled flag, and descriptive flexfield attributes.
• WMS_PARAMETERS_VL — supplies the parameter name, description, and object linkage for the rule's quantity function input.
• WMS_OBJECTS_VL — provides the object name and description associated with the parameter.
• MFG_LOOKUPS — a view over lookup data, joined twice: once for TYPE_CODE meaning against WMS_ACTION_TYPE, and once for the allocation mode against WMS_RULE_ALLOCATION_MODE.
• WMS_PARAMETER_PVT — a package whose GetFlexName function resolves the flexfield-aware display name of the parameter.

Additional referenced objects such as BOM_STANDARD_OPERATIONS, CST_COST_GROUPS, WMS_LABEL_FORMATS, and WMS_OP_PLANS_VL are synonyms and views in the WMS schema lineage that support the package call and downstream union logic. The view applies a UNION across these sources and filters with nvl(wrvl.wms_enabled_flag,'Y') = 'Y', excluding disabled rules.

Key Columns

• ROW_ID / RULE_ID — unique row identifier and the logical rule identifier.
• ORGANIZATION_ID — owning organization; value -1 signals a global rule.
• COMMON_TO_ALL_ORGS_FLAG — derived as 'Y' when organization_id is -1.
• TYPE_CODE / MEANING — rule action type from WMS_ACTION_TYPE.
• NAME / DESCRIPTION — rule name and description.
• QTY_FUNCTION_PARAMETER_ID and the resolved GetFlexName value — the quantity function parameter and its display label.
• ENABLED_FLAG / USER_DEFINED_FLAG — status and provenance of the rule.
• RULE_WEIGHT — priority weighting used during rule evaluation.
• MIN_PICK_TASKS_FLAG — indicates the minimum-pick-tasks behavior.
• ALLOCATION_MODE_ID / ALLOCATION_MODE — the resolved allocation mode and its lookup meaning.
• ATTRIBUTE1–15 / ATTRIBUTE_CATEGORY — descriptive flexfield columns.
• Activity and plan columns — activity_type_id, activity_type_name, plan_type_id, and plan_type_name, populated by the union branch.

Common Use Cases and Queries

Typical scenarios include auditing allocation-mode adoption, reporting enabled rules per organization, and joining rule definitions into integration extracts. A representative query that inspects allocation modes across all organizations is:

SELECT rule_id, name, organization_id, common_to_all_orgs_flag,
       allocation_mode_id, allocation_mode, rule_weight
  FROM apps.wms_rules_v
 WHERE enabled_flag = 'Y'
    AND allocation_mode = 'Full Allocation';

To enumerate global rules shared across warehouses, filter on common_to_all_orgs_flag = 'Y'. Because the view already coerces null allocation modes to code 4 and restricts to WMS_ACTION_TYPE code 2, queries return a consistent, pre-joined allocation-rule dataset suitable for dashboards and interface staging tables.