Results for “name_description”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GR_ITEM_GENERAL_MSDS_V is an APPS-owned database view within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is narrow and well-defined: the view surfaces the Material Safety Data Sheet (MSDS) name associated with an item, translated into the language of the environment in which the query is executed. Rather than exposing every multilingual name record that may exist for an item across all installed languages, the view returns only the single row whose NAME_DESCRIPTION matches the session's language setting.
Because MSDS documentation is regulated and language-sensitive, regulatory users must see the substance or item name as it appears in their own operating language. This view enforces that behavior automatically by leveraging USERENV('LANG'), eliminating the need for report authors and integration developers to write explicit language-filtering logic. It is typically consumed in regulatory reports, MSDS label printing, and interfaces that need a localized item name without joining the multilingual translation table directly.
Underlying Base Objects
The view is defined over two SYNONYM objects resolved in the APPS schema:
GR_ITEM_GENERAL— the general item master table in Regulatory Management, which holds the base item record keyed byITEM_CODE.GR_MULTILINGUAL_NAME_TL— the multilingual translation table that stores name descriptions per language, also keyed byITEM_CODEand filtered byLANGUAGE.
The two objects are joined on ML.ITEM_CODE = IG.ITEM_CODE. A further restriction, LABEL_CODE = '11007', constrains the translation to the specific label category that represents the MSDS name. The multilingual table is additionally filtered by ML.LANGUAGE = USERENV('LANG'), which is what gives the view its language-sensitive, single-row-per-item character.
Key Columns
ITEM_CODE— the item identifier. Sourced fromGR_ITEM_GENERALand used both as the join key to the multilingual table and as the primary means of looking up a specific item's MSDS name.NAME_DESCRIPTION— the translated MSDS name for the item, drawn fromGR_MULTILINGUAL_NAME_TLfor the label code11007and the current session language. This is the value that appears on MSDS output.
These are the only two columns the view exposes, reflecting its focused purpose as a lookup rather than a general-purpose item view.
Common Use Cases and Queries
The most frequent use is retrieving the localized MSDS name for a known item. Because the language is applied implicitly, callers need not pass a language parameter:
- Single-item lookup:
SELECT item_code, name_description FROM gr_item_general_msds_v WHERE item_code = :item_code; - Regulatory reporting join: join the view to a report's item list on
ITEM_CODEto attach the MSDS name in the user's language, without touchingGR_MULTILINGUAL_NAME_TLdirectly. - Label or MSDS printing: use the view as the source of the printed name, ensuring output matches the operator's environment language.
- Bulk listing:
SELECT item_code, name_description FROM gr_item_general_msds_v ORDER BY item_code;
Consumers should note that only items having a label code 11007 translation in the current language will appear; items lacking that translation return no row, so outer joins may be required where the MSDS name is optional.
-
View: GR_ITEM_GENERAL_MSDS_V 12.2.2
Contains only the rows that reflect the MSDS name for the item in the users environment language
APPS.GR_ITEM_GENERAL_MSDS_V·↳ GR_ITEM_GENERAL·↳ GR_MULTILINGUAL_NAME_TL·Explore GR module →
-
Contains the Generic Names for the item, by language.
-
View: GR_ITEM_GENERAL_MSDS_V 12.1.1
Contains only the rows that reflect the MSDS name for the item in the users environment language
APPS.GR_ITEM_GENERAL_MSDS_V·↳ GR_ITEM_GENERAL·↳ GR_MULTILINGUAL_NAME_TL·Explore GR module →
-
Contains the Document, Shipping, Trade, and Chemical Family Names for the item, by language.
-
View: GR_GENERIC_ITEMS_VL 12.2.2
Contains the rows that have a language dependent description for the generic item code where the language is equal to the user environment variable LANG.
APPS.GR_GENERIC_ITEMS_VL·↳ GR_GENERIC_ITEMS_B·↳ GR_GENERIC_ML_NAME_TL·Explore GR module →
-
View: GR_GENERIC_ITEMS_VL 12.1.1
Contains the rows that have a language dependent description for the generic item code where the language is equal to the user environment variable LANG.
APPS.GR_GENERIC_ITEMS_VL·↳ GR_GENERIC_ITEMS_B·↳ GR_GENERIC_ML_NAME_TL·Explore GR module →
-
Contains the Document, Shipping, Trade, and Chemical Family Names for the item, by language.
-
Contains the rows that have a language dependent name description for the generic item code where the language is equal to the user environment variable LANG.
APPS.GR_GENERIC_ML_NAME_TL_V·↳ FND_LANGUAGES_VL·↳ GR_GENERIC_ML_NAME_TL·Explore GR module →
-
Contains the Generic Names for the item, by language.
-
Contains all the rows for the table
APPS.GR_MULTILINGUAL_NAME_TL_V·↳ FND_LANGUAGES_VL·↳ GR_MULTILINGUAL_NAME_TL·Explore GR module →
-
Contains all the rows for the table
APPS.GR_MULTILINGUAL_NAME_TL_V·↳ FND_LANGUAGES_VL·↳ GR_MULTILINGUAL_NAME_TL·Explore GR module →
-
Contains the rows that have a language dependent name description for the generic item code where the language is equal to the user environment variable LANG.
APPS.GR_GENERIC_ML_NAME_TL_V·↳ FND_LANGUAGES_VL·↳ GR_GENERIC_ML_NAME_TL·Explore GR module →
-
VIEW: APPS.GR_ITEM_REPORT_V1 12.1.1
-
VIEW: APPS.GR_ITEM_REPORT_V1 12.2.2
-
VIEW: APPS.GR_ALL_ITEMS_V 12.1.1
-
VIEW: APPS.GR_ALL_ITEMS_V 12.2.2
-
View: GR_ITEM_REPORT_V1 12.2.2
View of valid Regulatory Items which can be used for Reports.
APPS.GR_ITEM_REPORT_V1·↳ GR_ITEM_GENERAL·↳ GR_MULTILINGUAL_NAME_TL·↳ IC_ITEM_MST·Explore GR module →
-
View: GR_ITEM_REPORT_V1 12.1.1
View of valid Regulatory Items which can be used for Reports.
APPS.GR_ITEM_REPORT_V1·↳ GR_ITEM_GENERAL·↳ GR_MULTILINGUAL_NAME_TL·↳ IC_ITEM_MST·Explore GR module →
-
View: GR_ALL_ITEMS_V 12.1.1
View of ITEM CODE + DESCRIPTION
APPS.GR_ALL_ITEMS_V·↳ FND_PROFILE·↳ GR_ITEM_GENERAL·↳ GR_MULTILINGUAL_NAME_TL·Explore GR module →
-
View: GR_ALL_ITEMS_V 12.2.2
View of ITEM CODE + DESCRIPTION
APPS.GR_ALL_ITEMS_V·↳ FND_PROFILE·↳ GR_ITEM_GENERAL·↳ GR_MULTILINGUAL_NAME_TL·Explore GR module →