].[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="[PartWhse]" Alias="[b]" Column="PartNum" />                                                         </Identifier>                                                       </ScalarOperator>                                                     </Compare>                                                   </ScalarOperator>                                                 </Residual>                                                 <RelOp AvgRowSize="00" EstimateCPU="0.0000000" EstimateIO="0.000000" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="00000" LogicalOp="Index Seek" NodeId="0" 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="[PartWhse]" Alias="[b]" Column="PartNum" />                                                     <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartWhse]" Alias="[b]" Column="OnHandQty" />                                                   </OutputList>                                                   <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">                                                     <DefinedValues>                                                       <DefinedValue>                                                         <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartWhse]" Alias="[b]" Column="PartNum" />                                                       </DefinedValue>                                                       <DefinedValue>                                                         <ColumnReference Database="[Epicor000]" Schema="[dbo]" Table="[PartWhse]" Alias="[b]" Column="OnHandQty" />                                                       </DefinedValue>                                                     </DefinedValues>                                                     <Object Database="[Epicor000]" Schema="[dbo]" Table="[PartWhse]" 