link between MTL_SYSTEM_ITEMS_B and MTL_ITEM_CATEGORIES_V

select msi.ORGANIZATION_ID,
msi.segment1,
msi.DESCRIPTION,
mst.LONG_DESCRIPTION,
msi.PRIMARY_UOM_CODE,
msi.ITEM_TYPE,
msi.INVENTORY_ITEM_STATUS_CODE,
miv.CATEGORY_CONCAT_SEGS HS_CATEGORY_CODE
 from  mtl_system_items_b msi ,
 MTL_SYSTEM_ITEMS_TL mst,
 MTL_ITEM_CATEGORIES_V miv
 where msi.inventory_item_id = mst.inventory_item_id
 and msi.organization_id = mst.organization_id
 and msi.inventory_item_id = miv.inventory_item_id
 and msi.organization_id = miv.organization_id
 and miv.CATEGORY_SET_NAME ='ENVS HS Code'
and msi.segment1 ='08180813' and msi.organization_id =104