what columns are controlling the active status of the inventory item?

what columns are controlling the active status of the inventory item? I know there is INVENTORY_ITEM_STATUS_CODE , this is to set active or inactive, but is there any other column controlling it? I manually update the status to inactive, the oracle displays inactive , but i still need to do it again in oracle so that this item cannot be used? anyone know the trick? thz