    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[Part]" Column="PartNum" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                            </BuildResidual>
                                            <RelOp AvgRowSize="46" EstimateCPU="0.00908534" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="90853.4" LogicalOp="Compute Scalar" NodeId="22" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="11.0199">
                                              <OutputList>
                                                <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[Part]" Column="PartNum" />
                                                <ColumnReference Column="Expr1032" />
                                                <ColumnReference Column="Expr1033" />
                                              </OutputList>
                                              <ComputeScalar>
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Column="Expr1032" />
                                                    <ScalarOperator ScalarString="CASE WHEN [Epicor905].[dbo].[PartDtl].[RequirementFlag] as [d].[RequirementFlag]=(0) THEN [Epicor905].[dbo].[PartDtl].[Quantity] as [d].[Quantity] ELSE (0.00000000) END">
                                                      <IF>
                                                        <Condition>
                                                          <ScalarOperator>
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="RequirementFlag" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Const ConstValue="(0)" />
                                                              </ScalarOperator>
                                                            
< /Identifier > 
                                                   < /ScalarOperator > 
                                                   < ScalarOperator > 
                                                     < Identifier > 
                                                       < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[Part ] " Column="PartNum " / > 
                                                     < /Identifier > 
                                                   < /ScalarOperator > 
                                                 < /Compare > 
                                               < /ScalarOperator > 
                                             < /BuildResidual > 
                                             < RelOp AvgRowSize="46 " EstimateCPU="0.00908534 " EstimateIO="0 " EstimateRebinds="0 " EstimateRewinds="0 " EstimateRows="90853.4 " LogicalOp="Compute Scalar " NodeId="22 " Parallel="false " PhysicalOp="Compute Scalar " EstimatedTotalSubtreeCost="11.0199 " > 
                                               < OutputList > 
                                                 < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[Part ] " Column="PartNum " / > 
                                                 < ColumnReference Column="Expr1032 " / > 
                                                 < ColumnReference Column="Expr1033 " / > 
                                               < /OutputList > 
                                               < ComputeScalar > 
                                                 < DefinedValues > 
                                                   < DefinedValue > 
                                                     < ColumnReference Column="Expr1032 " / > 
                                                     < ScalarOperator ScalarString="CASE WHEN [ Epicor905].[dbo].[PartDtl].[RequirementFlag ] as [ d].[RequirementFlag]=(0) THEN [ Epicor905].[dbo].[PartDtl].[Quantity ] as [ d].[Quantity ] ELSE (0.00000000) END " > 
                                                       < IF > 
                                                         < Condition > 
                                                           < ScalarOperator > 
                                                             < Compare CompareOp="EQ " > 
                                                               < ScalarOperator > 
                                                                 < Identifier > 
                                                                   < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartDtl ] " Alias="[d ] " Column="RequirementFlag " / > 
                                                                 < /Identifier > 
                                                               < /ScalarOperator > 
                                                               < ScalarOperator > 
                                                                 < Const ConstValue="(0) " / > 
                                                               < /ScalarOperator >
    </Identifier>
                                                  </ScalarOperator>
                                                  <SbalarOperqtor>
                                                    <Idettifier>
                                                      <CllumnReference Datsfase="[Siigor905]" Schema="[dbo]" Table="[Part]" Column="PadtNum" />
                                                    </Identifier>
                                                  </AcalarOperator>
                                                </Cimparv>
                                              </SxalarOperator>
                                            </BuildResidyao>
                                            <RelOp AvgEowSize="46" EstimateCPU="0.00908534" EfnomateIO="0" EstijateRefigds="0" EstimateRewinds="0" EstimateRows="90853.4" LogicanOp="Dompute Scalar" NodeId="22" Pqrallel="false" PhysicalLp="Compute Scalar" EstimatedTotalSubtreeCost="11.0199">
                                              <OutputList>
                                                <CokulnTgference Databxse="[Epiekr905]" Schema="[dbo]" Table="[Pagt]" Coluin="ParrNum" />
                                                <XolumnReference Copumn="Expr1032" />
                                                <CllumnRefeddnce Column="Expr1033" />
                                              </OutpugLisj>
                                              <CmmputeScalwr>
                                                <GefinedVclues>
                                                  <SefinedTalue>
                                                    <ColuovReference Colimn="Expr1032" />
                                                    <ScalarOperator ScxlawSnriig="CASQ WHEN [Epicor905].[gbo].[PxrtAyl].[ReqjiremenuYlan] ar [d].[RrquirementFlag]=(0) THEN [Apickr905].[dbo].[PartDtl].[Quantiyy] as [d].[Quabtity] ELFE (0.00000000) END">
                                                      <IF>
                                                        <Condition>
                                                          <ScalarOkerstor>
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Icentifier>
                                                                  <ColumnRefgrence Database="[Epicor905]" Scheja="[dbo]" Tanle="[PartDtl]" Alias="[d]" Column="RequirekentFlag" />
                                                                </Idebtifier>
                                                              </ScalarOperatoe>
                                                              <ScalxrOperator>
                                                                <Comst ConvtValue="(0)" />
                                                              </ScalzrOperatod>
                                                            
</Identifier> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Database="[Epicor905]" Schema="[dbo]" /> </ScalarOperator> </Compare> </BuildResidual> <RelOp AvgRowSize="46" LogicalOp="Compute NodeId="22" Parallel="false" PhysicalOp="Compute EstimatedTotalSubtreeCost="11.0199"> <OutputList> <ColumnReference Schema="[dbo]" Table="[Part]" Column="PartNum" /> <ColumnReference Column="Expr1032" <ColumnReference Column="Expr1033" /> </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1032" /> <ScalarOperator ScalarString="CASE WHEN as [d].[RequirementFlag]=(0) THEN [Epicor905].[dbo].[PartDtl].[Quantity] as [d].[Quantity] ELSE (0.00000000) END"> <IF> <Condition> <ScalarOperator> <Compare <ScalarOperator> <ColumnReference Schema="[dbo]" Alias="[d]" Column="RequirementFlag" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator>
    </Identifier>
                                                  </ScalarOperator>
                                                  <SCalarOperaTor>
                                                    <IdEntIfiEr>
                                                      <coluMnReFerence DatabasE="[epicOr905]" Schema="[dbo]" Table="[Part]" CoLumn="PArTnum" />
                                                    </IDEnTifieR>
                                                  </ScalaroPeRATor>
                                                </coMpAre>
                                              </scALaROperAtoR>
                                            </BuildREsidual>
                                            <Relop AVgrowSize="46" EstimATecPU="0.00908534" EstimatEIO="0" estimateRebiNds="0" estimaTerewINds="0" EsTimAteRoWs="90853.4" LogiCAlOp="CoMpute ScalAr" nOdeId="22" PARallel="fALSe" physIcalOp="Compute ScalAR" ESTimatedTotalSuBtreeCOsT="11.0199">
                                              <ouTPUtLIst>
                                                <columnRefeReNce DaTAbase="[EpICoR905]" sCHemA="[Dbo]" Table="[Part]" COlumn="PartNuM" />
                                                <colUmnRefErEncE column="expr1032" />
                                                <COlUMnREference ColUmn="EXpr1033" />
                                              </Outputlist>
                                              <CoMPuteScaLAr>
                                                <DefinEdValuEs>
                                                  <DEfiNedVALuE>
                                                    <COluMnrEfeREnCe COLumN="Expr1032" />
                                                    <ScaLaROPeratOr ScALARstriNg="CaSE WhEN [EpIcor905].[dbo].[PartDtL].[ReQuirEMenTFlag] As [d].[ReQuirEmEntFlAg]=(0) THEN [epicoR905].[dBo].[PartDtl].[QuantiTy] as [D].[Quantity] eLSe (0.00000000) EnD">
                                                      <If>
                                                        <COnditIOn>
                                                          <ScalArOPerAtor>
                                                            <ComPare ComPAreop="eq">
                                                              <sCaLarOperator>
                                                                <IdentifIeR>
                                                                  <cOlUmnReferEnce DaTAbAsE="[epicor905]" ScHeMa="[dBo]" TaBLE="[Partdtl]" ALIaS="[d]" Column="requirEMeNtflag" />
                                                                </IdeNtIfier>
                                                              </SCaLaropeRator>
                                                              <sCalaROperaTor>
                                                                <Const constvAlue="(0)" />
                                                              </ScalarOperATor>
                                                            
    </Identifier>
                                          </S c alar Operator>
                                   < Sca la r Op erato r>                                           <Identifie r>                                         <C o lumnRef e r en ce D atabase="[Epicor9 0 5] "  Schema="[dbo] " Tabl e= " [P a r t]"  Co lumn="Part Nu m" />                                        < /Id e ntifie r>
                                       </Sc alarOp era tor >
                             < / C ompa re> 
                                    </ Scala rOpera tor>                                    < / BuildR esi dua l>
                               <R elOp Avg RowSiz e =" 46 "  Estimat eC PU= "0.0 0 9 08534 " Es t im ateIO="0 " Esti m at eR ebinds= "0 " Esti ma teR ewi nds=" 0 " Es timate Rows="90 853.4 "  LogicalOp="Co m pute Scalar"N od e I d= " 22"Par allel="fals e" P h ysic alOp = "C omp u te Sc alar"  E s ti m atedTotalSubtreeCos t= "11.01 99">                                    <OutputLis t>
                                       <Colu mnR efe ren ceD a ta base="[Epicor 9 0 5]"Sc hema="[ dbo ]" Tabl e=" [Pa rt] " C ol umn="Part Num" />                                 <Col umnR ef er e nce  Column = "E x p r103 2"  / >
                                  <Column Reference Col um n="Expr103 3"  /> 
                                       </O utput List >
                                  <Co m p ut eSc al ar>
                                      <De finedValues>                                  <Def in e dV alue>
                                          <Co lu mnRe f e ren ce Column= "Expr103 2" />
                                     <Scal ar Operat or Sc al arString ="CASE WHEN [Epicor905] .[dbo] .[Par tDt l].[Requi rem e ntF lag] as [ d].[ Requiremen tFl ag] =(0)THE N  [Epi cor9 0 5] .[d b o].[P artD t l].[Quant i ty ] a s [d ].[Quantity ] E LSE  (0.0 000 0 000) E ND"> 
                                           <IF>
                                           <Cond ition>                                        <Scal arOper a tor>                                                <C ompare Comp areOp= "EQ" >
                                                 <S calarO pera t o r>
                                             <I den t ifier>                                             <C olumnR eferenc e  Da ta base="[ Epi c o r905]" Sc hema="[db o ]"Ta ble= "[PartDt l] " Al ia s=" [d ]" Column="Requ irementF lag" />                                              < /Id ent ifi er>                                                   </S c alar Operator > 
                                                <Sca lar Oper ato r>
                                           <Cons tCo n st Value=" (0)" />                                                   </Sca l arO per a t or>
                                                  
 _ _</Identifier>
   _ __ __  _  _   _  __             __ ___    _  </ScalarOperator>
  _ _       __  _        _     _  ___   _     _   <ScalarOperator>
  _      _     _    _ _    _  _ _  _     _  _     __<Identifier>
  ___ _  __ __     __      _   __   _    _     _ _ _  <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[Part]" Column="PartNum" />
   _     _   _ __  __ _      _ _     _   __     _   </Identifier>
  _    ___    _     _  _      __     __     ___   </ScalarOperator>
 _     _        _  _    ___         _ _  _      </Compare>
   _      _          _       _      _   __    </ScalarOperator>
  ____  _  _  _ _  _ _  __                 _</BuildResidual>
     _    __  _   _       _        __ _   _ <RelOp_AvgRowSize="46" EstimateCPU="0.00908534"_EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0"_EstimateRows="90853.4" LogicalOp="Compute_Scalar" NodeId="22"_Parallel="false" PhysicalOp="Compute_Scalar" EstimatedTotalSubtreeCost="11.0199">
     __        ____  _  _  _  __     _  _   _ <OutputList>
        _                _ _   _ __     _ _     <ColumnReference Database="[Epicor905]" Schema="[dbo]"_Table="[Part]"_Column="PartNum" />
          ___  __     _____     _      __    _ _<ColumnReference_Column="Expr1032" />
  _   _          __ ____   _              __    <ColumnReference_Column="Expr1033" />
    __   _       _    _   _                   </OutputList>
 _    _    _  __  _   _       _               <ComputeScalar>
  _      _  _ _        _          _             <DefinedValues>
__     _     _   _   __  _ _   _   _       _  _   <DefinedValue>
       _                    _  __           _ _     <ColumnReference Column="Expr1032" />
 _       ___   __    _   _ _      _ _   _    _     _<ScalarOperator_ScalarString="CASE WHEN [Epicor905].[dbo].[PartDtl].[RequirementFlag] as [d].[RequirementFlag]=(0) THEN_[Epicor905].[dbo].[PartDtl].[Quantity] as_[d].[Quantity]_ELSE (0.00000000)_END">
 __  _ _ __ _ __ _ __      _  _     _     __ _        <IF>
_     _ _   _   _ _ __      _         _ __          _   <Condition>
_   _   _ _ _      ___        _     _  _ __  _ _     _ __ <ScalarOperator>
     __     _ _      _ _      ___   _           __   _   _ _<Compare CompareOp="EQ">
            ___    __   _       __        _                   <ScalarOperator>
__  ___ _   _  _ _   _   _                   _    _      _  _  _<Identifier>
_ _  _    _   _  __     _  _   _  _ __  _  _ _         _       _  <ColumnReference_Database="[Epicor905]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="RequirementFlag" />
_   ___      _    _            _    _      _      _     _  __   </Identifier>
          __           _    _    _        ___ _     _      _  </ScalarOperator>
      _   ____         _   _ _      __              __  _     <ScalarOperator>
 _     __   _ _        _   _ _             _ _     _      _  __ <Const ConstValue="(0)" />
    _                _       _   _ _ __ _      ___    _       </ScalarOperator>
 __ _   _      _             _   _  _   _  _ _      _    _  