[Home] [Help]
View: MSC_X_ITEMS_LOV_V
View Text
SELECT CM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CM.ITEM_NAME ITEM_NAME
, NULL CHANNEL_MASTER_ITEM
, NULL CUSTOMER_ITEM
, NULL SUPPLIER_ITEM
, CM.CREATION_DATE CREATION_DATE
, CM.CREATED_BY CREATED_BY
, CM.LAST_UPDATED_BY LAST_UPDATED_BY
, CM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CM.DESCRIPTION
FROM MSC_ITEMS CM
Columns
Name |
INVENTORY_ITEM_ID |
ITEM_NAME |
CHANNEL_MASTER_ITEM |
CUSTOMER_ITEM |
SUPPLIER_ITEM |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
DESCRIPTION |