Search Results eam_isolation_statuses_vl




Overview
Explore in AI Chat

Overview

EAM_ISOLATION_STATUSES_VL is a bilingual (VL-suffixed) view in the APPS schema of Oracle E-Business Suite, owned by the Enterprise Asset Management (EAM) product family. It presents user-defined isolation statuses and their mapping to the corresponding isolation system status. Within the EAM safety and isolation management workflow, isolation statuses represent the stages of a permit or isolation record — for example, "Requested", "Applied", "Removed", or "Cancelled". The view consolidates the base status definition, the translated (language-specific) status text, and the seeded system-status lookup meaning into a single read-only result set that is language-aware through USERENV('LANG').

The view is declared VALID and is intended for reporting, integration, and lookup/LOV purposes. Because it exposes the DECODE logic that resolves seeded versus user-defined descriptions, it is the authoritative source for presenting an isolation status to an end user or an external system in the session's current language. Note that the object is documented as a view with no DML privileges implied; consumers should treat it strictly as a query surface.

Underlying Base Objects

The view is defined over three referenced objects, all resolvable within the APPS schema:

The join between the base table and the TL table is an outer join (+), and the lookup join is likewise outer (+) on the SYSTEM_STATUS predicate. The base query is additionally constrained to ENTITY_TYPE = 1 and to the session language via T.LANGUAGE (+) = USERENV('LANG'), and to enabled lookups via ML.ENABLED_FLAG = 'Y'.

Key Columns

  • ROW_ID — the ROWID of the base table row, useful for uniqueness and diagnostics.
  • STATUS_ID — the primary key identifying the isolation status definition.
  • SYSTEM_STATUS — the code of the mapped seeded system status.
  • ISOLATION_STATUS — the resolved display text. For seeded rows (SEEDED_FLAG = 'Y') it returns the translation if present, otherwise the lookup MEANING; for non-seeded rows it returns the user-defined status.
  • SYSTEM_STATUS_DESC — the lookup MEANING describing the system status.
  • SEEDED_FLAG / ENABLED_FLAG — indicate whether the row is Oracle-seeded and whether it is active.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard audit columns.

Common Use Cases and Queries

Typical uses include populating isolation-status LOVs, driving status-driven reporting, and validating status codes during integration loads. A basic query listing all enabled statuses is:

  • SELECT status_id, isolation_status, system_status, system_status_desc FROM eam_isolation_statuses_vl WHERE enabled_flag = 'Y';
  • SELECT status_id, isolation_status FROM eam_isolation_statuses_vl WHERE seeded_flag = 'N' ORDER BY isolation_status;
  • SELECT s.system_status_desc, COUNT(*) FROM eam_isolation_statuses_vl s GROUP BY s.system_status_desc;

Because language resolution depends on USERENV('LANG'), reports should set NLS appropriately or rely on the session language to obtain translated status text.