Index: branches/IBSRegularRelease/TIBCOApp/IBSPartMgmt/BW/IBSPartMgmt/Processes/ActionProcess/Part/ListSupersede.process
===================================================================
diff -u -r240972 -r241019
--- branches/IBSRegularRelease/TIBCOApp/IBSPartMgmt/BW/IBSPartMgmt/Processes/ActionProcess/Part/ListSupersede.process	(.../ListSupersede.process)	(revision 240972)
+++ branches/IBSRegularRelease/TIBCOApp/IBSPartMgmt/BW/IBSPartMgmt/Processes/ActionProcess/Part/ListSupersede.process	(.../ListSupersede.process)	(revision 241019)
@@ -234,7 +234,7 @@
                     </xsl:when>
                     <xsl:otherwise>
                         <statement>
-                            <xsl:value-of select="concat('select * from(select /+ parallel(4)/ROWNUM rnum, a.PT_NUM &quot;P_PartNumber&quot;, a.FLD_LN_ABBR_CD &quot;P_LineAbbrev&quot;,a.PT_DESC &quot;P_PartDesc&quot;, b.ORIG_PT_NUM &quot;C_PartNumber&quot;,b.ORIG_FLD_LN_ABBR_CD &quot;C_LineAbbrev&quot; , b.ORIG_PT_DESC &quot;C_PartDesc&quot;,b.SPRSD_TYP_CD &quot;C_SupersedeType&quot;,b.TFR_STK_LVL_FLAG &quot;C_TransferStockingLevenFlag&quot;, b.TFR_SAL_HIST_FLAG &quot;C_TransferSalesHistoryFlag&quot;  from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.PT_SPRSD a,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.PT_SPRSD_ITM b where a.PT_SPRSD_ID=b.PT_SPRSD_ID  and  b.STAT_CD=',&quot;'ACTIVE'&quot;,' and a.IBS_LOC_ID=',$Start/root/pfx:ListSupersedeReq/pfx:LocationID,')  WHERE rnum BETWEEN ',$StartRow,' AND ',$EndRow)"/>
+                            <xsl:value-of select="concat('select * from(select /* + parallel(4)*/ROWNUM rnum, a.PT_NUM &quot;P_PartNumber&quot;, a.FLD_LN_ABBR_CD &quot;P_LineAbbrev&quot;,a.PT_DESC &quot;P_PartDesc&quot;, b.ORIG_PT_NUM &quot;C_PartNumber&quot;,b.ORIG_FLD_LN_ABBR_CD &quot;C_LineAbbrev&quot; , b.ORIG_PT_DESC &quot;C_PartDesc&quot;,b.SPRSD_TYP_CD &quot;C_SupersedeType&quot;,b.TFR_STK_LVL_FLAG &quot;C_TransferStockingLevenFlag&quot;, b.TFR_SAL_HIST_FLAG &quot;C_TransferSalesHistoryFlag&quot;  from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.PT_SPRSD a,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.PT_SPRSD_ITM b where a.PT_SPRSD_ID=b.PT_SPRSD_ID  and  b.STAT_CD=',&quot;'ACTIVE'&quot;,' and a.IBS_LOC_ID=',$Start/root/pfx:ListSupersedeReq/pfx:LocationID,')  WHERE rnum BETWEEN ',$StartRow,' AND ',$EndRow)"/>
                         </statement>
                     </xsl:otherwise>
                 </xsl:choose>