View: GR_TOXIC_SPECIES_VL

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

View Text

SELECT B.ROWID ROW_ID
, B.TOXIC_SPECIES_CODE
, B.HIERARCHY_SEQ
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.TOXIC_SPECIES_DESC FROM GR_TOXIC_SPECIES_TL T
, GR_TOXIC_SPECIES_B B
WHERE B.TOXIC_SPECIES_CODE = T.TOXIC_SPECIES_CODE AND T.LANGUAGE = USERENV('LANG')

Columns