View: WSM_ITEM_EXTENSIONS_V

Product:	WSM - Shop Floor Management
Description:	Item- Sector Extensions View
Implementation/DBA Data:	APPS.WSM_ITEM_EXTENSIONS_V

View Text

SELECT WIE.ROWID AS ROW_ID
, WIE.ORGANIZATION_ID
, WIE.INVENTORY_ITEM_ID
, WIE.LAST_UPDATE_DATE
, WIE.LAST_UPDATED_BY
, WIE.CREATION_DATE
, WIE.CREATED_BY
, WIE.LAST_UPDATE_LOGIN
, WIE.SECTOR_EXTENSION_ID
, MSI.CONCATENATED_SEGMENTS AS ITEM_NUMBER
, MSI.DESCRIPTION
FROM WSM_ITEM_EXTENSIONS WIE
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE MSI.ORGANIZATION_ID = WIE.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = WIE.INVENTORY_ITEM_ID

Columns