Search Results system_status_desc




Overview
Explore in AI Chat

Overview

APPS.EAM_SAF_WO_CONCAT_STATUSES_VL is a consolidated Oracle E-Business Suite view within the Enterprise Asset Management (eAM) module. It presents a unified, denormalized listing of the status definitions associated with the four principal eAM work-management constructs: permits, work clearances, isolations, and work orders. Rather than querying four separate status views, developers and report authors can reference this single view to retrieve every user-defined status across all four constructs, together with the system-level status value that each maps to.

The view supplies a TYPE discriminator column (internally labeled REF_TYPE) that identifies the source construct for each row, allowing consumers to filter or group by permit, work clearance, isolation, or work order. In Oracle EBS 12.1.1 and 12.2.2, this view serves reporting, integration, and extension purposes: it is a convenient lookup source for forms personalization, concurrent program parameters, OAF/ADF-based custom pages, and BI Publisher reports that must enumerate valid work-management statuses. The VL suffix indicates that the view is a "VARCHAR2/Language" (translated) view, returning the status description in the session's current language.

The view contains no stored data. It is defined entirely as a UNION ALL of four underlying translated status views, so it inherits their language-dependent behavior and row-level security characteristics. It is a read-only object and should never be the target of DML.

Underlying Base Objects

The view is a UNION ALL over four documented base objects, all owned by APPS:

Each branch selects the same canonical column list from its source view, renaming the source-specific user status column (PERMIT_STATUS, WORK_CLEARANCE_STATUS, ISOLATION_STATUS, WORK_ORDER_STATUS) into a common alias, USER_DEFINED_STATUS, and tagging the row with a literal REF_TYPE. Because the four sources share identical column semantics, the UNION ALL harmonizes them into one logical structure without loss of meaning.

Key Columns

  • ROW_ID — The primary row identifier inherited from the underlying status entity. In EBS this is conventionally the rowid-like key used by the translated view layer.
  • STATUS_ID — The internal numeric identifier for the status. This is the join key back to the base status entities and to operational work-order, permit, clearance, and isolation records.
  • SYSTEM_STATUS — The system (seeded) status value to which the user-defined status maps. Typical values correspond to Open, Released, Complete, Closed, and similar lifecycle states.
  • USER_DEFINED_STATUS — The customer-visible status name as configured for the specific construct (permit, work clearance, isolation, or work order).
  • SYSTEM_STATUS_DESC — The descriptive text for the system status. This is the column most relevant to the user search term "system_status_desc" and provides a human-readable rendition of SYSTEM_STATUS.
  • SEEDED_FLAG — Indicates whether the status is Oracle-seeded (Y) or customer-defined (N).
  • ENABLED_FLAG — Indicates whether the status is currently active and selectable.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, inherited uniformly across all four branches.
  • REF_TYPE — The discriminator literal identifying the originating construct.

Common Use Cases and Queries

A frequent requirement is to list all enabled statuses with their descriptions for a given construct. For example, a query returning work-order statuses and their system descriptions:

  • SELECT STATUS_ID, USER_DEFINED_STATUS, SYSTEM_STATUS, SYSTEM_STATUS_DESC FROM APPS.EAM_SAF_WO_CONCAT_STATUSES_VL WHERE REF_TYPE = 'WORK_ORDER' AND ENABLED_FLAG = 'Y' ORDER BY USER_DEFINED_STATUS;
  • Retrieve every distinct system status and description across all constructs: SELECT DISTINCT SYSTEM_STATUS, SYSTEM_STATUS_DESC FROM APPS.EAM_SAF_WO_CONCAT_STATUSES_VL ORDER BY SYSTEM_STATUS;
  • Count configured statuses by construct: SELECT REF_TYPE, COUNT(*) FROM APPS.EAM_SAF_WO_CONCAT_STATUSES_VL GROUP BY REF_TYPE;
  • Join to operational data to resolve a status ID back to its label, e.g. linking W_ISOLATION or work-order records to STATUS_ID to display SYSTEM_STATUS_DESC on custom reports and BI Publisher layouts.

Because the view can return numerous rows across four constructs, always constrain by REF_TYPE and ENABLED_FLAG in reporting queries to avoid ambiguity. The view is suitable for read-only lookups in forms personalization, integration extracts, and custom concurrent programs across both 12.1.1 and 12.2.2.