Oracle EBS :INV Total issued quantity

Total issued quantity in 9 months

(SELECT SUM (transaction_quantity)
   FROM mtl_material_transactions inventory_item_id=your_item
and organization_id=organization_id
and transaction_quantity<0 and transaction_date between trunc(sysdate) and trunc(sysdate-270)) tot_iss_qty_9mths, --Average monthly consumption
(select sum(transaction_quantity)/30 from mtl_material_transactions
inventory_item_id=your_item
and organization_id=organization_id
and transaction_quantity<0) avg_month_consumption;;