VIEW: APPS.GR_REG_ITEM_CODE_V

Source

View Text - Preformatted

SELECT UNIQUE B.ITEM_CODE , T.NAME_DESCRIPTION FROM GR_ITEM_GENERAL_V B, GR_MULTILINGUAL_NAME_TL T WHERE T.ITEM_CODE (+) = B.ITEM_CODE AND T.LABEL_CODE (+) = '11007' AND T.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT UNIQUE B.ITEM_CODE
, T.NAME_DESCRIPTION
FROM GR_ITEM_GENERAL_V B
, GR_MULTILINGUAL_NAME_TL T
WHERE T.ITEM_CODE (+) = B.ITEM_CODE
AND T.LABEL_CODE (+) = '11007'
AND T.LANGUAGE (+) = USERENV('LANG')