].[PartNum]">                                                         <Compare CompareOp="EQ">                                                           <ScalarOperator>                                                             <Identifier>                                                               <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Column="PartNum" />                                                             </Identifier>                                                           </ScalarOperator>                                                           <ScalarOperator>                                                             <Identifier>                                                               <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="PartNum" />                                                             </Identifier>                                                           </ScalarOperator>                                                         </Compare>                                                       </ScalarOperator>                                                     </ProbeResidual>                                                     <RelOp AvgRowSize="00" EstimateCPU="0.0000000" EstimateIO="0.000000" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="00000" LogicalOp="Index Seek" NodeId="00" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.000000" TableCardinality="00000">                                                       <OutputList>                                                         <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Column="PartNum" />                                                       </OutputList>                                                       <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">                                                         <DefinedValues>                                                           <DefinedValue>                                                             <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Column="PartNum" />                                                           </DefinedValue>                                                         </DefinedValues>                                                         <Object Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Index="[TypePart]" TableReferenceId="0" IndexKind="NonClustered" />                                                         <SeekPredicates>                                                           <SeekPredicateNew>                                                             <SeekKeys>                                                               <Prefix ScanType="EQ">                                                                 <RangeColumns>                                                                   <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Column="Company" />                                                                   <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[Part]" Column="TypeCode" />                                                                 </RangeColumns>                                                                 <RangeExpressions>                                                                   <ScalarOperator ScalarString="'Bruce'">                                                                     <Const ConstValue="'Bruce'" />                                                                   </ScalarOperator>                                                                   <ScalarOperator ScalarString="'P'">                                                                     <Const ConstValue="'P'" />                                                                   </ScalarOperator>                                                                 </RangeExpressions>                                                               </Prefix>                                                             </SeekKeys>                                                           </SeekPredicateNew>                                                         </SeekPredicates>                                                       </IndexScan>                                                     </RelOp>                                                     <RelOp AvgRowSize="00" EstimateCPU="0.0000000" EstimateIO="0.00000" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="00000.0" LogicalOp="Clustered Index Seek" NodeId="00" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00000" TableCardinality="000000">                                                       <OutputList>                                                         <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="PartNum" />                                                         <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="RequirementFlag" />                                                         <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="Quantity" />                                                       </OutputList>                                                       <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">                                                         <DefinedValues>                                                           <DefinedValue>                                                             <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="PartNum" />                                                           </DefinedValue>                                                           <DefinedValue>                                                             <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="RequirementFlag" />                                                           </DefinedValue>                                                           <DefinedValue>                                                             <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" Alias="[d]" Column="Quantity" />                                                           </DefinedValue>                                                         </DefinedValues>                                                         <Object Database="[Epicor000]" Schema="[dbo]" Table="[PartDtl]" 