Search Results mtl_system_items_b




Here's a detailed description of the MTL_SYSTEM_ITEMS_B table in Oracle E-Business Suite (EBS):

Table Name: MTL_SYSTEM_ITEMS_B (Master Item Table - Basic)

Purpose:
- Stores core item master data in Oracle Inventory
- Represents fundamental item attributes and configurations

Key Columns:
1. INVENTORY_ITEM_ID (Primary Key)
- Unique identifier for each inventory item
- Typically generated by sequence

2. ORGANIZATION_ID
- Identifies the specific inventory organization
- Links item to a particular inventory context

3. SEGMENT1 - SEGMENT6
- Item classification segments
- Used for item categorization and hierarchical classification

4. DESCRIPTION
- Detailed description of the inventory item

5. PRIMARY_UOM_CODE
- Primary unit of measurement for the item

6. INVENTORY_ITEM_FLAG
- Indicates if item is stocked in inventory
- 'Y' or 'N' value

7. PURCHASING_ITEM_FLAG
- Indicates if item can be purchased
- 'Y' or 'N' value

8. PLANNING_MAKE_BUY_CODE
- Defines item as make or buy

9. INVENTORY_ASSET_FLAG
- Determines if item is an inventory asset

10. SERIAL_NUMBER_CONTROL_CODE
- Manages serial number tracking

Typical Usage:
- Item master data management
- Inventory control
- Purchasing
- Manufacturing planning

Related Tables:
- MTL_SYSTEM_ITEMS_TL (Translatable descriptions)
- MTL_ITEM_CATEGORIES
- PO_ITEMS_V

Recommendations:
- Performance indexed
- Critical for inventory and procurement processes