Search Results eam_isolation_status

Overview

APPS.EAM_ISOLATION_STATUSES_VL is a seeded Oracle E-Business Suite view that exposes the list of isolation statuses used by Oracle Enterprise Asset Management (eAM) for safety and isolation (lockout/tagout) procedures. Isolation statuses describe the operational state of equipment or tags within an isolation work permit — for example whether a tag is applied, removed, or pending. The view is a "_VL" (view, translated) construct, meaning it joins a base table, a translation table, and a lookup source to return both the internal definition and a language-specific description in a single row.

The view's role in reporting and integration is to provide a single, language-aware query surface over isolation status definitions. Because it exposes the seeded system status code, its descriptive meaning, the user-defined override, and enablement flags, it is well suited for use in custom concurrent programs, Oracle Reports, OBIEE/BIP data models, and interface programs that need to resolve an isolation status ID to a displayable value without joining the underlying tables themselves. The view respects the session language through USERENV('LANG'), so deployed reports automatically render status descriptions in the user's runtime language.

Underlying Base Objects

The view is defined over three referenced objects documented in ETRM 12.2.2:

• EAM_SAFETY_USR_DEF_STATUSES_B (SYNONYM) — the base table holding one row per status definition, including the system status code, seeded flag, and enabled flag. It is the driving table and is filtered on ENTITY_TYPE = 1, the entity type that identifies isolation statuses.
• EAM_SAFETY_USR_DEF_STATUSES_TL (SYNONYM) — the translation table holding the language-specific user-defined status text. It is outer-joined to the base table on STATUS_ID, ENTITY_TYPE, and the current session language.
• MFG_LOOKUPS (VIEW) — the Oracle Manufacturing lookup view, used here with LOOKUP_TYPE = 'EAM_ISOLATION_STATUS'. It supplies the seeded status meaning (the system description) by matching LOOKUP_CODE to the base table's SYSTEM_STATUS. This join is also outer, and only enabled lookups are considered.

The relationship is a standard EBS translation pattern: base definition + optional translated text + lookup meaning, unified into a single view layer.

Key Columns

• ROW_ID — the ROWID of the base table row, commonly used as a surrogate key by the EBS framework.
• STATUS_ID — the primary identifier of the isolation status record.
• SYSTEM_STATUS — the seeded lookup code that maps to MFG_LOOKUPS for the system-defined status.
• ISOLATION_STATUS — the display value. A DECODE applies the seeded flag: for seeded rows it returns the translated user-defined status if present, otherwise the lookup meaning; for non-seeded rows it returns the user-defined status.
• SYSTEM_STATUS_DESC — the seeded lookup meaning from MFG_LOOKUPS.
• SEEDED_FLAG — 'Y' indicates an Oracle-provided status; 'N' indicates a customer-defined status.
• ENABLED_FLAG — controls whether the status is active and available for selection.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

Typical uses include populating an LOV or report parameter for isolation statuses, joining isolation tag records to resolve status descriptions, and validating interface data before loading isolation permits.

List all enabled, seeded system statuses:

• SELECT status_id, isolation_status, system_status_desc FROM apps.eam_isolation_statuses_vl WHERE enabled_flag = 'Y' AND seeded_flag = 'Y' ORDER BY isolation_status;

Resolve a specific status ID to its display text:

• SELECT status_id, isolation_status, system_status, seeded_flag FROM apps.eam_isolation_statuses_vl WHERE status_id = :p_status_id;

Distinguish customer-defined from Oracle-seeded statuses for a configuration audit:

• SELECT seeded_flag, COUNT(*) FROM apps.eam_isolation_statuses_vl GROUP BY seeded_flag;

All queries should be issued with the APPS schema or a synonym, and results honor the session's language for translated descriptions.