items that haven't any transaction during a specific period

Dear All,

im trying to generate a query that give all items that havent done any transaction during a specific period

but it didnt work properly (some item appear but have transaction)

query below :

select distinct

B.SEGMENT1 ITEM,

T.DESCRIPTION , 

SUM(mtq.primary_transaction_quantity) qty

FROM MTL_SYSTEM_ITEMS_TL T ,

MTL_SYSTEM_ITEMS_B B ,

HR_ALL_ORGANIZATION_UNITS HR,

mtl_onhand_quantities_detail mtq

WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID

AND B.ORGANIZATION_ID = T.ORGANIZATION_ID

and HR.ORGANIZATION_ID= B.ORGANIZATION_ID

and T.organization_id =123

and  B.INVENTORY_ITEM_STATUS_CODE