Hi All,
We have few items in Maximo with Lot type as LOT1.The lot type value is populated by mistake and the users want to change the lot type to NOLOT.
I am aware that it is not possible to change the lottype via front end once the positive balance is created for that item in any of the store room.
As the users are keen to change the lottype anyway we are looking at options to update the value via backend using sql commands.
As part of this, I am interested to know which all tables will affect if lottype on item table is changed so that those tables are also taken care of via the same db script.
Can anyone help me on this?
Thanks
#Inventory------------------------------
Meghana Siriveli
------------------------------