Results for “system_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• EAM_SAFETY_USR_DEF_STATUSES_B — the base (B) table holding the status definition rows, keyed by STATUS_ID. It carries the SEEDED_FLAG, ENABLED_FLAG, SYSTEM_STATUS, ENTITY_TYPE, and standard audit columns (WHO columns).
• EAM_SAFETY_USR_DEF_STATUSES_TL — the translation (TL) table supplying USER_DEFINED_STATUS text per LANGUAGE, joined on STATUS_ID and ENTITY_TYPE.
• MFG_LOOKUPS — the seeded lookup view supplying the system-status MEANING for LOOKUP_TYPE = 'EAM_ISOLATION_STATUS', matched on LOOKUP_CODE = SYSTEM_STATUS.

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.