VIEW: APPS.MTL_DESCR_ELEM_VAL_V

Source

View Text - Preformatted

SELECT DISTINCT E.ITEM_CATALOG_GROUP_ID , V.ELEMENT_NAME /** V.ELEMENT_VALUE **/ FROM MTL_DESCR_ELEMENT_VALUES V , MTL_DESCRIPTIVE_ELEMENTS E WHERE V.ELEMENT_NAME = E.ELEMENT_NAME

View Text - HTML Formatted

SELECT DISTINCT E.ITEM_CATALOG_GROUP_ID
, V.ELEMENT_NAME /** V.ELEMENT_VALUE **/
FROM MTL_DESCR_ELEMENT_VALUES V
, MTL_DESCRIPTIVE_ELEMENTS E
WHERE V.ELEMENT_NAME = E.ELEMENT_NAME