View: GR_TOXIC_ROUTES_VL

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

View Text

SELECT B.ROWID ROW_ID
, B.TOXIC_ROUTE_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.TOXIC_ROUTE_DESC FROM GR_TOXIC_ROUTES_TL T
, GR_TOXIC_ROUTES_B B
WHERE B.TOXIC_ROUTE_CODE = T.TOXIC_ROUTE_CODE AND T.LANGUAGE = USERENV('LANG')

Columns