View: GR_ITEM_GENERAL_MSDS_V

Product:	GR - Process Manufacturing Regulatory Management
Description:	Contains only the rows that reflect the MSDS name for the item in the users environment language
Implementation/DBA Data:	APPS.GR_ITEM_GENERAL_MSDS_V

View Text

SELECT IG.ITEM_CODE
, ML.NAME_DESCRIPTION FROM GR_MULTILINGUAL_NAME_TL ML
, GR_ITEM_GENERAL IG
WHERE LABEL_CODE = '11007'
AND ML.ITEM_CODE = IG.ITEM_CODE
AND ML.LANGUAGE = USERENV('LANG')

Columns