View: GR_EXPOSURE_AUTHS_VL

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

View Text

SELECT B.ROWID ROW_ID
, B.EXPOSURE_AUTHORITY_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.EXPOSURE_AUTHORITY_DESC FROM GR_EXPOSURE_AUTHS_TL T
, GR_EXPOSURE_AUTHS_B B
WHERE B.EXPOSURE_AUTHORITY_CODE = T.EXPOSURE_AUTHORITY_CODE AND T.LANGUAGE = USERENV('LANG')

Columns