VIEW: APPS.GR_ITEM_SAFETY_PHRASES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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