select l.currency from cr_items i, iv_price_lists l where l.list_id = i.latest_revision and i.item_id = :list_id select p.category_id, p.amount from iv_prices p, cr_items i where p.list_id = :list_id and p.price_id = i.latest_revision