FND Design Data [Home] [Help]

View: MSC_X_ITEMS_LOV_V

Product: MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data: ViewAPPS.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