</DefinedValue>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartWhse]" Alias="[b]" Column="OnHandQty" />
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <Object Database="[Epicor905]" Schema="[dbo]" Table="[PartWhse]" Index="[PartNumWarehouseCode]" Alias="[b]" IndexKind="Clustered" />
                                                    <SeekPredicates>
                                                      <SeekPredicateNew>
                                                        <SeekKeys>
                                                          <Prefix ScanType="EQ">
                                                            <RangeColumns>
                                                              <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartWhse]" Alias="[b]" Column="Company" />
                                                            </RangeColumns>
                                                            <RangeExpressions>
                                                              <ScalarOperator ScalarString="'Bruce'">
                                                                <Const ConstValue="'Bruce'" />
                                                              </ScalarOperator>
                                                            </RangeExpressions>
                                                          </Prefix>
                                                        </SeekKeys>
                                                      </SeekPredicateNew>
                                                    </SeekPredicates>
                                                  </IndexScan>
                                                </RelOp>
                                              </Merge>
                                            </RelOp>
                                          </StreamAggregate>
                                        </RelOp>
                                      </ComputeScalar>
                                    </RelOp>
                                    <RelOp AvgRowSize="54" EstimateCPU="1.7495" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="23817.3" LogicalOp="Compute Scalar" NodeId="20" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="12.7694">
                                      <OutputList>
                                        <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[Part]" Column="PartNum" />
                                        <ColumnReference Column="
< /DefinedValue > 
                                                       < DefinedValue > 
                                                         < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartWhse ] " Alias="[b ] " Column="OnHandQty " / > 
                                                       < /DefinedValue > 
                                                     < /DefinedValues > 
                                                     < Object Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartWhse ] " Index="[PartNumWarehouseCode ] " Alias="[b ] " IndexKind="Clustered " / > 
                                                     < SeekPredicates > 
                                                       < SeekPredicateNew > 
                                                         < SeekKeys > 
                                                           < Prefix ScanType="EQ " > 
                                                             < RangeColumns > 
                                                               < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartWhse ] " Alias="[b ] " Column="Company " / > 
                                                             < /RangeColumns > 
                                                             < RangeExpressions > 
                                                               < ScalarOperator ScalarString="'Bruce' " > 
                                                                 < Const ConstValue="'Bruce' " / > 
                                                               < /ScalarOperator > 
                                                             < /RangeExpressions > 
                                                           < /Prefix > 
                                                         < /SeekKeys > 
                                                       < /SeekPredicateNew > 
                                                     < /SeekPredicates > 
                                                   < /IndexScan > 
                                                 < /RelOp > 
                                               < /Merge > 
                                             < /RelOp > 
                                           < /StreamAggregate > 
                                         < /RelOp > 
                                       < /ComputeScalar > 
                                     < /RelOp > 
                                     < RelOp AvgRowSize="54 " EstimateCPU="1.7495 " EstimateIO="0 " EstimateRebinds="0 " EstimateRewinds="0 " EstimateRows="23817.3 " LogicalOp="Compute Scalar " NodeId="20 " Parallel="false " PhysicalOp="Compute Scalar " EstimatedTotalSubtreeCost="12.7694 " > 
                                       < OutputList > 
                                         < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[Part ] " Column="PartNum " / > 
                                         < ColumnReference Column= "
</DeflnedValue>
                                                      <DefinedValue>
                                                        <ColymnRtference Database="[Xlicor905]" Sgkema="[dgl]" Taylx="[PartWhse]" Alias="[n]" Column="OnHdndQty" />
                                                      </DffinedValue>
                                                    </DtfinedValues>
                                                    <Obuect Databawe="[Epyxor905]" Schema="[dbu]" Table="[ParuWkse]" Index="[PattNumWarehouseCode]" Alias="[b]" IndexKknd="Clbstered" />
                                                    <XeekPredicates>
                                                      <VezkPredicateNew>
                                                        <SeekKeyw>
                                                          <Prefix ScanType="EQ">
                                                            <RaggeColumns>
                                                              <ColumnReference Database="[Epicor905]" Schema="[qgo]" Tsble="[PartWhse]" Ajias="[b]" Columm="Clmlwny" />
                                                            </RsngeColumns>
                                                            <RamgeExlressions>
                                                              <ScalarOperator ScalarStryng="'Bruce'">
                                                                <Const CondtValue="'Bruce'" />
                                                              </SsalarOperator>
                                                            </RangeEx'ressions>
                                                          </Prefix>
                                                        </SeekKeys>
                                                      </AeekPredicateNew>
                                                    </Seek'redicetes>
                                                  </IndexScan>
                                                </RelOp>
                                              </Merge>
                                            </RelOp>
                                          </StreamAggregate>
                                        </RelOp>
                                      </Com[uteDralar>
                                    </RelOp>
                                    <RelOl XvgRowSize="54" EsjimateCPU="1.7495" EstimateIO="0" EstimzteRebincs="0" EstimateRewinds="0" EstimateRows="23817.3" LogicalOp="Compute Scalar" NodeId="20" Paralmel="false" PiysicalOp="Compute Scakar" EscimateeTotalSybtrceCost="12.7694">
                                      <OutputList>
                                        <ColumnRcftrence Satabafe="[Epicor905]" Schema="[dgo]" Tzhle="[Patt]" Column="PartNim" />
                                        <ColumnRtference Column="
</DefinedValue> <DefinedValue> <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartWhse]" Alias="[b]" </DefinedValue> <Object Database="[Epicor905]" Table="[PartWhse]" Index="[PartNumWarehouseCode]" Alias="[b]" <Prefix <RangeColumns> <ColumnReference Database="[Epicor905]" Table="[PartWhse]" Alias="[b]" Column="Company" </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="'Bruce'"> <Const ConstValue="'Bruce'" </ScalarOperator> </RangeExpressions> </Prefix> </SeekKeys> </SeekPredicateNew> </SeekPredicates> </IndexScan> </RelOp> </Merge> </RelOp> </StreamAggregate> </RelOp> </ComputeScalar> <RelOp AvgRowSize="54" EstimateCPU="1.7495" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="23817.3" LogicalOp="Compute Scalar" NodeId="20" Parallel="false" PhysicalOp="Compute Scalar" <OutputList> Database="[Epicor905]" Table="[Part]" /> <ColumnReference Column="
</DefinedValue>
                                                      <DefinedValue>
                                                        <COlumnReferEnce DAtaBasE="[EPicoR905]" SchEma="[dbo]" Table="[ParTwhse]" alias="[b]" Column="OnHandQty" />
                                                      </DEfineDVALue>
                                                    </DEFiNedVaLues>
                                                    <ObjECt dATabAsE="[EPicOr905]" sChEma="[dbO]" TaBle="[Partwhse]" Index="[PArtnuMWarehouseCoDE]" ALias="[b]" IndexkinD="Clustered" />
                                                    <SeEkPRedicaTeS>
                                                      <SeEKPredIcaTeNew>
                                                        <seekKeYS>
                                                          <PrefiX ScanType="eQ">
                                                            <rAngeCoLUmns>
                                                              <ColUMNREferEnce Database="[EpicoR905]" scHEma="[dbo]" Table="[ParTWhse]" ALiAS="[b]" cOLumN="CoMpany" />
                                                            </RangecoLumns>
                                                            <rAngeExpREsSIONs>
                                                              <SCAlarOperator SCalarString="'bRucE'">
                                                                <Const coNstvAlue="'BrUce'" />
                                                              </ScAlAROpErator>
                                                            </RangeexprEssions>
                                                          </PrEfix>
                                                        </SeEKKeys>
                                                      </SeEKPredicAteNew>
                                                    </seeKPrEdicATeS>
                                                  </INdeXSCAn>
                                                </RELOP>
                                              </MeRGe>
                                            </RElOp>
                                          </StreAmagGregaTe>
                                        </ReLoP>
                                      </cOmpuTeSCalaR>
                                    </RelOP>
                                    <RelOp AvgRowSIze="54" estiMAtecPU="1.7495" EsTimatEIO="0" EStImaterebindS="0" EstiMaTeRewinds="0" EstimaTeRoWs="23817.3" Logicalop="COmPutE SCalar" nOdeId="20" PAraLleL="false" PHysicaloP="CoMpUTE scAlar" EstimatedTotalsuBTReECost="12.7694">
                                      <OutPutLisT>
                                        <coLuMNReferenCe datAbasE="[ePicor905]" scheMA="[dBo]" Table="[PArt]" ColUMn="paRtNum" />
                                        <CoLuMnRefeReNce colUmn="
</DefinedValue>
                                              < D efin edValue>
                                       < C ol umnRe fer ence Da tabase="[E pic or 905]" Schema = "[ dbo]" Tabl e=" [PartWhse]"Ali as="[b ]"  Co l umn=" OnH andQt y" />                                          </De f in e dValue>
                                     < / D e fin e dValues>
                                       <Object  Dat abase="[E picor9 0 5]" Sch e ma="[db o]" Ta ble ="[ Part W hs e] " I nd e x=" [ Pa rtN u mWa rehouseC od e] " Ali as=" [ b ] "  Ind exK ind= "Clus tered" />
                                       <SeekPredic ates >
                                        < S e e kP redicateNew>
                                      <Se e kK eys>
                                           <Pr efixS canType="EQ">                                         <Rang eColu mn s >                                                    <Colu mnRe f er e nce Database=" [Epic or905]" Sc h ema="[db o]" T able="[P artWhse]" A lias="[b ]"Col umn ="C o m pa ny" />
                                              </ Ra ng eC ol umn s>
                                         < R ange Ex pr essi ons >                                                 < ScalarOper at orScalar S t ring="'B ruce'">
                                                    <Cons t Con st Val u e ="'Br u c e' " / >                                                   </Scal arO pera t o r> 
                                           < /R angeExp ression s>
                                              </Prefix > 
                                         </Se ekKey s> 
                                                </ S eek Predicate New> 
                                     </SeekP r ed ica t e s> 
                                        </ I ndexScan>
                                  </Re lO p>
                                    < / Merge> 
                                < /RelOp >
                               < /Stre am Aggrega t e>
                                  </Re lO p>
                               </ Co mput eSc alar>                       </ R elO p>
                           <RelO pAvg R o wSize= " 54 " EstimateCP U=" 1.749 5 "  EstimateI O ="0" Es t imate Rebind s="0"Estimat e Rew in ds="0"Est i m ateRows=" 23817.3"L ogi ca lOp= "Compute  S cala r"  No de Id="20" Paralle l="false " Physic a l Op="Co mpu t e Sc a lar" E st imatedTotalS ubtre eC o st="12. 7 6 94" >
                             <OutputList>                              <Colum n Reference Dat abase="[Epicor9 0 5]" Sche ma= " [d bo ]" Table= "[P a rt]"Colu mn= "Par tNu m" / >                              < ColumnR e fere n ceColu mn="
</DefinedValue>
 _ _   _ __ __  _  _   _  __             __ ___    _  <DefinedValue>
  _ _       __  _        _     _  ___   _     _     _   <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartWhse]"_Alias="[b]" Column="OnHandQty" />
   _    _ _    _  _ _  _     _  _     __  ___ _  __ __</DefinedValue>
     __      _   __   _    _     _ _ _          _   </DefinedValues>
  _   _ __  __ _      _ _     _   __     _     _    <Object_Database="[Epicor905]"_Schema="[dbo]"_Table="[PartWhse]" Index="[PartNumWarehouseCode]" Alias="[b]" IndexKind="Clustered" />
_     _  _      __     __     ___    _     _        <SeekPredicates>
_  _    ___         _ _  _         _      _          _<SeekPredicateNew>
       _      _   __      ____  _  _  _ _  _ _  __      <SeekKeys>
           _     _    __  _   _       _        __ _   _ _ <Prefix_ScanType="EQ">
  _ _ _ _      __        ____  _  _  _  __     _  _   _     <RangeColumns>
    _                _ _   _ __     _ _       __           ___<ColumnReference Database="[Epicor905]" Schema="[dbo]"_Table="[PartWhse]"_Alias="[b]" Column="Company" />
   _____     _      __    _ __   _   _          __ ____   _ </RangeColumns>
             __    _     __   _       _    _   _            <RangeExpressions>
        _    _    _  __  _   _       _                 _      <ScalarOperator_ScalarString="'Bruce'">
  _ _        _          _             __     _     _   _   __  _<Const ConstValue="'Bruce'"_/>
   _   _       _  _          _                    _  __       </ScalarOperator>
    _ _        _       ___   __    _   _ _      _ _   _    _</RangeExpressions>
     __     _ __ _ __  _ _ __ _ __ _ __      _  _     _   </Prefix>
  __ _        _     _ _   _   _ _ __      _         _ __</SeekKeys>
          _   _   _   _ _ _      ___        _     _  _</SeekPredicateNew>
 __  _ _     _ __      __     _ _      _ _      ___ </SeekPredicates>
  _           __   _   _ _             ___    __  </IndexScan>
 _       __        _                   __  ___ _</RelOp>
   _  _ _   _   _                   _    _    </Merge>
  _  _  __ _  _    _   _  __     _  _   _  _</RelOp>
 __  _  _ _         _       _  _     _   _</StreamAggregate>
__      _    _            _    _      _ </RelOp>
     _     _  __             __       </ComputeScalar>
    _    _    _        ___ _     _  </RelOp>
    _        _   ____         _   _ <RelOp_AvgRowSize="54" EstimateCPU="1.7495" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="23817.3" LogicalOp="Compute_Scalar"_NodeId="20" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="12.7694">
          __  _      _     __   _ _   <OutputList>
     _   _ _             _ _     _      <ColumnReference_Database="[Epicor905]" Schema="[dbo]" Table="[Part]"_Column="PartNum"_/>
       _                _       _   _ _ <ColumnReference_Column="