[Home] [Help]
View: MTL_DESCR_ELEMENT_VALUES_V
View Text
SELECT V.ROWID ROW_ID
, V.INVENTORY_ITEM_ID
, V.ELEMENT_NAME
, V.ELEMENT_VALUE
, V.DEFAULT_ELEMENT_FLAG
, V.ELEMENT_SEQUENCE
, E.REQUIRED_ELEMENT_FLAG
, E.ITEM_CATALOG_GROUP_ID
, V.LAST_UPDATE_DATE
, V.LAST_UPDATED_BY
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATE_LOGIN
FROM MTL_DESCRIPTIVE_ELEMENTS E
, MTL_DESCR_ELEMENT_VALUES V
WHERE V.ELEMENT_NAME = E.ELEMENT_NAME
Columns
Name |
ROW_ID |
INVENTORY_ITEM_ID |
ELEMENT_NAME |
ELEMENT_VALUE |
DEFAULT_ELEMENT_FLAG |
ELEMENT_SEQUENCE |
REQUIRED_ELEMENT_FLAG |
ITEM_CATALOG_GROUP_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |