VIEW: APPS.WSM_ITEM_EXTENSIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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