Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | Contains the rows that have a language dependent description for the item safety phrase where the language is equal to the user environment variable LANG. |
Implementation/DBA Data: | APPS.GR_ITEM_SAFETY_PHRASES_VL |
SELECT B.ROWID ROW_ID
, B.ITEM_CODE
, B.SAFETY_PHRASE_CODE
, ST.SAFETY_PHRASE_DESCRIPTION
, SB.ADDITIONAL_TEXT_TYPE
, 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_SAFETY_PHRASES B
, GR_SAFETY_PHRASES_B SB
, GR_SAFETY_PHRASES_TL ST
, GR_PHRASES_TL PT
WHERE SB.SAFETY_PHRASE_CODE = B.SAFETY_PHRASE_CODE
AND ST.SAFETY_PHRASE_CODE (+) = B.SAFETY_PHRASE_CODE
AND ST.LANGUAGE (+) = USERENV('LANG')
AND PT.PHRASE_CODE (+) = B.PHRASE_CODE
AND PT.LANGUAGE (+) = USERENV('LANG')