Mail Report SQL

select distinct t.transaction_type_ID,tp.TRANSACTION_TYPE_NAME, count(*) total_transaction
from mtl_material_transactions t, mtl_transaction_types tp
where trunc(transaction_date) between '01-JUN-2015' and '30-JUN-2015' and organization_id in
(select organization_id from mtl_parameters where process_enabled_flag='Y')
and t.TRANSACTION_TYPE_ID=tp.transaction_type_id
group by t.transaction_type_ID,TRANSACTION_TYPE_NAME

select * from mtl_material_transactions t, mtl_system_items_b i where trunc(transaction_date) between '01-MAY-2015' and
'31-MAY-2015' and t.organization_id =471
and t.inventory_item_id in (102863,103330)
and t.INVENTORY_ITEM_ID=i.INVENTORY_ITEM_ID and t.ORGANIZATION_ID=i.ORGANIZATION_ID