Search Results eam_work_clearance_status

Overview

APPS.EAM_WORK_CLEARANCE_STATUSES_VL is a bilingual (VL) database view within the Oracle Enterprise Asset Management (EAM) module. It presents the set of work clearance statuses that govern the safety and permit-to-work lifecycle associated with an EAM work order. In EAM, a work clearance represents an authorization or lockout/tagout condition that must be applied before work proceeds and formally released before work is closed. This view consolidates both seeded (Oracle-delivered) system statuses and user-defined statuses into a single, translatable result set, exposing each status with a display name resolved against the user's current language session.

Because the view resolves translations dynamically through USERENV('LANG'), it returns values in the session language of the querying user, making it suitable for multi-language reporting and for feeding LOV (List of Values) components in EAM forms and concurrent programs. Its name suffix _VL follows the standard Oracle EBS convention denoting a view that joins base (_B) and translation (_TL) tables.

Underlying Base Objects

The view is defined over three documented objects:

• EAM_SAFETY_USR_DEF_STATUSES_B — the base table holding status definitions, including seeded and user-defined records. The view restricts this table with ENTITY_TYPE = 2, isolating work clearance statuses from other EAM safety status entities (such as work permit statuses).
• EAM_SAFETY_USR_DEF_STATUSES_TL — the translation table supplying the language-specific USER_DEFINED_STATUS text. It is joined with an outer ((+)) join on STATUS_ID and ENTITY_TYPE, and filtered to the session language.
• MFG_LOOKUPS — a view over the manufacturing lookups, joined on LOOKUP_TYPE = 'EAM_WORK_CLEARANCE_STATUS' and LOOKUP_CODE = B.SYSTEM_STATUS. This supplies the MEANING used to describe seeded system statuses.

Only enabled lookups (ML.ENABLED_FLAG = 'Y') participate in the join, so disabled lookup values are not surfaced.

Key Columns

• ROW_ID — the ROWID of the base record, used by Oracle Forms for row identification.
• STATUS_ID — the unique identifier of the clearance status; the primary join key across all three objects.
• SYSTEM_STATUS — the lookup code of the underlying seeded system status.
• WORK_CLEARANCE_STATUS — the resolved display name. A DECODE on SEEDED_FLAG determines whether the seeded lookup meaning or the user-defined text is shown: for seeded rows, the translation (falling back to the lookup meaning) is used; for non-seeded rows, the user-defined text is returned.
• SYSTEM_STATUS_DESC — the descriptive meaning of the system status from MFG_LOOKUPS.
• SEEDED_FLAG — indicates whether the row is Oracle-seeded ('Y') or user-defined.
• ENABLED_FLAG — indicates whether the status is active.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include populating status lists in EAM work clearance forms, validating statuses during integration, and reporting on the configuration of the clearance lifecycle.

• List all enabled clearance statuses for an LOV:

  SELECT status_id, work_clearance_status
  FROM   apps.eam_work_clearance_statuses_vl
  WHERE  enabled_flag = 'Y'
  ORDER  BY work_clearance_status;

• Distinguish seeded from user-defined statuses:

  SELECT status_id, work_clearance_status, system_status_desc, seeded_flag
  FROM   apps.eam_work_clearance_statuses_vl
  WHERE  seeded_flag = 'N';

• Join to work clearance transaction data to translate a stored status ID into its display name for reporting or interface extraction.

Because the view is owned by APPS and built on synonyms, queries should generally be qualified with the APPS schema or invoked through a synonym visible to the reporting user.