release product detail showing not correct

When I click from the release product list page, or right click > view detail from the item number, the item shown in item detail page is not the item I selected.

Can we have any clue how to debug this ?

Where is the condition to fetch the item by number in the item detail page ?

Could you please help enlightened ?

I have updated the added field in InventTable using SQL. not sure whether this is related with this issue or not