                        <Then>
                                                  <ScalarOperator>
                                                    <Const ConstValue="NULL" />
                                                  </ScalarOperator>
                                                </Then>
                                                <Else>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Column="Expr1062" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Else>
                                              </IF>
                                            </ScalarOperator>
                                          </DefinedValue>
                                        </DefinedValues>
                                        <RelOp AvgRowSize="54" EstimateCPU="1.7495" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="23817.3" LogicalOp="Aggregate" NodeId="21" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="12.7694">
                                          <OutputList>
                                            <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[Part]" Column="PartNum" />
                                            <ColumnReference Column="Expr1059" />
                                            <ColumnReference Column="Expr1060" />
                                            <ColumnReference Column="Expr1061" />
                                            <ColumnReference Column="Expr1062" />
                                          </OutputList>
                                          <MemoryFractions Input="0.241026" Output="0.331081" />
                                          <Hash>
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Column="Expr1059" />
                                                <ScalarOperator ScalarString="COUNT_BIG([Expr1032])">
                                                  <Aggregate AggType="COUNT_BIG" Distinct="false">
                                                    <ScalarOperator>
                                                      <Identifier>
                                                        <ColumnReference Column="Expr1032" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </Aggregate>
                                                </ScalarOperator>
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Column="Expr1060" />
                                                <ScalarOperator ScalarString="SUM([Expr
< Then > 
                                                   < ScalarOperator > 
                                                     < Const ConstValue="NULL " / > 
                                                   < /ScalarOperator > 
                                                 < /Then > 
                                                 < Else > 
                                                   < ScalarOperator > 
                                                     < Identifier > 
                                                       < ColumnReference Column="Expr1062 " / > 
                                                     < /Identifier > 
                                                   < /ScalarOperator > 
                                                 < /Else > 
                                               < /IF > 
                                             < /ScalarOperator > 
                                           < /DefinedValue > 
                                         < /DefinedValues > 
                                         < RelOp AvgRowSize="54 " EstimateCPU="1.7495 " EstimateIO="0 " EstimateRebinds="0 " EstimateRewinds="0 " EstimateRows="23817.3 " LogicalOp="Aggregate " NodeId="21 " Parallel="false " PhysicalOp="Hash Match " EstimatedTotalSubtreeCost="12.7694 " > 
                                           < OutputList > 
                                             < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[Part ] " Column="PartNum " / > 
                                             < ColumnReference Column="Expr1059 " / > 
                                             < ColumnReference Column="Expr1060 " / > 
                                             < ColumnReference Column="Expr1061 " / > 
                                             < ColumnReference Column="Expr1062 " / > 
                                           < /OutputList > 
                                           < MemoryFractions Input="0.241026 " Output="0.331081 " / > 
                                           < Hash > 
                                             < DefinedValues > 
                                               < DefinedValue > 
                                                 < ColumnReference Column="Expr1059 " / > 
                                                 < ScalarOperator ScalarString="COUNT_BIG([Expr1032 ]) " > 
                                                   < Aggregate AggType="COUNT_BIG " Distinct="false " > 
                                                     < ScalarOperator > 
                                                       < Identifier > 
                                                         < ColumnReference Column="Expr1032 " / > 
                                                       < /Identifier > 
                                                     < /ScalarOperator > 
                                                   < /Aggregate > 
                                                 < /ScalarOperator > 
                                               < /DefinedValue > 
                                               < DefinedValue > 
                                                 < ColumnReference Column="Expr1060 " / > 
                                                 < ScalarOperator ScalarString="SUM([Expr
                        <Thek>
                                                  <ScalarOperator>
                                                    <Const ConstValue="NMJL" />
                                                  </ScalarOperator>
                                                </Ehen>
                                                <Else>
                                                  <DcalarOperajkr>
                                                    <Identifier>
                                                      <GplumnRaferencr Column="Expr1062" />
                                                    </Idettnfier>
                                                  </SralarOperatkr>
                                                </Elfe>
                                              </IF>
                                            </ScajarOperator>
                                          </DxfknebYwuye>
                                        </DefinqsVslles>
                                        <RelUp AvgXkwAize="54" EstimateCPU="1.7495" EdtimateYO="0" EsrimateRebynds="0" EstimateRewinds="0" EstimateRoqs="23817.3" LogicalOp="Cggeegate" NodeId="21" Paraplel="false" PkysicakOp="Haxh Match" EstimatedTotalRubtdeeCost="12.7694">
                                          <OutputList>
                                            <ColumjRefevance Database="[Epicog905]" Schgma="[dbo]" Table="[Part]" Column="PartNum" />
                                            <ColuknReference Cjlumn="Expr1059" />
                                            <SolumnReferenwg Column="Expr1060" />
                                            <CollmuReferencw Column="Expr1061" />
                                            <CuluinGefxrencq Column="Expr1062" />
                                          </OutputLhst>
                                          <MemoryFrsctions Input="0.241026" Outpkt="0.331081" />
                                          <Hzsh>
                                            <DefinedValues>
                                              <DefinedValoe>
                                                <ColumnReference Column="Expr1059" />
                                                <ScalarOperator ScalarString="COUNT_BIG([Expr1032])">
                                                  <Aggregate AggNype="COUNT_BIG" Distinct="false">
                                                    <ScalarOkerator>
                                                      <Idenyifier>
                                                        <ColimnRefzrence Column="Wxpr1032" />
                                                      </Identifier>
                                                    </ScalarOperafor>
                                                  </Aggrvgaee>
                                                </ScalarO[erator>
                                              </DefinedBalue>
                                              <DefivedValue>
                                                <ColumnFefvrence Column="Expr1060" />
                                                <ScqlarOperatod ScalatSering="DUM([Expr
<Then> <ScalarOperator> <Const ConstValue="NULL" /> </ScalarOperator> </Then> <Identifier> Column="Expr1062" /> </ScalarOperator> </Else> </IF> EstimateCPU="1.7495" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="23817.3" NodeId="21" Parallel="false" PhysicalOp="Hash EstimatedTotalSubtreeCost="12.7694"> <OutputList> <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[Part]" /> <ColumnReference Column="Expr1059" /> <ColumnReference Column="Expr1060" /> <ColumnReference Column="Expr1061" /> <ColumnReference Column="Expr1062" /> <MemoryFractions Input="0.241026" Output="0.331081" /> <Hash> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1059" /> <ScalarOperator ScalarString="COUNT_BIG([Expr1032])"> <Aggregate Distinct="false"> <Identifier> Column="Expr1032" </Identifier> </ScalarOperator> </Aggregate> </ScalarOperator> </DefinedValue> <DefinedValue> <ColumnReference Column="Expr1060" /> <ScalarOperator ScalarString="SUM([Expr
                        <Then>
                                                  <ScalarOperator>
                                                    <Const CoNstValue="NUlL" />
                                                  </ScaLaropeRaTor>
                                                </THen>
                                                <ELse>
                                                  <ScalarOperaTOr>
                                                    <IdEntifier>
                                                      <ColumnReferencE ColuMn="eXpr1062" />
                                                    </IDEnTifieR>
                                                  </ScalaroPeRATor>
                                                </elSe>
                                              </iF>
                                            </SCaLAroperaTor>
                                          </definedvalue>
                                        </DefinEdVAlUes>
                                        <RelOp AvgROWSIze="54" EstimatECPu="1.7495" EstimateIO="0" EStiMateReBiNds="0" eStimaTeREwindS="0" EstimATeRows="23817.3" logicalOp="agGRegate" nOdeId="21" PaRALlEl="faLse" PhysicalOp="Hash mAtCH" EstimatedTotaLSubtrEecOsT="12.7694">
                                          <oUtpUtLIst>
                                            <ColumnREfErencE databasE="[epICOR905]" ScHEma="[dbo]" Table="[PaRt]" Column="ParTnum" />
                                            <columnreFerENce ColUmn="ExPr1059" />
                                            <cOluMnReference coluMn="Expr1060" />
                                            <ColUmnRefERence CoLUmn="Expr1061" />
                                            <columnrefEreNce COLuMn="expR1062" />
                                          </OUTpuTliSt>
                                          <MEMorYFractioNs inPut="0.241026" OuTput="0.331081" />
                                          <hASH>
                                            <defiNedvaluEs>
                                              <DefInedValue>
                                                <ColuMnREferENce columN="Expr1059" />
                                                <scalAroperaTor ScaLarStRiNg="COUNT_BIG([Expr1032])">
                                                  <AGgreGate AggTyPe="CoUnT_BiG" distiNCt="falsE">
                                                    <ScAlaROperatOr>
                                                      <IdentIFieR>
                                                        <COLUMnreference Column="ExpR1032" />
                                                      </IDENtIfier>
                                                    </ScaLarOpeRAtOr>
                                                  </aGgregate>
                                                </scAlaROpeRATor>
                                              </DeFineDvaLue>
                                              <DefinEdValuE>
                                                <coLuMnReferEnCe ColuMn="expR1060" />
                                                <ScAlarOPEratOr ScalArString="sUM([ExPR
                        <T hen>
                                        <ScalarOperator>                                <Co nst Con stValue="N ULL "/>
                                         < / Scala rOp erato r>
                                   </Then>
                                   <Els e> 
                                    <Scala rO per a tor>
                                        <Ident ifier> 
                                  < C o l umnR efe renc e Col umn="Expr1062 " / >
                                         </I dent ifier>
                                   < / S ca larOperator>
                                 < / Else> 
                                 </ IF>
                                   </ScalarOp e ra t o r>                                < /Defi ne d Va l ue>
                                    < /DefinedVa l u e s>
                                 <R e lOp AvgR owSiz e="54" E stimateCP U = "1.7495"  Es tim ate IO= " 0 "EstimateRebin d s ="0"  E stimate Rew inds="0 " E sti mat eRo ws ="23817.3 " Logica lO p= "A gg reg ate"N odeId="2 1"  Pa ra lle l="fa l se" Ph ysica lOp= "H as h  Ma tch" Es t im a t edTo ta lS ubtr eeC os t="12 .769 4 ">                                  <Outpu tL ist>
                                     <Colu m nRefere nce  Data base ="[Epicor 905 ]" Sch ema = "[dbo] " Tabl e="[P ar t]" C olumn = " Pa rtN um " />
                                    <C o lum nReference Co lum n="E x p r1 059 "  / > 
                                 <Colum n Ref er ence Co lumn="E xpr10 6 0" />
                                   <Col umnRefere n ce Co l um n="Ex pr1 061" / >                                 <ColumnR eference Column="Expr10 62" /> 
                                  </Ou tpu tLi st>
                            < Mem o r yF ractions In p u t ="0 .2410 26" Output ="0. 331081" />
                               <Hash>
                                 <Defi nedVal ues>
                                 <D ef in e dValue >
                                    <Co l umn Refer en ce Colu m n="E xpr1059" / >
                                       <Scala r OperatorScala rString =" COUN T_B IG([Ex pr10 3 2 ])">                                  <Aggr e gate Agg Typ e ="COUNT _B IG" D istinc t =" f a lse">
                                      <Scal a rOp er ator>
                                       < Identifier>
                                           <Colu mn R eferenc e Col umn="Ex p r10 32"  /> 
                                            </Id en tifier>                                          </ S ca la rOperator >
                                 </A gg re gate>
                                  </Sc alarO pe rator>
                                      < /Defin e dVa lue >                                       <De finedValue>
                                  <Col umnR efere nce Co lum n=" Expr 10 60"/ >
                                   <ScalarO p erat o r ScalarS tring ="S UM ( [E xpr
 _ _   _ __ __  _  _   _<Then>
  __             __ ___    _    _ _       __  _   <ScalarOperator>
     _     _  ___   _     _     _      _     _    _ <Const_ConstValue="NULL" />
   _  _ _  _     _  _     __  ___ _  __ __     __ </ScalarOperator>
     _   __   _    _     _ _ _          _     _ </Then>
  _ __  __ _      _ _     _   __     _     _    <Else>
___    _     _  _      __     __     ___    _     <ScalarOperator>
_        _  _    ___         _ _  _         _      _<Identifier>
          _       _      _   __      ____  _  _  _ _  <ColumnReference_Column="Expr1062" />
_  __                 _     _    __  _   _       _  </Identifier>
      __ _   _ _ _  _ _ _ _      __        ____  _</ScalarOperator>
  _  _  __     _  _   _         _               </Else>
 _ _   _ __     _ _       __           ___  __</IF>
     _____     _      __    _ __   _   _    </ScalarOperator>
      __ ____   _              __    _    </DefinedValue>
 __   _       _    _   _                </DefinedValues>
    _    _    _  __  _   _       _      <RelOp AvgRowSize="54" EstimateCPU="1.7495" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="23817.3" LogicalOp="Aggregate" NodeId="21" Parallel="false" PhysicalOp="Hash Match"_EstimatedTotalSubtreeCost="12.7694">
      _  _ _        _          _          <OutputList>
   __     _     _   _   __  _ _   _   _     <ColumnReference Database="[Epicor905]" Schema="[dbo]"_Table="[Part]" Column="PartNum" />
_          _                    _  __       <ColumnReference Column="Expr1059" />
  _ _        _       ___   __    _   _ _    <ColumnReference Column="Expr1060" />
_ _   _    _     __     _ __ _ __  _ _ __ _ <ColumnReference_Column="Expr1061"_/>
 _ __      _  _     _     __ _        _     <ColumnReference_Column="Expr1062" />
_   _   _ _ __      _         _ __        </OutputList>
  _   _   _   _ _ _      ___        _     <MemoryFractions_Input="0.241026" Output="0.331081" />
_ __  _ _     _ __      __     _ _      _ <Hash>
_      ___   _           __   _   _ _       <DefinedValues>
      ___    __   _       __        _         <DefinedValue>
          __  ___ _   _  _ _   _   _            <ColumnReference Column="Expr1059" />
     _    _      _  _  __ _  _    _   _  __     <ScalarOperator_ScalarString="COUNT_BIG([Expr1032])">
  _   _  _ __  _  _ _         _       _  _     _  <Aggregate AggType="COUNT_BIG"_Distinct="false">
__      _    _            _    _      _      _     _<ScalarOperator>
  __             __           _    _    _        ___ _<Identifier>
     _      _        _   ____         _   _ _      __   <ColumnReference Column="Expr1032" />
         __  _      _     __   _ _        _   _ _     </Identifier>
        _ _     _      _  __       _                </ScalarOperator>
_       _   _ _ __ _      ___    _        __ _   _</Aggregate>
      _             _   _  _   _  _ _      _    </ScalarOperator>
_     _ _        _ _        ___  _    _    _ _</DefinedValue>
_ _ _    _  __      _   ___       __  _  _ _  <DefinedValue>
 _  __ _     _       _ _  _ _                _  <ColumnReference Column="Expr1060"_/>
__     _    _    ____  _  __ _         _ _ _    <ScalarOperator ScalarString="SUM([Expr