Index: branches/IBSRegularRelease/TIBCOApp/IBSPartMgmt/BW/IBSPartMgmt/Processes/ActionProcess/Part/GetInventoryData.process
===================================================================
diff -u -r229531 -r242077
--- branches/IBSRegularRelease/TIBCOApp/IBSPartMgmt/BW/IBSPartMgmt/Processes/ActionProcess/Part/GetInventoryData.process	(.../GetInventoryData.process)	(revision 229531)
+++ branches/IBSRegularRelease/TIBCOApp/IBSPartMgmt/BW/IBSPartMgmt/Processes/ActionProcess/Part/GetInventoryData.process	(.../GetInventoryData.process)	(revision 242077)
@@ -198,13 +198,9 @@
                                                         <ns3:VendorOrderItemID>
                                                             <xsl:value-of select="round(current()/VendorOrderItemID)"/>
                                                         </ns3:VendorOrderItemID>
-                                                        <xsl:if test="string-length(current()/OrderQty)>0">
-                                                            <xsl:if test="current()/OrderQty">
-                                                                <ns3:OrderQty>
-                                                                    <xsl:value-of select="current()/OrderQty"/>
-                                                                </ns3:OrderQty>
-                                                            </xsl:if>
-                                                        </xsl:if>
+                                                        <ns3:OrderQty>
+                                                            <xsl:value-of select="if (string-length(current()/BO_QTY)>0)&#xA;then current()/BO_QTY&#xA;else if  (string-length(current()/OrderQty)>0)&#xA;then current()/OrderQty&#xA;else 0"/>
+                                                        </ns3:OrderQty>
                                                         <xsl:if test="string-length(VEND_ORD_ITM_ETA_DT) > 0">
                                                             <xsl:if test="VEND_ORD_ITM_ETA_DT">
                                                                 <ns3:ETADate>
@@ -372,19 +368,19 @@
                 <xsl:choose>
                     <xsl:when test="upper-case($Start/root/pfx:GetInventoryPosReq/pfx:Type)='NAPA'">
                         <statement>
-                            <xsl:value-of select="concat('select a.EXT_REF_PO_NUM &quot;PONUM&quot;,e.CURR_ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_PT_REQ_ID &quot;PTREQID&quot;,a.IBS_PO_ID &quot;IBSPOID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PO a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.JOB c,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PO_LN e',' &#xA;where a.EXT_REF_PO_NUM in ',&quot;('&quot;,$var,&quot;')&quot;,&quot; and b.PT_NUM='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:PartNum,&quot;' and b.FLD_LN_ABBR_CD='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LineAbbrev,&quot;' and d.IBS_LOC_ID='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LocationID,&quot;'  and a.IBS_PO_ID=b.PO_TRK_ID and b.IBS_JOB_ID=c.IBS_JOB_ID and d.IBS_WKORD_ID=c.IBS_WKORD_ID and b.PO_LN_ID=e.PO_LN_ID and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACKORDER')&#xA;group by a.EXT_REF_PO_NUM,e.CURR_ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,b.IBS_PT_REQ_ID,a.IBS_PO_ID&quot;)"/>
+                            <xsl:value-of select="concat('select a.EXT_REF_PO_NUM &quot;PONUM&quot;,e.CURR_ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_PT_REQ_ID &quot;PTREQID&quot;,a.IBS_PO_ID &quot;IBSPOID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PO a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.JOB c,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PO_LN e',' &#xA;where a.EXT_REF_PO_NUM in ',&quot;('&quot;,$var,&quot;')&quot;,&quot; and b.PT_NUM='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:PartNum,&quot;' and b.FLD_LN_ABBR_CD='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LineAbbrev,&quot;' and d.IBS_LOC_ID='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LocationID,&quot;'  and a.IBS_PO_ID=b.PO_TRK_ID and b.IBS_JOB_ID=c.IBS_JOB_ID and d.IBS_WKORD_ID=c.IBS_WKORD_ID and b.PO_LN_ID=e.PO_LN_ID and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACK ORDER')&#xA;group by a.EXT_REF_PO_NUM,e.CURR_ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,b.IBS_PT_REQ_ID,a.IBS_PO_ID&quot;)"/>
                         </statement>
                     </xsl:when>
                     <xsl:otherwise>
                         <xsl:choose>
                             <xsl:when test="string-length($Start/root/pfx:GetInventoryPosReq/pfx:VendorOrderItemId)>0">
                                 <statement>
-                                    <xsl:value-of select="concat('select a.ORD_REF_ID &quot;PONUM&quot;,e.ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_PT_REQ_ID &quot;PTREQID&quot;,a.VNDR_ORD_ID &quot;VendorOrderID&quot;,e.VNDR_ORD_ITM_ID &quot;VendorOrderItemID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.JOB c,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD_ITM e',' &#xA;where e.VNDR_ORD_ITM_ID in ',&quot;('&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:VendorOrderItemId,&quot;')&quot;,&quot; and a.VNDR_ORD_ID=e.VNDR_ORD_ID(+) and e.VNDR_ORD_ITM_ID=b.VNDR_ORD_ITM_ID(+) and b.IBS_JOB_ID=c.IBS_JOB_ID and d.IBS_WKORD_ID=c.IBS_WKORD_ID and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACKORDER')&#xA;group by a.ORD_REF_ID,e.ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,b.IBS_PT_REQ_ID,a.VNDR_ORD_ID,e.VNDR_ORD_ITM_ID &#xA;UNION ALL &quot;,&#xA;'select a.ORD_REF_ID &quot;PONUM&quot;,e.ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_NEW_PT_REQ_ID &quot;PTREQID&quot;,a.VNDR_ORD_ID &quot;VendorOrderID&quot;,e.VNDR_ORD_ITM_ID &quot;VendorOrderItemID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.NEW_PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD_ITM e',' &#xA;where e.VNDR_ORD_ITM_ID in ',&quot;('&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:VendorOrderItemId,&quot;')&quot;,&quot; and a.VNDR_ORD_ID=e.VNDR_ORD_ID(+) and e.VNDR_ORD_ITM_ID=b.VNDR_ORD_ITM_ID(+) and d.IBS_WKORD_ID=b.IBS_WKORD_ID and d.IBS_LOC_ID='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LocationID,&quot;'  and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACKORDER')&#xA;group by a.ORD_REF_ID,e.ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,a.VNDR_ORD_ID,b.IBS_NEW_PT_REQ_ID,e.VNDR_ORD_ITM_ID&quot;)"/>
+                                    <xsl:value-of select="concat('select a.ORD_REF_ID &quot;PONUM&quot;,e.ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_PT_REQ_ID &quot;PTREQID&quot;,a.VNDR_ORD_ID &quot;VendorOrderID&quot;,e.VNDR_ORD_ITM_ID &quot;VendorOrderItemID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.JOB c,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD_ITM e',' &#xA;where e.VNDR_ORD_ITM_ID in ',&quot;('&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:VendorOrderItemId,&quot;')&quot;,&quot; and a.VNDR_ORD_ID=e.VNDR_ORD_ID(+) and e.VNDR_ORD_ITM_ID=b.VNDR_ORD_ITM_ID(+) and b.IBS_JOB_ID=c.IBS_JOB_ID and d.IBS_WKORD_ID=c.IBS_WKORD_ID and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACK ORDER')&#xA;group by a.ORD_REF_ID,e.ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,b.IBS_PT_REQ_ID,a.VNDR_ORD_ID,e.VNDR_ORD_ITM_ID &#xA;UNION ALL &quot;,&#xA;'select a.ORD_REF_ID &quot;PONUM&quot;,e.ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_NEW_PT_REQ_ID &quot;PTREQID&quot;,a.VNDR_ORD_ID &quot;VendorOrderID&quot;,e.VNDR_ORD_ITM_ID &quot;VendorOrderItemID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.NEW_PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD_ITM e',' &#xA;where e.VNDR_ORD_ITM_ID in ',&quot;('&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:VendorOrderItemId,&quot;')&quot;,&quot; and a.VNDR_ORD_ID=e.VNDR_ORD_ID(+) and e.VNDR_ORD_ITM_ID=b.VNDR_ORD_ITM_ID(+) and d.IBS_WKORD_ID=b.IBS_WKORD_ID and d.IBS_LOC_ID='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LocationID,&quot;'  and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACK ORDER')&#xA;group by a.ORD_REF_ID,e.ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,a.VNDR_ORD_ID,b.IBS_NEW_PT_REQ_ID,e.VNDR_ORD_ITM_ID&quot;)"/>
                                 </statement>
                             </xsl:when>
                             <xsl:otherwise>
                                 <statement>
-                                    <xsl:value-of select="concat('select a.ORD_REF_ID &quot;PONUM&quot;,e.ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_PT_REQ_ID &quot;PTREQID&quot;,a.VNDR_ORD_ID &quot;VendorOrderID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.JOB c,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD_ITM e',' &#xA;where e.VNDR_ORD_ITM_ID in ',&quot;('&quot;,$var,&quot;')&quot;,&quot; and a.VNDR_ORD_ID=e.VNDR_ORD_ID(+) and e.VNDR_ORD_ITM_ID=b.VNDR_ORD_ITM_ID(+) and b.IBS_JOB_ID=c.IBS_JOB_ID and d.IBS_WKORD_ID=c.IBS_WKORD_ID and d.IBS_LOC_ID='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LocationID,&quot;'  and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACKORDER')&#xA;group by a.ORD_REF_ID,e.ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,b.IBS_PT_REQ_ID,a.VNDR_ORD_ID &#xA;UNION ALL &quot;,&#xA;'select a.ORD_REF_ID &quot;PONUM&quot;,e.ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_NEW_PT_REQ_ID &quot;PTREQID&quot;,a.VNDR_ORD_ID &quot;VendorOrderID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.NEW_PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD_ITM e',' &#xA;where e.VNDR_ORD_ITM_ID in ',&quot;('&quot;,$var,&quot;')&quot;,&quot; and a.VNDR_ORD_ID=e.VNDR_ORD_ID(+) and e.VNDR_ORD_ITM_ID=b.VNDR_ORD_ITM_ID(+) and d.IBS_WKORD_ID=b.IBS_WKORD_ID and d.IBS_LOC_ID='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LocationID,&quot;'  and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACKORDER')&#xA;group by a.ORD_REF_ID,e.ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,a.VNDR_ORD_ID,b.IBS_NEW_PT_REQ_ID&quot;)"/>
+                                    <xsl:value-of select="concat('select a.ORD_REF_ID &quot;PONUM&quot;,e.ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_PT_REQ_ID &quot;PTREQID&quot;,a.VNDR_ORD_ID &quot;VendorOrderID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.JOB c,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD_ITM e',' &#xA;where e.VNDR_ORD_ITM_ID in ',&quot;('&quot;,$var,&quot;')&quot;,&quot; and a.VNDR_ORD_ID=e.VNDR_ORD_ID(+) and e.VNDR_ORD_ITM_ID=b.VNDR_ORD_ITM_ID(+) and b.IBS_JOB_ID=c.IBS_JOB_ID and d.IBS_WKORD_ID=c.IBS_WKORD_ID and d.IBS_LOC_ID='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LocationID,&quot;'  and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACK ORDER')&#xA;group by a.ORD_REF_ID,e.ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,b.IBS_PT_REQ_ID,a.VNDR_ORD_ID &#xA;UNION ALL &quot;,&#xA;'select a.ORD_REF_ID &quot;PONUM&quot;,e.ETA_DT &quot;ETADATE&quot;,b.REQ_QTY &quot;QTY&quot;,d.WKORD_REF_NUM &quot;WORKORDERID&quot;,d.IBS_WKORD_ID &quot;IBSWORKID&quot;,d.CR_DT &quot;RECEIVEDATE&quot;,b.IBS_NEW_PT_REQ_ID &quot;PTREQID&quot;,a.VNDR_ORD_ID &quot;VendorOrderID&quot; from ',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD a,',&#xA;$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.NEW_PT_REQ b,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.WKORD d,',$_globalVariables/ns2:GlobalVariables/Connections/DB/IBS/Schema,'.VNDR_ORD_ITM e',' &#xA;where e.VNDR_ORD_ITM_ID in ',&quot;('&quot;,$var,&quot;')&quot;,&quot; and a.VNDR_ORD_ID=e.VNDR_ORD_ID(+) and e.VNDR_ORD_ITM_ID=b.VNDR_ORD_ITM_ID(+) and d.IBS_WKORD_ID=b.IBS_WKORD_ID and d.IBS_LOC_ID='&quot;,$Start/root/pfx:GetInventoryPosReq/pfx:LocationID,&quot;'  and UPPER(b.PT_STAT_CD) in ('PART ON ORDER','PART ON BACK ORDER')&#xA;group by a.ORD_REF_ID,e.ETA_DT,d.WKORD_REF_NUM,d.IBS_WKORD_ID,b.REQ_QTY,d.CR_DT,a.VNDR_ORD_ID,b.IBS_NEW_PT_REQ_ID&quot;)"/>
                                 </statement>
                             </xsl:otherwise>
                         </xsl:choose>
@@ -404,7 +400,7 @@
             <maxRows>%%Tuning/Database/MaxRowsUnlimited%%</maxRows>
             <emptyStrAsNil>false</emptyStrAsNil>
             <jdbcSharedConfig>/SharedResources/Connections/Database/IBSDB.sharedjdbc</jdbcSharedConfig>
-            <statement>select b.ETA_DT "VEND_ORD_ITM_ETA_DT" , a.VNDR_ORD_ID "VendorOrderID",a.ORD_REF_ID "PONum",a.ORD_DT "OrderDate",a.ETA_DT "ETA",b.VNDR_ORD_ITM_ID "VendorOrderItemID",b.ORD_QTY "OrderQty"  
+            <statement>select b.ETA_DT "VEND_ORD_ITM_ETA_DT" , a.VNDR_ORD_ID "VendorOrderID",a.ORD_REF_ID "PONum",a.ORD_DT "OrderDate",a.ETA_DT "ETA",b.VNDR_ORD_ITM_ID "VendorOrderItemID",b.ORD_QTY "OrderQty"  ,b.BO_QTY
 from %%Connections/DB/IBS/Schema%%.VNDR_ORD a,
 %%Connections/DB/IBS/Schema%%.VNDR_ORD_ITM b,%%Connections/DB/IBS/Schema%%.VNDR C 
 where b.PT_NUM like ? and b.FLD_LN_ABBR_CD like ? and upper(b.PT_STAT_CD) in ('ORDERED','PARTIALLY RECEIVED') and a.VNDR_ORD_ID=b.VNDR_ORD_ID and C.IBS_VNDR_ID = A.IBS_VNDR_ID
@@ -453,6 +449,10 @@
             <QueryOutputCachedSchemaDataTypes>2</QueryOutputCachedSchemaDataTypes>
             <QueryOutputCachedSchemaDataTypesName>NUMBER</QueryOutputCachedSchemaDataTypesName>
             <QueryOutputCachedSchemaStatus>OptionalElement</QueryOutputCachedSchemaStatus>
+            <QueryOutputCachedSchemaColumns>BO_QTY</QueryOutputCachedSchemaColumns>
+            <QueryOutputCachedSchemaDataTypes>2</QueryOutputCachedSchemaDataTypes>
+            <QueryOutputCachedSchemaDataTypesName>NUMBER</QueryOutputCachedSchemaDataTypesName>
+            <QueryOutputCachedSchemaStatus>OptionalElement</QueryOutputCachedSchemaStatus>
         </config>
         <pd:inputBindings>
             <jdbcQueryActivityInput>