Search Results wms_els_activities




Overview
Explore in AI Chat

Overview

APPS.WMS_ELS_GROUPED_TASKS_VL is a multilingual (MLS) language-resolved view in the Oracle E-Business Suite Warehouse Management System (WMS) module. It exposes the grouped task setup configuration used by the Engineered Labor Standards (ELS) framework, presenting the underlying base entity WMS_ELS_GROUPED_TASKS in a translated, view-friendly form. The view is owned by the APPS schema, registered under FND Design Data as WMS.WMS_ELS_GROUPED_TASKS_VL, and carries a VALID status in both release 12.1.1 and 12.2.2. Because it is a language-resolved view, it returns the translated (TL) descriptive columns joined to the base (B) columns, allowing applications and reports called from any language session to display descriptions in the user's session language without explicit translation joins.

This view is the primary access point for reporting, integration, and inquiry on the rules that group warehouse labor tasks together for Engineered Labor Standards processing. The user's search term, "wms_els_activity_details," maps directly to a column on this view (ACTIVITY_DETAIL_ID), and the related lookup type WMS_ELS_ACTIVITY_DETAILS, indicating that the searcher is investigating how activity details are used within grouped task definitions.

Underlying Base Objects

The ETRM metadata documents that the view is defined over two underlying objects:

  • WMS_ELS_GROUPED_TASKS_B (SYNONYM) — the base table that stores the non-translatable columns, including identifiers, organization, sequence, activity and operation references, zone and subinventory values, task ranges, group size, and travel time measures.
  • WMS_ELS_GROUPED_TASKS_TL (SYNONYM) — the translation table that stores language-specific descriptive columns keyed by the same primary identifier (ELS_GROUP_ID).

WMS_ELS_GROUPED_TASKS_VL joins the _B and _TL objects on the primary key so that, for the current session language, descriptive (translated) attributes are returned alongside the base data. This is the standard MLS view pattern in Oracle EBS and explains why the view is designated a "MultiLingual view (a language resolved view of the data)." The Synonyms referenced are the APPS-layer synonyms that point to the WMS schema base tables.

Key Columns

The view exposes a mix of identifying, configuration, and metric columns. The most significant are:

Common Use Cases and Queries

Typical uses include validating ELS grouped-task setup, diagnosing why labor standards are not matching expected work, and extracting configuration for audit or migration. A common need is to resolve the ACTIVITY_DETAIL_ID to its lookup meaning. For example:

SELECT g.els_group_id,
       g.organization_id,
       g.sequence_number,
       g.activity_id,
       fl.meaning AS activity_meaning,
       g.activity_detail_id,
       g.operation_id,
       g.group_size,
       g.expected_travel_time
FROM   apps.wms_els_grouped_tasks_vl g,
       fnd_lookup_values_vl fl
WHERE  fl.lookup_type = 'WMS_ELS_ACTIVITY_DETAILS'
AND    fl.lookup_code = TO_CHAR(g.activity_detail_id)
AND    g.organization_id = :org_id
ORDER BY g.sequence_number;

Other scenarios include filtering by source and destination zone to confirm routing coverage, or comparing EXPECTED_TRAVEL_TIME against ACTUAL_TRAVEL_TIME to evaluate labor standard accuracy. Because the view is language-resolved, consumers should query it (rather than the _B table) whenever translated descriptions are required in reports or integrations.