link between mtl_system_items_b and mtl_item_revisions_vl

select
ood.organization_code,
msb.SEGMENT1 ITEM_NUMBER,
msb.DESCRIPTION,
msb.inventory_item_status_code ITEM_STATUS,
mir.REVISION_LABEL,
mir.EFFECTIVITY_DATE,
mir.IMPLEMENTATION_DATE,
mir.DESCRIPTION  REVISION_DESCRIPTION
from mtl_system_items_b msb,
mtl_item_revisions_vl mir,
org_organization_definitions ood
where msb.INVENTORY_ITEM_ID = mir.INVENTORY_ITEM_ID
and msb.organization_id = mir.organization_id
and msb.organization_id = ood.organization_id
and mir.organization_id = ood.organization_id
--and msb.INVENTORY_ITEM_ID =31333
--and  msb.organization_id=143
and mir.IMPLEMENTATION_DATE  = (select max(mirv.IMPLEMENTATION_DATE) from  mtl_item_revisions_vl mirv where mirv.INVENTORY_ITEM_ID = mir.INVENTORY_ITEM_ID
                                and  mir.organization_id =mirv.organization_id )                          
order by ood.organization_code,
msb.SEGMENT1