DBA Data[Home] [Help]

VIEW: APPS.GR_ITEM_GENERAL_MSDS_V

Source

View Text - Preformatted

SELECT ig.item_code ,ml.name_description FROM gr_multilingual_name_tl ml, gr_item_general ig WHERE label_code = '11007' AND ml.item_code = ig.item_code AND ml.language = USERENV('LANG')
View Text - HTML Formatted

SELECT IG.ITEM_CODE
, ML.NAME_DESCRIPTION
FROM GR_MULTILINGUAL_NAME_TL ML
, GR_ITEM_GENERAL IG
WHERE LABEL_CODE = '11007'
AND ML.ITEM_CODE = IG.ITEM_CODE
AND ML.LANGUAGE = USERENV('LANG')