">                                                   <ScalarOperator>                                                     <Identifier>                                                       <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Column="PartNum" />                                                     </Identifier>                                                   </ScalarOperator>                                                   <ScalarOperator>                                                     <Identifier>                                                       <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Column="PartNum" />                                                     </Identifier>                                                   </ScalarOperator>                                                 </Compare>                                               </ScalarOperator>                                             </BuildResidual>                                             <RelOp AvgRowSize="00" EstimateCPU="0.00000000" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="00000.0" LogicalOp="Compute Scalar" NodeId="00" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="00.0000">                                               <OutputList>                                                 <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Column="PartNum" />                                                 <ColumnReference Column="Expr0000" />                                                 <ColumnReference Column="Expr0000" />                                               </OutputList>                                               <ComputeScalar>                                                 <DefinedValues>                                                   <DefinedValue>                                                     <ColumnReference Column="Expr0000" />                                                     <ScalarOperator ScalarString="CASE WHEN [Epicor000].[dbo].[PartDtl].[RequirementFlag] as [d].[RequirementFlag]=(0) THEN [Epicor000].[dbo].[PartDtl].[Quantity] as [d].[Quantity] ELSE (0.00000000) END">                                                       <IF>                                                         <Condition>                                                           <ScalarOperator>                                                             <Compare CompareOp="EQ">                                                               <ScalarOperator>                                                                 <Identifier>                                                                   <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="RequirementFlag" />                                                                 </Identifier>                                                               </ScalarOperator>                                                               <ScalarOperator>                                                                 <Const ConstValue="(0)" />                                                               </ScalarOperator>                                                             </Compare>                                                           </ScalarOperator>                                                         </Condition>                                                         <Then>                                                           <ScalarOperator>                                                             <Identifier>                                                               <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="Quantity" />                                                             </Identifier>                                                           </ScalarOperator>                                                         </Then>                                                         <Else>                                                           <ScalarOperator>                                                             <Const ConstValue="(0.00000000)" />                                                           </ScalarOperator>                                                         </Else>                                                       </IF>                                                     </ScalarOperator>                                                   </DefinedValue>                                                   <DefinedValue>                                                     <ColumnReference Column="Expr0000" />                                                     <ScalarOperator ScalarString="CASE WHEN [Epicor000].[dbo].[PartDtl].[RequirementFlag] as [d].[RequirementFlag]=(0) THEN [Epicor000].[dbo].[PartDtl].[Quantity] as [d].[Quantity] ELSE (0.00000000) END">                                                       <IF>                                                         <Condition>                                                           <ScalarOperator>                                                             <Compare CompareOp="EQ">                                                               <ScalarOperator>                                                                 <Identifier>                                                                   <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="RequirementFlag" />                                                                 </Identifier>                                                               </ScalarOperator>                                                               <ScalarOperator>                                                                 <Const ConstValue="(0)" />                                                               </ScalarOperator>                                                             </Compare>                                                           </ScalarOperator>                                                         </Condition>                                                         <Then>                                                           <ScalarOperator>                                                             <Identifier>                                                               <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="Quantity" />                                                             </Identifier>                                                           </ScalarOperator>                                                         </Then>                                                         <Else>                                                           <ScalarOperator>                                                             <Const ConstValue="(0.00000000)" />                                                           </ScalarOperator>                                                         </Else>                                                       </IF>                                                     </ScalarOperator>                                                   </DefinedValue>                                                 </DefinedValues>                                                 <RelOp AvgRowSize="00" EstimateCPU="0.00000" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="00000.0" LogicalOp="L