Unable to find Consignment Item Costs?

We need consignment item cost along with lot and on-hand details. Currently, I am querying the tables cst_del_onhand_valuations t, cst_transactions ct, cst_val_unit_details cvud, and cst_val_unit_combinations cvuc. The issue is that we cannot find the lot information for the consignment item. Any suggestions on how to resolve this?