VIEW: APPS.GR_ITEM_RISK_PHRASES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')