Understanding MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE

Oracle Inventory provides complete serial number support for inventory transactions. We can enable serial number control for specific items in your inventory organization. For items under serial number control, we assign unique serial numbers to individual units and thereafter reference the same serial numbers each time you perform material transactions

There are various level of serialization control Oracle Inventory provides. If we query mtl_system_items_b.serial_number_control_code it provides items serialization status. Here they are…

Serialization Code	Meaning
1	No Serial Number Control
2	Predefined Serial Numbers
5	Dynamic Entry at Inventory Receipt
6	Dynamic Entry at Sales Order Issue.

There are two ways to go for its, Functional way or Technical Way.. lets see first Functional Way.

Functional Way :-

• Login to Oracle Applications
• Navigate to responsibility – Inventory –> Setup –> Lookups
• Query for ‘MTL_SERIAL_NUMBER’

 

Technical Way :-

Just run the following query and it will give you the details :-

SELECT   lookup_type, lookup_code, meaning
    FROM mfg_lookups
   WHERE lookup_type = 'MTL_SERIAL_NUMBER'
ORDER BY lookup_code;