Search Results work_order_status




Overview
Explore in AI Chat

Overview

The view APPS.EAM_WO_STATUSES_VL exposes the complete set of work order statuses defined within Oracle Enterprise Asset Management (EAM). It is a "VL" (view with translation/language) object, meaning it joins the base status definitions to their translated descriptions so that each session sees status text in its own language. The view is owned by the APPS schema and is available in both Oracle EBS 12.1.1 and 12.2.2.

In practice this view is the primary reference for reporting and integration logic surrounding the "work order status" concept. Rather than reading the underlying pair of tables plus the lookup view directly, developers and report authors query this single view to obtain a clean, language-aware list of statuses, their internal coding values, and their translated labels. It supports validation, lookup display, LOV (list of values) population, and status-driven reporting on EAM work orders.

Underlying Base Objects

Per the ETRM metadata, the view is defined over three referenced objects:

  • EAM_WO_STATUSES_B (synonym) — the base table holding status identifiers, system status codes, seeded/enabled flags, and audit columns.
  • EAM_WO_STATUSES_TL (synonym) — the translation table holding the user-defined status descriptions per language.
  • MFG_LOOKUPS (view) — the manufacturing lookup view providing the seeded system status meanings via the WIP_JOB_STATUS lookup type.

The joins are driven by STATUS_ID between the _B base table and its _TL translation, and by SYSTEM_STATUS equated to MFG_LOOKUPS.LOOKUP_CODE. Notably, the join to EAM_WO_STATUSES_TL is an outer join ((+)) restricted to USERENV('LANG'), and the lookup is filtered to LOOKUP_TYPE = 'WIP_JOB_STATUS' with ENABLED_FLAG = 'Y'.

Key Columns

  • ROW_ID — the row identifier derived from the base table ROWID.
  • STATUS_ID — unique identifier for the work order status; the primary join key.
  • SYSTEM_STATUS — the internal system status code that maps to the WIP_JOB_STATUS lookup.
  • WORK_ORDER_STATUS — the display status. Derived via DECODE: for seeded statuses, it uses the translated user-defined status if present, otherwise the lookup meaning; for non-seeded rows, it uses the user-defined text.
  • SYSTEM_STATUS_DESC — the lookup meaning for the system status.
  • SEEDED_FLAG — indicates whether the status is Oracle-seeded ('Y') or user-defined.
  • ENABLED_FLAG — indicates whether the status is active.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE.

Common Use Cases and Queries

Typical uses include populating status list-of-values, driving work order status reports, and validating status values during interface loads. A simple listing of enabled statuses:

SELECT status_id, work_order_status, system_status, seeded_flag
FROM   apps.eam_wo_statuses_vl
WHERE  enabled_flag = 'Y';

To identify seeded statuses only, or to map display text back to its system code:

SELECT work_order_status, system_status_desc
FROM   apps.eam_wo_statuses_vl
WHERE  seeded_flag = 'Y'
AND    enabled_flag = 'Y';

Because the view is language-aware via USERENV('LANG'), results automatically reflect the session language, making it suitable for multilingual reporting and integration without additional joins.