mtl_parameters , ORG_ORGANIZATION_DEFINITIONS

mtl_system_items_b consists all master and child items details

inventory
purchasing
bom
om

Item Revision:

Suppose we have an item and if it requires some changes or adding something like a new item/modification in the qty at that time we a Revision takes place called as Item Revision. It is stored in MTL_ITEM_REVISIONS.

Thanks,
Krishh

Item Category is grouping of items. Item Category Sets is grouping of Item Categories. An item can belong to any number of category sets. We can assign item to one category within each category set. T...

mtl_item_categories

_b is the item master table and _kfv is the flex field view where we can get the concatenated segments

b for base table nd kfv for view(key flex view)

Serial controlled means a serial number is associated to each piece of the item.Attribue1 in table mtl_system_items defines if the item is serial controlled.