Serial Numbers

Tables Involved:

MTL_SERIAL_NUMBERS

• SERIAL_NUMBER
• CURRENT_STATUS

Status Codes (ID and Meaning) 
--------------------- 
1 Defined but not used 
3 Resides in stores 
4 Issued out of stores 
5 Resides in intransit 
6 Pending status 
7 Resides in receiving 
8 Resides in WIP 

• GROUP_MARK_ID, LINE_MARK_ID, LOT_LINE_MARK_ID

* When the mark ids are populated, other transactions cannot use the serials.

MTL_UNIT_TRANSACTIONS

MTL_SERIAL_NUMBERS_TEMP

MTL_SERIAL_NUMBERS_INTERFACE

Queries:

SELECT SERIAL_NUMBER_CONTROL_CODE 
   FROM apps.MTL_SYSTEM_ITEMS_B
WHERE Inventory_Item_ID = ;

Control Codes (ID and Meaning) 
--------------------- 
1 No serial number control 
2 Predefined serial numbers 
5 Dynamic entry at inventory receipt 
6 Dynamic entry at sales order issue