SELECT ITEM_NO, ITEM_DESC1 FROM IC_ITEM_MST UNION ALL SELECT L.ITEM_CODE ITEM_NO, NAME_DESCRIPTION ITEM_DESC1 FROM GR_ITEM_GENERAL L, GR_MULTILINGUAL_NAME_TL M WHERE M.ITEM_CODE (+) = L.ITEM_CODE AND M.LABEL_CODE (+) = '11007' AND M.LANGUAGE (+) = USERENV('LANG') AND L.ITEM_CODE NOT IN (SELECT ITEM_NO FROM IC_ITEM_MST) ORDER BY 1
SELECT ITEM_NO
, ITEM_DESC1
FROM IC_ITEM_MST UNION ALL SELECT L.ITEM_CODE ITEM_NO
, NAME_DESCRIPTION ITEM_DESC1
FROM GR_ITEM_GENERAL L
, GR_MULTILINGUAL_NAME_TL M
WHERE M.ITEM_CODE (+) = L.ITEM_CODE
AND M.LABEL_CODE (+) = '11007'
AND M.LANGUAGE (+) = USERENV('LANG')
AND L.ITEM_CODE NOT IN (SELECT ITEM_NO
FROM IC_ITEM_MST) ORDER BY 1
|
|
|