query for item balance in each inventory or for item

Content

i want to get balance for each item

item_id , available_qty , reserved_qty , balance_qty

 

i want to get balance for each item in each inventory

item_id , requisition_no , requisition_date , transfer_no , transfer_date , from_warehouse_id , to_warehouse_id , transit_qty