Bad Query XML:
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1.1" Build="10.0.5500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="185.487" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="216.809" StatementText="SELECT 'A' AS tab ,0 AS tag ,t.subscription_id ,t.article ,t.control ,t.frequency ,t.start_day ,t.participant_id ,t.legacy_part_id ,t.description ,t.quantity ,t.zone ,t.pickup_flag ,t.date_from ,t.date_to ,t.wear_select_dt ,t.manually_closed ,t.apar_id ,t.apar_name ,t.ext_apar_ref ,t.parent_cas_id ,t.art_descr ,t.agree_item_id ,t.report_flag ,t.customer_key ,t.dose_category ,t.dosimeter_use ,t.cust ,t.sequence_no ,t.level ,t.product_line ,t.al_create_date ,t.al_date_to FROM aq1viagreeitem t WHERE 1=1 AND t.parent_cas_id='10922' ORDER BY 1 " StatementType="SELECT" ParameterizedText="(@0 int,@1 int,@2 varchar(8000))select 'A' as tab , 0 as tag , t . subscription_id , t . article , t . control , t . frequency , t . start_day , t . participant_id , t . legacy_part_id , t . description , t . quantity , t . zone , t . pickup_flag , t . date_from , t . date_to , t . wear_select_dt , t . manually_closed , t . apar_id , t . apar_name , t . ext_apar_ref , t . parent_cas_id , t . art_descr , t . agree_item_id , t . report_flag , t . customer_key , t . dose_category , t . dosimeter_use , t . cust , t . sequence_no , t . level , t . product_line , t . al_create_date , t . al_date_to from aq1viagreeitem t where @0 = @1 and t . parent_cas_id = @2 order by 1" QueryHash="0xFBA5C36153A5C81E" QueryPlanHash="0x1331CB96C51B9261">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan CachedPlanSize="320" CompileTime="5174" CompileCPU="4765" CompileMemory="67584">
<RelOp AvgRowSize="389" EstimateCPU="1.85487E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="185.487" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="216.809">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Column="Expr1023" />
<ColumnReference Column="Expr1027" />
<ColumnReference Column="Expr1028" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1023" />
<ScalarOperator ScalarString="CASE WHEN [Expr1032]=(1) THEN [PRODSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id] ELSE CASE WHEN CONVERT_IMPLICIT(int,[PRODSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)=(2) THEN [PRODSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id] ELSE CASE WHEN CONVERT_IMPLICIT(int,[PRODSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)=(3) THEN [PRODSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh2].[parent_cas_id] ELSE NULL END END END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1032" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(3)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1027" />
<ScalarOperator ScalarString="'A'">
<Const ConstValue="'A'" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1028" />
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="398" EstimateCPU="0.0305867" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="185.487" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="216.809">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Parallelism>
<RelOp AvgRowSize="398" EstimateCPU="0.000193834" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="185.487" LogicalOp="Left Outer Join" NodeId="2" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="216.778">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
<ColumnReference Column="Expr1048" />
</OuterReferences>
<RelOp AvgRowSize="394" EstimateCPU="0.000371907" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="185.487" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="216.204">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Column="Expr1047" />
</OuterReferences>
<RelOp AvgRowSize="361" EstimateCPU="37.0299" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="355.892" LogicalOp="Inner Join" NodeId="7" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="215.039">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<MemoryFractions Input="0.742123" Output="0.999494" />
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1agreeitem].[client] as [ai].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client] AND [PRODSERVER].[dbo].[aq1agreeitem].[apar_id] as [ai].[apar_id]=[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xh].[apar_id] AND [PRODSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id]=[PRODSERVER].[dbo].[aq1agreeitem].[subscription_id] as [ai].[subscription_id] AND [PRODSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no]=[PRODSERVER].[dbo].[aq1agreeitem].[sequence_no] as [ai].[sequence_no]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="276" EstimateCPU="2.94011" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Bitmap Create" NodeId="8" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="36.239">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Bitmap>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Bitmap1046" />
</DefinedValue>
</DefinedValues>
<HashKeys>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</HashKeys>
<RelOp AvgRowSize="276" EstimateCPU="2.94011" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Repartition Streams" NodeId="9" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="36.239">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</PartitionColumns>
<RelOp AvgRowSize="276" EstimateCPU="0.805394" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Inner Join" NodeId="10" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="33.2989">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Merge ManyToMany="false">
<InnerSideJoinColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extuidetail].[client] as [xal].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client] AND [PRODSERVER].[dbo].[auiinvdetail].[subscription_id] as [al].[subscription_id]=[PRODSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id] AND [PRODSERVER].[dbo].[auiinvdetail].[sequence_no] as [al].[sequence_no]=[PRODSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="28" EstimateCPU="7.73356" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1153450" LogicalOp="Repartition Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="19.0591">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="28" EstimateCPU="0.317239" EstimateIO="11.0083" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1153450" LogicalOp="Index Scan" NodeId="12" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="11.3255" TableCardinality="1153450">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Index="[IX_AQ1EXTUIDETAIL_SUBSCRIPTID_SEQNO_CLIENT_NEXTWEARBEGIN_PICKUPFLAG_INCL]" Alias="[xal]" IndexKind="NonClustered" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Bitmap1045],[PRODSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id],[PRODSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no],[PRODSERVER].[dbo].[aq1extuidetail].[client] as [xal].[client])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Bitmap1045" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="277" EstimateCPU="7.64282" EstimateIO="0.00281532" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Sort" NodeId="13" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="13.4344">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<MemoryFractions Input="0.952176" Output="0.245598" />
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="277" EstimateCPU="2.83776" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Bitmap Create" NodeId="14" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="5.78877">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Bitmap>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Bitmap1045" />
</DefinedValue>
</DefinedValues>
<HashKeys>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</HashKeys>
<RelOp AvgRowSize="277" EstimateCPU="2.83776" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Repartition Streams" NodeId="15" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="5.78877">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</PartitionColumns>
<RelOp AvgRowSize="277" EstimateCPU="0.377021" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="360786" LogicalOp="Inner Join" NodeId="16" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2.95102">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Column="Expr1044" />
</OuterReferences>
<RelOp AvgRowSize="102" EstimateCPU="1.7388E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Compute Scalar" NodeId="19" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.929839">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
<ColumnReference Column="Expr1032" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1032" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[PRODSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="98" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="20" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.929837">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Column="Expr1043" />
</OuterReferences>
<RelOp AvgRowSize="81" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="22" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.709109">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Column="Expr1042" />
</OuterReferences>
<RelOp AvgRowSize="57" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="24" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.484086">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Column="Expr1041" />
</OuterReferences>
<RelOp AvgRowSize="57" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="26" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.263187">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Column="Expr1040" />
</OuterReferences>
<RelOp AvgRowSize="60" EstimateCPU="7.26819E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Inner Join" NodeId="28" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0385034">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</OuterReferences>
<RelOp AvgRowSize="48" EstimateCPU="1.045E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="29" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0350722">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</OuterReferences>
<RelOp AvgRowSize="35" EstimateCPU="0.0285045" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distribute Streams" NodeId="30" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317876">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<Parallelism PartitioningType="RoundRobin">
<RelOp AvgRowSize="35" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="31" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5241110">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Index="[IX_AGLRELVALUE_RELATTRID_ATTRIBUTEID_ATTVALUE_RELVALUE]" Alias="[r2]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_attr_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="attribute_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'JL85'">
<Const ConstValue="'JL85'" />
</ScalarOperator>
<ScalarOperator ScalarString="'D0'">
<Const ConstValue="'D0'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="26" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="32" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5241110">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Index="[aiaglrelvalue2]" Alias="[r]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="attribute_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_attr_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'D0'">
<Const ConstValue="'D0'" />
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[att_value] as [r2].[att_value]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="'Q50'">
<Const ConstValue="'Q50'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[client] as [r].[client]=[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="29" EstimateCPU="0.000233507" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="69.5521" LogicalOp="Index Seek" NodeId="33" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00335851" TableCardinality="408610">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_AQ1EXTACUHEADER_CLIENT_PARENTCASID]" Alias="[xc]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[@2]">
<Identifier>
<ColumnReference Column="@2" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="68.5521" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="35" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.224611" TableCardinality="408610">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
</OutputList>
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[PK_aq1extacuheader]" Alias="[xc]" TableReferenceId="-1" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xc].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="21" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="68.5521" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="39" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.220826" TableCardinality="408583">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Index="[IX_ACUHEADER_APARID_CLIENT_STATUS_APARGRID]" Alias="[cas]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="status" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[client] as [r2].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="'N'">
<Const ConstValue="'N'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="40" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="68.5521" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="40" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.22495" TableCardinality="408583">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Index="[PK_acuheader]" Alias="[c]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[acuheader].[client] as [cas].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="30" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="68.5521" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="41" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.220655" TableCardinality="408610">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_aq1extacuheader_aparid_client_parentcasid_orglevel]" Alias="[xh]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[acuheader].[client] as [cas].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="195" EstimateCPU="0.005863" EstimateIO="0.181644" EstimateRebinds="57.6699" EstimateRewinds="10.8822" EstimateRows="5187.27" LogicalOp="Index Seek" NodeId="45" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="1.47098" TableCardinality="1153450">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Index="[IX_AUIINVDETAIL_ARTICLE_APARID_STATUS_SUBSCRIPTID_SEQNO_CLIENT_INCL]" Alias="[al]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aglrelvalue].[att_value] as [r2].[att_value]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[auiinvdetail].[client] as [al].[client]=[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
</Bitmap>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
</Parallelism>
</RelOp>
</Bitmap>
</RelOp>
<RelOp AvgRowSize="118" EstimateCPU="19.9154" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4304350" LogicalOp="Repartition Streams" NodeId="47" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="141.77">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</OutputList>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</PartitionColumns>
<RelOp AvgRowSize="118" EstimateCPU="0.301304" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4304350" LogicalOp="Filter" NodeId="48" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="121.855">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="118" EstimateCPU="1.18373" EstimateIO="120.37" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4304350" LogicalOp="Clustered Index Scan" NodeId="49" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="121.554" TableCardinality="4304350">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Index="[aiaq1agreeitem0]" Alias="[ai]" IndexKind="Clustered" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Bitmap1046],[PRODSERVER].[dbo].[aq1agreeitem].[client] as [ai].[client],[PRODSERVER].[dbo].[aq1agreeitem].[apar_id] as [ai].[apar_id],[PRODSERVER].[dbo].[aq1agreeitem].[subscription_id] as [ai].[subscription_id],[PRODSERVER].[dbo].[aq1agreeitem].[sequence_no] as [ai].[sequence_no])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Bitmap1046" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[@0]=[@1]">
<Identifier>
<ColumnReference Column="ConstExpr1029">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@0" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@1" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
<RelOp AvgRowSize="41" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="354.892" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="52" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="1.16475" TableCardinality="7828500">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Index="[PK_aq1participant]" Alias="[p]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="participant_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1agreeitem].[participant_id] as [ai].[participant_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="17" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="184.487" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="53" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.573779">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</OutputList>
<Filter StartupExpression="true">
<RelOp AvgRowSize="17" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="184.487" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="54" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.57369" TableCardinality="408610">
<OutputList>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />
</DefinedValue>
</DefinedValues>
<Object Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_aq1extacuheader_aparid_client_parentcasid_orglevel]" Alias="[xh2]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="apar_id" />
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="client" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[PRODSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">
<Identifier>
<ColumnReference Database="[PRODSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Expr1032]=(3)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1032" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(3)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
</ComputeScalar>
</RelOp>
<ParameterList>
<ColumnReference Column="@2" ParameterCompiledValue="'10922'" />
<ColumnReference Column="@1" ParameterCompiledValue="(1)" />
<ColumnReference Column="@0" ParameterCompiledValue="(1)" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>