Results for “gmd_operation_class_vl”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GMD_OPERATION_CLASS_VL is an APPS-owned dictionary view in the Oracle E-Business Suite Process Manufacturing Product Development (GMD) module. It presents operation class data in a language-aware form by joining the base table GMD_OPERATION_CLASS_B with its translation table GMD_OPERATION_CLASS_TL. The "_VL" suffix denotes a "view with language", a standard Oracle Applications design pattern that exposes a single descriptive column — here OPRN_CLASS_DESC — resolved against the session's language environment. This makes the view the canonical, user-facing source for operation class descriptions and code in ETRM.
In Oracle EBS 12.1.1 and 12.2.2 the view is documented as VALID under the APPS schema and is referenced by reporting and integration components that need human-readable operation class text without manually joining translation tables. Because it resolves the description using USERENV('LANG'), consumers automatically receive text in the language of the connected session, satisfying multi-language deployment requirements.
Underlying Base Objects
GMD_OPERATION_CLASS_VL is defined over two referenced base objects, both exposed as synonyms in APPS:
- GMD_OPERATION_CLASS_B — the operation class base table, supplying OPRN_CLASS, audit columns, and control columns such as TRANS_CNT, DELETE_MARK, and TEXT_CODE.
- GMD_OPERATION_CLASS_TL — the operation class translation table, supplying OPRN_CLASS_DESC for each installed language.
The view text joins the two on OPRN_CLASS and filters the translation rows with the condition T.LANGUAGE = USERENV('LANG'), so exactly one description row per operation class is returned for the current session language. The view also selects B.ROWID as ROW_ID, a legacy Oracle Applications construct historically used for row identification in forms and concurrent processing.
Key Columns
- ROW_ID — the ROWID of the base row in GMD_OPERATION_CLASS_B; a surrogate row identifier rather than a business key.
- OPRN_CLASS — the operation class code; the primary business identifier and join key between the base and translation tables.
- OPRN_CLASS_DESC — the translated, user-facing description of the operation class, resolved for the session language. This is the column most commonly referenced (for example, by searches on "oprn_class_desc").
- CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle Applications audit columns.
- TRANS_CNT, DELETE_MARK, TEXT_CODE — standard concurrency and soft-delete control columns used by the Applications framework; DELETE_MARK indicates logical deletion, and TEXT_CODE supports translated text handling.
Common Use Cases and Queries
Typical use cases include operation class list-of-values reporting, data extracts to external planning or MES systems, and reconciliation of base versus translated records in multi-language implementations.
Retrieve all operation classes with descriptions:
- SELECT oprn_class, oprn_class_desc FROM apps.gmd_operation_class_vl WHERE NVL(delete_mark,0) = 0 ORDER BY oprn_class;
Resolve the description for a specific code:
- SELECT oprn_class_desc FROM apps.gmd_operation_class_vl WHERE oprn_class = :p_oprn_class;
Search by description text:
- SELECT oprn_class, oprn_class_desc FROM apps.gmd_operation_class_vl WHERE UPPER(oprn_class_desc) LIKE UPPER('%' || :search_text || '%');
Because the description is language-resolved, reports run under different language sessions return the appropriate translated text without code changes.
-
View: GMD_OPERATION_CLASS_VL 12.2.2
View for Operation Class Base and translation tables
APPS.GMD_OPERATION_CLASS_VL·↳ GMD_OPERATION_CLASS_B·↳ GMD_OPERATION_CLASS_TL·Explore GMD module →
-
View: GMD_OPERATION_CLASS_VL 12.1.1
View for Operation Class Base and translation tables
APPS.GMD_OPERATION_CLASS_VL·↳ GMD_OPERATION_CLASS_B·↳ GMD_OPERATION_CLASS_TL·Explore GMD module →
-
SYNONYM: APPS.FM_OPRN_CLS 12.1.1
-
SYNONYM: APPS.FM_OPRN_CLS 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - GMD Tables and Views 12.2.2
QC Module Text Lines. Descriptive text for all tables in this module.
-
eTRM - GMD Tables and Views 12.1.1
QC Module Text Lines. Descriptive text for all tables in this module.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - GMD Tables and Views 12.1.1
QC Module Text Lines. Descriptive text for all tables in this module.
-
eTRM - GMD Tables and Views 12.2.2
QC Module Text Lines. Descriptive text for all tables in this module.