sub inventory name & Items

Dear All,

the items appears twice when running this query knowing that the items refer to one sub inventory

please check it

select distinct

s.secondary_inventory_name , B.SEGMENT1 ITEM, T.DESCRIPTION

FROM MTL_SYSTEM_ITEMS_TL T ,

MTL_SYSTEM_ITEMS_B B ,

MTL_SECONDARY_INVENTORIES s

WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID

AND B.ORGANIZATION_ID = T.ORGANIZATION_ID

AND B.ORGANIZATION_ID = S.ORGANIZATION_ID

and T.organization_id =123

and s.secondary_inventory_name in ('A' ,'B')--, 'SalesAlchl')

and  B.INVENTORY_ITEM_STATUS_CODE = 'Active'

order by ITEM