Search Results eam_wo_statuses_vl




Overview
Explore in AI Chat

Overview

The EAM_WO_STATUSES_VL view is a validation view (the "_VL" suffix denotes a translated, language-aware validation view) owned by the APPS schema in Oracle E-Business Suite. It belongs to the Enterprise Asset Management (EAM) product family and presents the set of user-defined work order statuses together with their mapping to the corresponding Oracle Work in Process (WIP) job status. The view resolves a two-part problem that EAM work orders introduce: work orders may carry organization-specific, user-defined statuses, but every such status must ultimately map onto a seeded WIP status so that downstream manufacturing and costing logic can interpret it. EAM_WO_STATUSES_VL exposes that mapping in a single, denormalized, translated result set.

Because it is a validation view rather than a base table, it is the recommended reporting and integration surface for work order status data. Concurrent programs, custom reports, Discoverer workbooks, and inbound/outbound interfaces that need to display a status label in the session language should query this view instead of the underlying base tables, so that the appropriate translation and the correct "effective" status label are applied automatically. In release 12.1.1 and 12.2.2 the object is documented as VALID, with its metadata published in the ETRM repository.

Underlying Base Objects

Per the documented view text, EAM_WO_STATUSES_VL is defined over three objects:

  • EAM_WO_STATUSES_B (synonym) — the base table holding status identifiers, the associated system status, seed indicator, enabled flag, and standard WHO audit columns.
  • EAM_WO_STATUSES_TL (synonym) — the translation table holding the language-specific user-defined status text.
  • MFG_LOOKUPS (view) — the manufacturing lookups view supplying the seeded WIP_JOB_STATUS meanings used to describe the system status.

The join logic links each status row in EAM_WO_STATUSES_B to its translation row in EAM_WO_STATUSES_TL on STATUS_ID (an outer join, since a seeded status may have no translation), filtered to the session language via USERENV('LANG'). A second linkage matches B.SYSTEM_STATUS to MFG_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'WIP_JOB_STATUS' and the lookup is enabled. This produces one row per work order status, enriched with a human-readable description of the underlying WIP status.

Key Columns

  • ROW_ID — the base table ROWID, exposed for tools that require a unique row identifier.
  • STATUS_ID — primary key of the work order status; the join key to both the base and translation tables.
  • SYSTEM_STATUS — the seeded WIP status code to which the user-defined status maps (matches MFG_LOOKUPS.LOOKUP_CODE).
  • WORK_ORDER_STATUS — the effective displayed label. For seeded statuses (SEEDED_FLAG = 'Y') the view returns the user-defined text if present, otherwise the lookup meaning; for non-seeded statuses it returns the user-defined text directly.
  • SYSTEM_STATUS_DESC — the translation-aware meaning of the mapped WIP_JOB_STATUS lookup.
  • SEEDED_FLAG — indicates whether the status is Oracle-provided ('Y') or customer-defined.
  • ENABLED_FLAG — whether the status is currently active and selectable.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard audit columns inherited from the base table.

Common Use Cases and Queries

Typical uses include populating status lists in custom work order forms, validating a status value entered through an interface, and reporting work order counts by status and system status. Because the view already resolves translation and lookup meaning, reports avoid re-implementing that logic.

To list all enabled work order statuses and their WIP mapping:

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

To retrieve the label for a specific status, or to distinguish customer-defined from seeded statuses:

  • SELECT work_order_status, system_status_desc FROM apps.eam_wo_statuses_vl WHERE status_id = :p_status_id;
  • SELECT work_order_status, seeded_flag FROM apps.eam_wo_statuses_vl WHERE seeded_flag = 'N';

To validate that a given user-defined status maps to an expected WIP status before processing a work order interface:

  • SELECT COUNT(*) FROM apps.eam_wo_statuses_vl WHERE work_order_status = :p_label AND system_status = :p_wip_status AND enabled_flag = 'Y';

Oracle proprietary and confidential information; the structure and column definitions above should be verified against the specific ETRM release in use.