DEREF returns the object instance that the REF value points to. This is more easily explained with a simple example.
In this case, DEREF is passed the REF value for the correlation ID of the inventory_tbl:
FROM inventory_tbl i
WHERE item_id = 1;
The object instance associated with the REF value of item_id 1 is returned: