I just learned today that in V15, changes to service orders are stored in the order_changes_log (Active) and c_order_changes_log (History) tables.
In previous versions of Alliance, these changes were stored in the demand (Active) and demand_done (History) tables and can be retrieved with the following queries:
select * from demand with (nolock) where demand.order_id = 'Order ID' and bpart_gcl_id = 'Mngt';
select * from demand_done with (nolock) where demand.order_id = 'Order ID' and bpart_gcl_id = 'Mngt';
For V15 and later, the Trans. Log entries can be found with the following:
select * from order_changes_log with (nolock) where order_id = 'Order ID'
select * from c_order_changes_log with (nolock) where order_id = 'Order ID'