Search Results eam_work_permit_status

Overview

APPS.EAM_PERMIT_STATUSES_VL is a translated (VL) view in Oracle E-Business Suite Enterprise Asset Management (EAM). It exposes the set of work permit statuses available to the EAM Work Permit feature, presenting both seeded (system-defined) statuses delivered by Oracle and any user-defined statuses created by the implementing organization. The view consolidates the base status definition, the language-specific translation, and the seeded lookup meaning into a single reporting-friendly structure.

In Oracle EBS 12.1.1 and 12.2.2, the view is owned by the APPS schema and is typically consumed by EAM work permit pages, concurrent programs, and custom reports that must resolve a permit status identifier to a displayable, language-appropriate description. Because the view already applies the USERENV('LANG') language predicate, it returns the status name in the session's current language without additional joins by the caller. This makes it suitable for integration extracts, BI Publisher data models, and ad hoc SQL where a stable, descriptive status label is required.

Underlying Base Objects

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

• EAM_SAFETY_USR_DEF_STATUSES_B (synonym) — the base table holding status definitions, including the system status code, seeded flag, entity type, and audit columns. It is aliased as B and is the driving table of the join.
• EAM_SAFETY_USR_DEF_STATUSES_TL (synonym) — the translation table carrying the language-specific USER_DEFINED_STATUS text. It is aliased as T and is outer-joined to the base table on STATUS_ID and ENTITY_TYPE, restricted to the session language.
• MFG_LOOKUPS (view) — the seeded lookup view supplying the system status meaning via lookup type EAM_WORK_PERMIT_STATUS. It is outer-joined on LOOKUP_CODE = SYSTEM_STATUS.

The view filters on ENTITY_TYPE = 3, which identifies the work permit entity within the shared safety/user-defined status infrastructure. The outer joins (+) on the translation and lookup tables ensure that rows are returned even when a translation or a matching seeded lookup is absent.

Key Columns

• ROW_ID — the ROWID of the base status record, useful as a unique row identifier.
• STATUS_ID — the primary identifier for the permit status.
• SYSTEM_STATUS — the seeded status code from the base table, used to join to the EAM_WORK_PERMIT_STATUS lookup.
• PERMIT_STATUS — the displayable status name. A DECODE returns the user-defined translation when present (falling back to the seeded lookup meaning), or the user-defined status text for non-seeded rows.
• SYSTEM_STATUS_DESC — the meaning of the seeded lookup code, exposed as ML.MEANING.
• SEEDED_FLAG — indicates whether the status is Oracle-seeded ('Y') or user-defined.
• ENABLED_FLAG — indicates whether the status is currently active.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE.

Common Use Cases and Queries

Typical uses include populating LOVs and report parameters, validating status values during data conversion, and joining permit records to their descriptive status. The following query returns all enabled permit statuses in the session language:

• SELECT status_id, permit_status, system_status, seeded_flag FROM apps.eam_permit_statuses_vl WHERE enabled_flag = 'Y' ORDER BY permit_status;

To distinguish seeded from user-defined statuses for an audit or data-migration reconciliation:

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

Because the view resolves both the seeded meaning and the translation, it is frequently joined to work permit header or transaction tables on STATUS_ID to produce human-readable output in BI Publisher reports and EAM integration extracts.