This question is You Asked Tom: I have a table that initially stores information about items in a warehouse stored in different bins. Table look like this where manual inventories are done every 3 months. Effective date is the sysdate when record is inserted. Total Qty of an item in inventory in a given bin. Total qty of an item in inventory.