View: GR_ITEM_RISK_PHRASES_VL

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

View Text

SELECT B.ROWID ROW_ID
, B.ITEM_CODE
, B.RISK_PHRASE_CODE
, RT.RISK_DESCRIPTION
, RB.ADDITIONAL_TEXT_INDICATOR
, B.PHRASE_CODE
, PT.PHRASE_TEXT
, B.TEMPERATURE
, B.TEMPERATURE_SCALE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM GR_ITEM_RISK_PHRASES B
, GR_RISK_PHRASES_B RB
, GR_RISK_PHRASES_TL RT
, GR_PHRASES_TL PT
WHERE RB.RISK_PHRASE_CODE = B.RISK_PHRASE_CODE
AND RT.RISK_PHRASE_CODE (+) = B.RISK_PHRASE_CODE
AND RT.LANGUAGE (+) = USERENV('LANG')
AND PT.PHRASE_CODE (+) = B.PHRASE_CODE
AND PT.LANGUAGE (+) = USERENV('LANG')

Columns