Item Container Relationship Query

SELECT      ood.organization_code,
            msi.segment1,
            flv.MEANING WEIGHT_UOM_CODE,
            msi.UNIT_WEIGHT,
            msi.VOLUME_UOM_CODE,
            msi.UNIT_VOLUME,
            msi.DIMENSION_UOM_CODE,
            msi.UNIT_LENGTH,
            msi.UNIT_WIDTH,
            msi.UNIT_HEIGHT,
            msi.CONTAINER_ITEM_FLAG,
            msi.CONTAINER_TYPE_CODE,
            msic.segment1 CONTAINER_ITEM,
            msic.CONTAINER_TYPE_CODE CONTAINER_ITEM_TYPE,
            msi.segment1 LOAD_ITEM,
            msi.description LOAD_ITEM_DESCERIPTION,
            msi.primary_uom_code LOAD_ITEM_UOM,
            wc.MAX_LOAD_QUANTITY,
            wc.PREFERRED_FLAG
 FROM    mtl_system_items_vl msi,
         fnd_lookup_values flv,
         org_organization_definitions ood,
         mtl_system_items_vl msic,
         WSH_CONTAINER_ITEMS wc
 WHERE   msi.organization_id = ood.organization_id
         and msi.WEIGHT_UOM_CODE = flv.LOOKUP_CODE(+)
         and flv.lookup_type = 'UNIT'
         and flv.language=USERENV('LANG') 
         and msi.inventory_item_id = wc.LOAD_ITEM_ID
         and msi.organization_id = wc.MASTER_ORGANIZATION_ID
         and msic.inventory_item_id = wc.CONTAINER_ITEM_ID
         and msic.organization_id = wc.MASTER_ORGANIZATION_ID
         and msi.segment1 ='08260054'
         --and msic.segment1 ='01001698'
         and ood.organization_code = 'E01'