View: GR_TOXIC_EFFECTS_VL

Product:	GR - Process Manufacturing Regulatory Management
Description:	Contains the rows that have a language dependent description for the toxic effect code where the language is equal to the user environment variable LANG.
Implementation/DBA Data:	APPS.GR_TOXIC_EFFECTS_VL

View Text

SELECT B.ROWID ROW_ID
, B.TOXIC_EFFECT_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.TOXIC_EFFECT_DESCRIPTION FROM GR_TOXIC_EFFECTS_TL T
, GR_TOXIC_EFFECTS_B B
WHERE B.TOXIC_EFFECT_CODE = T.TOXIC_EFFECT_CODE AND T.LANGUAGE = USERENV('LANG')

Columns