Index: branches/IBSRegularRelease/TIBCOApp/IBSReplenishmentMgmt/BW/IBSReplenishmentMgmt/Processes/ActionProcess/ReplenishmentMgmt/ListPartNoStockLevel.process
===================================================================
diff -u -r250081 -r256541
--- branches/IBSRegularRelease/TIBCOApp/IBSReplenishmentMgmt/BW/IBSReplenishmentMgmt/Processes/ActionProcess/ReplenishmentMgmt/ListPartNoStockLevel.process	(.../ListPartNoStockLevel.process)	(revision 250081)
+++ branches/IBSRegularRelease/TIBCOApp/IBSReplenishmentMgmt/BW/IBSReplenishmentMgmt/Processes/ActionProcess/ReplenishmentMgmt/ListPartNoStockLevel.process	(.../ListPartNoStockLevel.process)	(revision 256541)
@@ -247,12 +247,12 @@
                 <xsl:choose>
                     <xsl:when test="count($Start/root/pfx:ListNonPartStockReq/pfx:FilterBy/pfx:filterfields)>0&#xA;and&#xA;string-length($Filters/root/FilterBy)>0">
                         <statement>
-                            <xsl:value-of select="concat('select * from(select ROWNUM rnum,t1.* from (select a.PRIM_VNDR_ID &quot;PrimVendorID&quot;,a.LAST_PUR_VNDR_ID &quot;LastVendorID&quot;,a.PT_NUM &quot;PartNum&quot;,a.FLD_LN_ABBR_CD &quot;LineAbbrev&quot;,a.PT_DESC &quot;PartDesc&quot;, a.NON_STK_PT_SAL_RPT_SUMM_ID &quot;STKPTSALRPTSUMMID&quot;,a.NON_STK_PT_SAL_RPT_DET_ID &quot;STKPTSALRPTDETID&quot;,a.RLNG_12_MO_SAL_QTY &quot;Rling12MSalQty&quot;,a.RLNG_12_MO_SAL_FREQ_VAL &quot;Rling12MSalFreq&quot;,a.CR_DT &quot;CreateDate&quot;,a.CR_BY_NM &quot;CreateBy&quot;,a.UPD_DT &quot;UpdateDate&quot;,a.UPD_BY_NM &quot;UpdateBy&quot;,c.EXT_REF_VNDR_ID &quot;PrimVndrExfRef&quot;,c.VNDR_NM &quot;PrimVndrName&quot; from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.NON_STK_PT_SAL_RPT_DET a,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.NON_STK_PT_SAL_RPT_SUMM b,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR c',&quot; where &#xA;b.IBS_LOC_ID=&quot;,&#xA;$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; and &quot;,'a.NON_STK_PT_SAL_RPT_SUMM_ID in ( select NON_STK_PT_SAL_RPT_SUMM_ID from (select NON_STK_PT_SAL_RPT_SUMM_ID,row_number() over (order by CR_DT desc) from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_RPT_SUMM where ACT_FLAG='Y' and IBS_LOC_ID = &quot;, $Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot;order by CR_DT desc) where rownum='1') and a.PRIM_VNDR_ID=c.IBS_VNDR_ID(+) and a.NON_STK_PT_SAL_RPT_SUMM_ID=b.NON_STK_PT_SAL_RPT_SUMM_ID and &quot;,$Filters/root/FilterBy,' order by ',$Filters/root/SortBy,') t1)&#xA;WHERE rnum BETWEEN ',$StartRow,' AND ',$EndRow)"/>
+                            <xsl:value-of select="concat('select * from(select ROWNUM rnum,t1.* from (select a.PRIM_VNDR_ID &quot;PrimVendorID&quot;,a.LAST_PUR_VNDR_ID &quot;LastVendorID&quot;,a.PT_NUM &quot;PartNum&quot;,a.FLD_LN_ABBR_CD &quot;LineAbbrev&quot;,a.PT_DESC &quot;PartDesc&quot;, a.NON_STK_PT_SAL_RPT_SUMM_ID &quot;STKPTSALRPTSUMMID&quot;,a.NON_STK_PT_SAL_RPT_DET_ID &quot;STKPTSALRPTDETID&quot;,a.RLNG_12_MO_SAL_QTY &quot;Rling12MSalQty&quot;,a.RLNG_12_MO_SAL_FREQ_VAL &quot;Rling12MSalFreq&quot;,a.CR_DT &quot;CreateDate&quot;,a.CR_BY_NM &quot;CreateBy&quot;,a.UPD_DT &quot;UpdateDate&quot;,a.UPD_BY_NM &quot;UpdateBy&quot;,c.EXT_REF_VNDR_ID &quot;PrimVndrExfRef&quot;,c.VNDR_NM &quot;PrimVndrName&quot; from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.NON_STK_PT_SAL_RPT_DET a,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.NON_STK_PT_SAL_RPT_SUMM b,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR c',&quot; where &#xA;b.IBS_LOC_ID=&quot;,&#xA;$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; and &quot;,'a.NON_STK_PT_SAL_RPT_SUMM_ID in ( select NON_STK_PT_SAL_RPT_SUMM_ID from (select NON_STK_PT_SAL_RPT_SUMM_ID,row_number() over (order by CR_DT desc) from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_RPT_SUMM where ACT_FLAG='Y' and IBS_LOC_ID = &quot;, $Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot;order by CR_DT desc) where rownum='1') and a.PRIM_VNDR_ID=c.IBS_VNDR_ID(+) and a.NON_STK_PT_SAL_RPT_SUMM_ID=b.NON_STK_PT_SAL_RPT_SUMM_ID and (a.pt_num, a.fld_ln_abbr_cd) not in (select d.pt_num,d.fld_ln_abbr_cd from &quot;,$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_EXCL d where d.ibs_loc_id = &quot;,$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; and d.expir_dt > sysdate) and &quot;,$Filters/root/FilterBy,' order by ',$Filters/root/SortBy,') t1)&#xA;WHERE rnum BETWEEN ',$StartRow,' AND ',$EndRow)"/>
                         </statement>
                     </xsl:when>
                     <xsl:otherwise>
                         <statement>
-                            <xsl:value-of select="concat('select * from(select ROWNUM rnum,t1.* from (select a.PRIM_VNDR_ID &quot;PrimVendorID&quot;,a.LAST_PUR_VNDR_ID &quot;LastVendorID&quot;,a.PT_NUM &quot;PartNum&quot;,a.FLD_LN_ABBR_CD &quot;LineAbbrev&quot;,a.PT_DESC &quot;PartDesc&quot;,a.NON_STK_PT_SAL_RPT_SUMM_ID &quot;STKPTSALRPTSUMMID&quot;,a.NON_STK_PT_SAL_RPT_DET_ID &quot;STKPTSALRPTDETID&quot;,a.RLNG_12_MO_SAL_QTY &quot;Rling12MSalQty&quot;,a.RLNG_12_MO_SAL_FREQ_VAL &quot;Rling12MSalFreq&quot;,a.CR_DT &quot;CreateDate&quot;,a.CR_BY_NM &quot;CreateBy&quot;,a.UPD_DT &quot;UpdateDate&quot;,a.UPD_BY_NM &quot;UpdateBy&quot;,c.EXT_REF_VNDR_ID &quot;PrimVndrExfRef&quot;,c.VNDR_NM &quot;PrimVndrName&quot; from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.NON_STK_PT_SAL_RPT_DET a,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.NON_STK_PT_SAL_RPT_SUMM b,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR c',&quot; where &#xA;b.IBS_LOC_ID=&quot;,&#xA;$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; and &quot;,'a.NON_STK_PT_SAL_RPT_SUMM_ID in ( select NON_STK_PT_SAL_RPT_SUMM_ID from (select NON_STK_PT_SAL_RPT_SUMM_ID,row_number() over (order by CR_DT desc) from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_RPT_SUMM where ACT_FLAG='Y' and IBS_LOC_ID = &quot;,$Start/root/pfx:ListNonPartStockReq/pfx:LocationID ,&quot;order by CR_DT desc) where rownum='1') and a.PRIM_VNDR_ID=c.IBS_VNDR_ID(+) and a.NON_STK_PT_SAL_RPT_SUMM_ID=b.NON_STK_PT_SAL_RPT_SUMM_ID&quot;,' order by ',$Filters/root/SortBy,') t1)&#xA;WHERE rnum BETWEEN ',$StartRow,' AND ',$EndRow)"/>
+                            <xsl:value-of select="concat('select * from(select ROWNUM rnum,t1.* from (select a.PRIM_VNDR_ID &quot;PrimVendorID&quot;,a.LAST_PUR_VNDR_ID &quot;LastVendorID&quot;,a.PT_NUM &quot;PartNum&quot;,a.FLD_LN_ABBR_CD &quot;LineAbbrev&quot;,a.PT_DESC &quot;PartDesc&quot;,a.NON_STK_PT_SAL_RPT_SUMM_ID &quot;STKPTSALRPTSUMMID&quot;,a.NON_STK_PT_SAL_RPT_DET_ID &quot;STKPTSALRPTDETID&quot;,a.RLNG_12_MO_SAL_QTY &quot;Rling12MSalQty&quot;,a.RLNG_12_MO_SAL_FREQ_VAL &quot;Rling12MSalFreq&quot;,a.CR_DT &quot;CreateDate&quot;,a.CR_BY_NM &quot;CreateBy&quot;,a.UPD_DT &quot;UpdateDate&quot;,a.UPD_BY_NM &quot;UpdateBy&quot;,c.EXT_REF_VNDR_ID &quot;PrimVndrExfRef&quot;,c.VNDR_NM &quot;PrimVndrName&quot; from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.NON_STK_PT_SAL_RPT_DET a,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.NON_STK_PT_SAL_RPT_SUMM b,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR c',&quot; where &#xA;b.IBS_LOC_ID=&quot;,&#xA;$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; and &quot;,'a.NON_STK_PT_SAL_RPT_SUMM_ID in ( select NON_STK_PT_SAL_RPT_SUMM_ID from (select NON_STK_PT_SAL_RPT_SUMM_ID,row_number() over (order by CR_DT desc) from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_RPT_SUMM where ACT_FLAG='Y' and IBS_LOC_ID = &quot;,$Start/root/pfx:ListNonPartStockReq/pfx:LocationID ,&quot;order by CR_DT desc) where rownum='1') and a.PRIM_VNDR_ID=c.IBS_VNDR_ID(+) and (a.pt_num, a.fld_ln_abbr_cd) not in (select d.pt_num,d.fld_ln_abbr_cd from &quot;,$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_EXCL d where d.ibs_loc_id = &quot;,$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; and d.expir_dt > sysdate) and a.NON_STK_PT_SAL_RPT_SUMM_ID=b.NON_STK_PT_SAL_RPT_SUMM_ID&quot;,' order by ',$Filters/root/SortBy,') t1) WHERE rnum BETWEEN ',$StartRow,' AND ',$EndRow)"/>
                         </statement>
                     </xsl:otherwise>
                 </xsl:choose>
@@ -275,12 +275,12 @@
                 <xsl:choose>
                     <xsl:when test="count($Start/root/pfx:ListNonPartStockReq/pfx:FilterBy/pfx:filterfields)>0">
                         <statement>
-                            <xsl:value-of select="concat('select count(*) from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.non_stk_pt_sal_rpt_det a,&#xA;',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.non_stk_pt_sal_rpt_summ b,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR c',&#xA;' where b.IBS_LOC_ID=',$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,' and ',&#xA;&quot;a.NON_STK_PT_SAL_RPT_SUMM_ID in ( select NON_STK_PT_SAL_RPT_SUMM_ID from ( select NON_STK_PT_SAL_RPT_SUMM_ID,row_number() over (order by CR_DT desc) from ibsods.NON_STK_PT_SAL_RPT_SUMM where ACT_FLAG='Y' and IBS_LOC_ID =&quot;,$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; order by CR_DT desc) where rownum='1') &#xA;and a.NON_STK_PT_SAL_RPT_SUMM_ID=b.NON_STK_PT_SAL_RPT_SUMM_ID and a.PRIM_VNDR_ID=c.IBS_VNDR_ID(+) and &quot;,$Filters/root/FilterBy)"/>
+                            <xsl:value-of select="concat('select count(*) from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.non_stk_pt_sal_rpt_det a,&#xA;',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.non_stk_pt_sal_rpt_summ b,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR c',&#xA;' where b.IBS_LOC_ID=',$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,' and ',&#xA;&quot;a.NON_STK_PT_SAL_RPT_SUMM_ID in ( select NON_STK_PT_SAL_RPT_SUMM_ID from ( select NON_STK_PT_SAL_RPT_SUMM_ID,row_number() over (order by CR_DT desc) from &quot;,$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_RPT_SUMM where ACT_FLAG='Y' and IBS_LOC_ID =&quot;,$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; order by CR_DT desc) where rownum='1') &#xA;and a.NON_STK_PT_SAL_RPT_SUMM_ID=b.NON_STK_PT_SAL_RPT_SUMM_ID and a.PRIM_VNDR_ID=c.IBS_VNDR_ID(+) and (a.pt_num, a.fld_ln_abbr_cd) not in (select d.pt_num,d.fld_ln_abbr_cd from &quot;,$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_EXCL d where d.ibs_loc_id = &quot;,$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; and d.expir_dt > sysdate) and &quot;,$Filters/root/FilterBy)"/>
                         </statement>
                     </xsl:when>
                     <xsl:otherwise>
                         <statement>
-                            <xsl:value-of select="concat('select count(*) from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.non_stk_pt_sal_rpt_det a,',&#xA;$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.non_stk_pt_sal_rpt_summ b,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR c',' &#xA;where b.IBS_LOC_ID=',$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,' and ',&quot;a.NON_STK_PT_SAL_RPT_SUMM_ID in ( select NON_STK_PT_SAL_RPT_SUMM_ID from ( select NON_STK_PT_SAL_RPT_SUMM_ID,row_number() over (order by CR_DT desc) from ibsods.NON_STK_PT_SAL_RPT_SUMM where ACT_FLAG='Y' and IBS_LOC_ID =&quot;, $Start/root/pfx:ListNonPartStockReq/pfx:LocationID ,&#xA;&quot; order by CR_DT desc) where rownum='1') and a.NON_STK_PT_SAL_RPT_SUMM_ID=b.NON_STK_PT_SAL_RPT_SUMM_ID and a.PRIM_VNDR_ID=c.IBS_VNDR_ID(+)&quot;)"/>
+                            <xsl:value-of select="concat('select count(*) from ',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.non_stk_pt_sal_rpt_det a,',&#xA;$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.non_stk_pt_sal_rpt_summ b,',$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR c',' &#xA;where b.IBS_LOC_ID=',$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,' and ',&quot;a.NON_STK_PT_SAL_RPT_SUMM_ID in ( select NON_STK_PT_SAL_RPT_SUMM_ID from ( select NON_STK_PT_SAL_RPT_SUMM_ID,row_number() over (order by CR_DT desc) from &quot;,$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_RPT_SUMM where ACT_FLAG='Y' and IBS_LOC_ID =&quot;, $Start/root/pfx:ListNonPartStockReq/pfx:LocationID ,&#xA;&quot; order by CR_DT desc) where rownum='1') and a.NON_STK_PT_SAL_RPT_SUMM_ID=b.NON_STK_PT_SAL_RPT_SUMM_ID and (a.pt_num, a.fld_ln_abbr_cd) not in (select d.pt_num,d.fld_ln_abbr_cd from &quot;,$_globalVariables/ns1:GlobalVariables/Connections/DB/IBS/Schema,&quot;.NON_STK_PT_SAL_EXCL d where d.ibs_loc_id = &quot;,$Start/root/pfx:ListNonPartStockReq/pfx:LocationID,&quot; and d.expir_dt > sysdate) and a.PRIM_VNDR_ID=c.IBS_VNDR_ID(+)&quot;)"/>
                         </statement>
                     </xsl:otherwise>
                 </xsl:choose>