Results for “wms_tasks_temp”
20 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WMS.WMS_TASKS_TEMP is a staging and interface table in the Oracle E-Business Suite Warehouse Management (WMS) module. It holds transient or pre-processed task records that feed the Warehouse Management execution engine — typically material handling, dispatching, and task confirmation operations. Rows represent warehouse tasks (moves, picks, putaways, transfers) that are queued or in-flight, and they carry both the item/inventory context and the resource context (person, equipment, machine) required to execute the work.
From a Data Vault modeling perspective, the FK analysis classifies this table as standalone, meaning it has no documented outbound dependencies beyond lightweight lookups to CS_SYSTEMS_ALL_B_TEMP and MTL_TXN_SOURCE_TYPES. In practice it behaves as a link/satellite hybrid: it ties together an inventory transaction context, a source document, and an assigned resource, and it stores descriptive attributes on that association. The _TEMP suffix indicates it is not the authoritative transactional repository — it is a work/staging surface consumed by WMS concurrent programs and mobile/automated material handling integrations.
Key Information Stored
The documented 12.2.2 physical schema exposes 87 columns. The most significant are:
- ROW_ID — surrogate identifier and the FK to
CS_SYSTEMS_ALL_B_TEMP; the primary key candidate for this table. - TRANSACTION_TEMP_ID — the temporary transaction grouping key linking related task rows.
- INVENTORY_ITEM_ID / ITEM / ITEM_DESCRIPTION — the item being moved, with denormalized descriptive fields for reporting.
- ORGANIZATION_ID / ORGANIZATION_CODE / ORGANIZATION_NAME — the owning inventory organization, plus transfer organization fields for inter-org moves.
- REVISION, LOT_NUMBER, SUBINVENTORY_CODE, LOCATOR_ID, LOCATOR, LOCATOR_DESCRIPTION — the full inventory locator context.
- TRANSACTION_TYPE_ID / TRANSACTION_TYPE, TRANSACTION_ACTION_ID / TRANSACTION_ACTION — the nature of the movement.
- TRANSACTION_SOURCE_TYPE_ID — FK to
MTL_TXN_SOURCE_TYPES, identifying the originating document type. - TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_LINE_ID, TRANSACTION_SOURCE_NAME — the specific source document and line.
- TRANSACTION_UOM, TRANSACTION_QUANTITY — measure and unit of the move.
- TASK_ID, USER_TASK_TYPE, USER_TASK_TYPE_CODE, TASK_TYPE, TASK_TYPE_DESCRIPTION — the task definition and its classification.
- PERSON_ID, LAST_NAME, FIRST_NAME, FULL_NAME — the assigned operator.
- EQUIPMENT_ID, EQUIPMENT, EQUIPMENT_INSTANCE, PERSON_RESOURCE_ID, MACHINE_RESOURCE_ID — the assigned resource(s).
- STATUS / STATUS_CODE — task lifecycle state.
- DISPATCHED_TIME, LOADED_TIME, DROP_OFF_TIME — execution timestamps.
- LPN_ID, CONTENT_LPN_ID, ALLOCATED_LPN_ID, TRANSFER_LPN_ID, CARTONIZATION_ID — license plate and cartonization linkage.
- MOVE_ORDER_LINE_ID, PICK_SLIP_NUMBER — the picking/move-order context.
- PRIORITY — task sequencing.
- LAST_UPDATE_DATE, CREATED_BY, ATTRIBUTE1–15 — the standard WHO columns and DFF attributes.
Common Use Cases and Queries
Typical uses include monitoring in-flight warehouse tasks, diagnosing dispatch failures, reconciling task quantities against confirmed inventory transactions, and reporting operator/equipment throughput.
Example: locate open tasks awaiting dispatch for an organization.
SELECT t.task_id, t.item, t.transaction_quantity,
t.status_code, t.priority, t.dispatched_time
FROM wms.wms_tasks_temp t
WHERE t.organization_id = :org_id
AND t.status_code IS NULL
ORDER BY t.priority, t.creation_date;
Example: trace tasks back to their originating document type.
SELECT t.task_id, ts.transaction_source_type, t.transaction_source_name,
t.item, t.transaction_quantity
FROM wms.wms_tasks_temp t,
mtl_txn_source_types ts
WHERE t.transaction_source_type_id = ts.transaction_source_type_id;
A join to CS_SYSTEMS_ALL_B_TEMP on ROW_ID is used to resolve system/source metadata. Reporting on task cycle times can compare DISPATCHED_TIME, LOADED_TIME, and DROP_OFF_TIME.
Related Objects
The following are the most significant objects referenced by or interacting with this table:
- CS_SYSTEMS_ALL_B_TEMP — joined via
WMS_TASKS_TEMP.ROW_ID. - MTL_TXN_SOURCE_TYPES — joined via
TRANSACTION_SOURCE_TYPE_ID. - MTL_SYSTEM_ITEMS_B — provides item definition for
INVENTORY_ITEM_ID. - MTL_ITEM_LOCATIONS / MTL_SECONDARY_INVENTORIES — resolve locator and subinventory context.
- MTL_MATERIAL_TRANSACTIONS — the confirmed transaction that a task ultimately produces.
- WMS_DISPATCHED_TASKS / WMS_TASKS — the operational task surfaces that consume staged rows.
- WMS_LPN_CONTENTS — links license plate content via
LPN_IDand related columns. - PER_ALL_PEOPLE_F — resolves
PERSON_IDto the assigned operator. - WMS task APIs / mobile material handling programs — the consumers that read and confirm rows from this staging table.
-
SYNONYM: APPS.WMS_TASKS_TEMP 12.1.1
-
TABLE: WMS.WMS_TASKS_TEMP 12.1.1
-
SYNONYM: APPS.WMS_TASKS_TEMP 12.2.2
-
TABLE: WMS.WMS_TASKS_TEMP 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - WMS Tables and Views 12.1.1
-
eTRM - WMS Tables and Views 12.2.2
-
eTRM - WMS Tables and Views 12.2.2
-
eTRM - WMS Tables and Views 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1