Item serial number table in oracle apps

Item serial number table in oracle apps

In this post , we will be discuss about the Item serial number table in oracle apps. Item Serial number is the process to mark the Inventory Item with Unique number which help to identify that in future. Item serial number table in oracle apps , have multiple ones. I will share some of the important tables which helps to store the serial number informations in oracle apps. Here below is the detail Item serial number table in oracle apps.

Most Important Item serial number table in oracle apps

1.mtl_serial_numbers
2. MTL_UNIT_TRANSACTIONS

 Here below is the detail explanation of the Item serial number table

1. mtl_serial_numbers :-

This table help to store the Onhand Inventory Item Serial number. We can get the status of serial number attached to the Inventory Item in this Table. 

2.MTL_UNIT_TRANSACTIONS :- 

This is the transaction table. If we want to track the serial numbers used for Inventory transactions like Purchase Order Reeving , or Sale order issue. Then we can refer this table. This table will help to provide the Serial Number details for the Inventory Transactions.

Here below is the sample query to find the serial number used by Inventory Transactions

select c.serial_number, a.transaction_id, a.transaction_type_id, a.transaction_quantity, b.lot_number
from MTL_MATERIAL_TRANSACTIONS a, MTL_TRANSACTION_LOT_NUMBERS b, MTL_UNIT_TRANSACTIONS c
where a.TRANSACTION_ID = b.TRANSACTION_ID
  and b.SERIAL_TRANSACTION_ID   = c.TRANSACTION_ID
  and c.serial_number=:P_SERIAL_NO