Search Results version_enabled

Overview

GMD_STATUS_VL is a seeded, language-enabled (VL) view owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments. It belongs to the Process Manufacturing Product Development module (GMD), which governs formulation, quality, and status-driven lifecycle control for process-manufactured goods. The view presents the descriptive and operational status definitions that drive status transitions for GMD entities such as formulas, recipes, batches, and quality specifications. Because it is a VL view, it joins the base table (GMD_STATUS_B) with its translations table (GMD_STATUS_TL), automatically filtering to the session language via USERENV('LANG'). This design yields a single row per status code, resolved to the user's current language, making the view the canonical read interface for status lookup, validation, and reporting. It is a reporting and integration convenience object rather than a transaction table; no DML should be directed against it. The presence of the VERSION_ENABLED column — the token the user searched on — indicates the view is also central to version-control behavior, since it exposes whether a given status supports version increment semantics.

Underlying Base Objects

The view is defined over two documented base objects, both referenced in the ETRM metadata as synonyms:

• GMD_STATUS_B — the base (untranslated) status definition table, holding status codes, control flags, and descriptive attributes. Aliased as B in the view text.
• GMD_STATUS_TL — the translation table supplying language-specific DESCRIPTION and MEANING values. Aliased as T.

The join predicate is B.STATUS_CODE = T.STATUS_CODE combined with T.LANGUAGE = USERENV('LANG'). This ensures the view returns one row per status code for the runtime language, with ROW_ID derived from B.ROWID to provide a stable row identifier for integration tools and OAF-based pages. Both base objects reside in the APPS schema and are referenced through synonyms, consistent with standard EBS multi-language table patterns.

Key Columns

The view exposes the following significant columns:

• ROW_ID — the ROWID of the underlying GMD_STATUS_B record; a unique row handle.
• STATUS_CODE — the primary key and business identifier for a status.
• DESCRIPTION / MEANING — language-resolved text supplied by GMD_STATUS_TL.
• UPDATEABLE — flag indicating whether the status may be changed under workflow rules.
• STATUS_TYPE — classifies the status (e.g., approval, quality, or lifecycle category).
• DELETE_MARK — soft-delete indicator; a value of 1 marks the status as logically deleted.
• VERSION_ENABLED — the column of primary interest to the user's search; when set, the status participates in version-enabling behavior for controlled entities.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the standard EBS descriptive flexfield (DFF) segment columns for customer-extensible data.

Common Use Cases and Queries

Typical uses include populating LOVs for status selection, validating status codes during integration loads, and identifying which statuses support versioning. The following query lists version-enabled statuses with their localized descriptions:

• SELECT STATUS_CODE, DESCRIPTION, MEANING, STATUS_TYPE, VERSION_ENABLED
• FROM GMD_STATUS_VL
• WHERE VERSION_ENABLED = 'Y'
• AND NVL(DELETE_MARK, 0) = 0;

Joining to DFF attributes filters on customer-defined segments, and joining STATUS_CODE to transactional GMD tables resolves human-readable status names in reports. Because the view filters by session language, batch jobs should set the language context explicitly to avoid missing translations.