View: GR_ITEM_GROUPS_VL

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

View Text

SELECT B.ROWID ROW_ID
, B.ITEM_GROUP_CODE
, B.CONSOLIDATE_TOXICITY_DATA
, B.CONSOLIDATE_EXPOSURE_DATA
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.DESCRIPTION FROM GR_ITEM_GROUPS_TL T
, GR_ITEM_GROUPS_B B
WHERE B.ITEM_GROUP_CODE = T.ITEM_GROUP_CODE AND T.LANGUAGE = USERENV('LANG')

Columns