Results for “gmd_grades_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMD_GRADES_VL is a translation (VL, or "view language") view in the APPS schema that belongs to the GMD - Process Manufacturing Product Development module. Its documented description is "QC GRADES Translation View." The view presents quality control grade definitions in a language-sensitive manner, combining the language-independent base entity with its translated descriptive text. In Oracle EBS Release 12.1.1 and 12.2.2, VL views of this form are the standard mechanism by which multilingual lookup-style entities are exposed to forms, reports, concurrent programs, and integration interfaces, so that end users see the grade description in their session language while the underlying key remains stable.

Because the view resolves the description through the USERENV('LANG') session setting, it is central to any reporting or integration logic that needs the currently active grade description — the requirement implied by a search for the QC_GRADE_DESC column. It is a read-only presentation layer and does not itself store data.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, GMD_GRADES_VL is defined over two base objects, both referenced as synonyms: GMD_GRADES_B (the base table holding language-independent grade attributes) and GMD_GRADES_TL (the translation table holding the language-specific description). The view is created by joining these two on the QC_GRADE key while restricting the translation rows to the caller's language:

• The join predicate is B.QC_GRADE = T.QC_GRADE.
• The language filter is T.LANGUAGE = USERENV('LANG').
• All descriptive and control columns come from GMD_GRADES_B (aliased B); only QC_GRADE_DESC is supplied by GMD_GRADES_TL (aliased T).

This B/TL pair is the classic EBS translated-entity pattern, where _B stores the entity and _TL stores one description row per installed language.

Key Columns

• QC_GRADE — the grade code; the primary business key and the join column between the base and translation tables.
• QC_GRADE_DESC — the translated grade description for the session language, sourced from GMD_GRADES_TL and the column named in the user's search.
• ROW_ID — the ROWID of the GMD_GRADES_B row, exposed for forms/row-locking use.
• DELETE_MARK — the soft-delete flag (0 = active, 1 = logically deleted).
• TEXT_CODE, TRANS_CNT — the text/translation bookkeeping columns used by the translation framework to locate and version translated text.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the DFF (descriptive flexfield) context and segment columns.

Common Use Cases and Queries

Typical uses include grade-validation lists in QC data entry forms, translated grade descriptions on certificates of analysis and specification reports, and integration extracts that must carry the localized grade name. The following query lists active grades in the session language:

SELECT g.qc_grade, g.qc_grade_desc
FROM   apps.gmd_grades_vl g
WHERE  g.delete_mark = 0
ORDER  BY g.qc_grade;

For a specific grade, or to join grade descriptions onto a transaction table, the view is used as a lookup by QC_GRADE:

SELECT t.transaction_id, t.qc_grade, g.qc_grade_desc
FROM   qc_transactions t, apps.gmd_grades_vl g
WHERE  t.qc_grade = g.qc_grade (+)
AND    g.delete_mark = 0;

When resolving a description in a language other than the session default, query the GMD_GRADES_TL table directly and filter on LANGUAGE, since the VL view always enforces the USERENV('LANG') predicate and cannot be retargeted without changing the session language.