IBE_ACTIVE_QUOTES_ALL table will have information about a user's active cart. A record in IBE_ACTIVE_QUOTES_ALL table will have a QUOTE_HEADER_ID. You can use this QUOTE_HEADER_ID to go to ASO_QUOTE_LINES table to find the line level details for a cart. You can use the below given query for reference:
FROM ibe_active_quotes_all iaqa, aso_quote_lines_all aql
WHERE iaqa.quote_header_id = aql.quote_header_id
AND iaqa.active_quote_id = ?;
Once your cart is saved and is no longer active, you will not find the details of that cart in IBE_ACTIVE_QUOTES_ALL table. To find the details of a saved cart, you can go to ASO_QUOTE_HEADERS table and search either by the name of the saved cart, which you will find in QUOTE_NAME column in ASO_QUOTE_HEADERS_ALL table.
Hope this helps.