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