Search Results mtl_grades_tl_pk

Overview

MTL_GRADES_TL is the language translation table for inventory grade codes in Oracle E-Business Suite. It resides in the INV (Inventory) schema and stores the translated, language-specific descriptive text associated with each grade code defined in the base grade entity. In Oracle EBS, grade codes classify inventory material by quality or specification level, allowing organizations to distinguish between material received at different grades within the same item. Because grade descriptions must be presented to users in their session language, Oracle separates the language-independent grade definition from its translatable descriptive attributes, and MTL_GRADES_TL holds the latter. The "_TL" suffix denotes a translation table that carries one row per grade code per installed language.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault modeling suggestion, meaning no foreign key dependencies were mined from its physical constraint structure. In a Data Vault interpretation this leans toward a satellite-style construct attached logically to the grade hub, since it carries descriptive, language-qualified attributes rather than independent business entities or relationship associations. The classification is a modeling heuristic only and does not imply strict referential constraints in the database.

Key Information Stored

The table contains nine documented columns. The most significant are:

• GRADE_CODE — The business identifier of the grade; part of the composite primary key and the join key back to the base grade definition.
• LANGUAGE — The NLS language code identifying the translation; the second component of the composite primary key.
• DESCRIPTION — The translated grade description presented to users in the corresponding language.
• SOURCE_LANG — Indicates the source language of the translated text, used by Oracle's translation (TL) framework to track provenance and the "language of record."
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle who-columns providing audit and concurrency information for each translation row.

The surrogate primary key is defined by the unique index MTL_GRADES_TL_PK, comprising (GRADE_CODE, LANGUAGE). This composite key is also the business-key candidate, since together these two columns uniquely determine a translation row. There is no separate single-column surrogate identifier; the natural composite of grade code and language serves both roles.

Common Use Cases and Queries

The primary use case is multilingual reporting and user-interface display of grade descriptions. Applications and reports join MTL_GRADES_TL to the base grade table to render a description appropriate to the user's language. A typical query resolves the translated description for a given grade in the session language:

• SELECT g.grade_code, t.description FROM mtl_grades_tl t WHERE t.grade_code = :grade_code AND t.language = USERENV('LANG');
• Reporting of grade definitions across all installed languages by omitting the LANGUAGE predicate to audit translation coverage.
• Detecting missing translations by outer-joining the base grade table to MTL_GRADES_TL and filtering rows where the translation is null.
• Bulk data migration or interface loads that populate grade descriptions for multiple language installations.

Because the table is maintained by Oracle's translation framework, direct DML is generally discouraged; translations are typically loaded or refreshed through concurrent programs or the standard EBS translation utilities.

Related Objects

MTL_GRADES_TL depends conceptually on the base grade definition and is referenced indirectly by inventory transaction and lot tables that carry grade codes. Significant related objects include:

• MTL_GRADES_B — The base (language-independent) grade table holding GRADE_CODE; the natural parent joined on GRADE_CODE.
• MTL_LOT_NUMBERS — Lot records that may carry an associated grade code referencing the grade entity.
• MTL_TRANSACTIONS and related transaction tables — Inventory movements that reference grade codes for graded material.
• MTL_ITEM_LOCATIONS / on-hand quantity views — Which may surface grade attributes for reporting.
• FND_LANGUAGES — The language registry joined on LANGUAGE to resolve installed language names.

These relationships are inferred from the EBS inventory data model; the ETRM metadata documents no explicit foreign keys, consistent with its standalone heuristic classification.