Hello Vinish Sir, Currently i’m working on my client’s project (Inventory Management System), My client requires FIFO base inventory management, unfortunately i did’t worked on this method in past, I Google it lot and found some example solutions but all of them are implemented on Microsoft SQL Server, winning solution. There is no any example or solution found which FIFO implements in Oracle. i’m unable to understand SQL Server Scripts (T-SQL) etc , Please guide me how to implement FIFO in Oracle, loved the way you explain. I will be thankful to you!