Items with txns

select msib.* from mtl_system_items_b msib , mtl_material_transactions mmt, mtl_parameters mp
where 1=1
and msib.inventory_item_id = mmt.inventory_item_id
and msib.organization_id = mmt.organization_id
and msib.organization_id = mp.organization_id

select msib.* from mtl_system_items_b msib , mtl_material_transactions mmt, mtl_parameters mp where 1=1 and msib.inventory_item_id = mmt.inventory_item_id and msib.organization_id = mmt.organization_id and msib.organization_id = mp.organization_id