Index: branches/IBSRegularRelease/TIBCOApp/IBSInventorySyncService/BW/IBSInventorySyncService/Processes/SubProcess/PartLoading.process
===================================================================
diff -u -r251890 -r252073
--- branches/IBSRegularRelease/TIBCOApp/IBSInventorySyncService/BW/IBSInventorySyncService/Processes/SubProcess/PartLoading.process	(.../PartLoading.process)	(revision 251890)
+++ branches/IBSRegularRelease/TIBCOApp/IBSInventorySyncService/BW/IBSInventorySyncService/Processes/SubProcess/PartLoading.process	(.../PartLoading.process)	(revision 252073)
@@ -472,7 +472,7 @@
                 <commit>false</commit>
                 <emptyStrAsNil>false</emptyStrAsNil>
                 <jdbcSharedConfig>/SharedResources/Connections/Database/IBSDB.sharedjdbc</jdbcSharedConfig>
-                <statement>update  %%Connections/DB/IBS/Schema%%.REALTM_STO_INV set FLD_LN_ABBR_CD = ? ,PT_NUM = ?,IS_ACT_FLAG= ?,PT_DESC = ?,CORE_CST_AMT = ?,LIST_PRC_AMT = ?,SPLR_CD = ?,PROD_GP_CD = ?,STO_GP_ID = ?,STD_PKG = ?,FCTY_STD_PKG = ?,UPD_DT=sysdate, UPD_BY_NM = ?,CST_AMT = ?,UN_DES = ? where  MACS_ID = ? and PT_NUM = ? and FLD_LN_ABBR_CD = ?</statement>
+                <statement>update  %%Connections/DB/IBS/Schema%%.REALTM_STO_INV set FLD_LN_ABBR_CD = ? ,PT_NUM = ?,IS_ACT_FLAG= ?,PT_DESC = ?,CORE_CST_AMT = ?,LIST_PRC_AMT = ?,SPLR_CD = ?,PROD_GP_CD = ?,STO_GP_ID = ?,STD_PKG = ?,FCTY_STD_PKG = ?,UPD_DT=sysdate, UPD_BY_NM = ?,CST_AMT = ?,UN_DES = ?, SPLR_NM=? where  MACS_ID = ? and PT_NUM = ? and FLD_LN_ABBR_CD = ?</statement>
                 <batchUpdate>false</batchUpdate>
                 <Prepared_Param_DataType>
                     <parameter>
@@ -532,6 +532,10 @@
                         <dataType>VARCHAR</dataType>
                     </parameter>
                     <parameter>
+                        <parameterName>SupplierName</parameterName>
+                        <dataType>VARCHAR</dataType>
+                    </parameter>
+                    <parameter>
                         <parameterName>MacsID</parameterName>
                         <dataType>VARCHAR</dataType>
                     </parameter>
@@ -718,6 +722,18 @@
                             </xsl:otherwise>
                         </xsl:choose>
                     </UOM>
+                    <xsl:choose>
+                        <xsl:when test="string-length($current/pfx5:Product/pfx5:SupplierCode)>0">
+                            <SupplierName>
+                                <xsl:value-of select="if($current/pfx5:Product/pfx5:SupplierCode >1)&#xA;then&#xA;'NON-NAPA'&#xA;else&#xA;'NAPA'"/>
+                            </SupplierName>
+                        </xsl:when>
+                        <xsl:otherwise>
+                            <SupplierName>
+                                <xsl:value-of select="$CheckExisting/resultSet/Record[1]/SPLR_NM"/>
+                            </SupplierName>
+                        </xsl:otherwise>
+                    </xsl:choose>
                     <MacsID>
                         <xsl:value-of select="$Start/pfx5:Request/pfx5:StoreInfo/pfx5:MACSID"/>
                     </MacsID>
@@ -741,7 +757,7 @@
                 <maxRows>%%Tuning/Database/MaxRowsUnlimited%%</maxRows>
                 <emptyStrAsNil>false</emptyStrAsNil>
                 <jdbcSharedConfig>/SharedResources/Connections/Database/IBSDB.sharedjdbc</jdbcSharedConfig>
-                <statement>select IBS_LOC_ID,MACS_ID,FLD_LN_ABBR_CD,PT_NUM,IS_ACT_FLAG,PT_DESC,CORE_CST_AMT,LIST_PRC_AMT,SPLR_CD,PROD_GP_CD,STO_GP_ID,STD_PKG,FCTY_STD_PKG from REALTM_STO_INV where IBS_LOC_ID=? and MACS_ID = ? and PT_NUM = ? and FLD_LN_ABBR_CD = ?</statement>
+                <statement>select IBS_LOC_ID,MACS_ID,FLD_LN_ABBR_CD,PT_NUM,IS_ACT_FLAG,PT_DESC,CORE_CST_AMT,LIST_PRC_AMT,SPLR_CD,SPLR_NM,PROD_GP_CD,STO_GP_ID,STD_PKG,FCTY_STD_PKG from REALTM_STO_INV where IBS_LOC_ID=? and MACS_ID = ? and PT_NUM = ? and FLD_LN_ABBR_CD = ?</statement>
                 <Prepared_Param_DataType>
                     <parameter>
                         <parameterName>LocationID</parameterName>
@@ -798,6 +814,10 @@
                 <QueryOutputCachedSchemaDataTypes>2</QueryOutputCachedSchemaDataTypes>
                 <QueryOutputCachedSchemaDataTypesName>NUMBER</QueryOutputCachedSchemaDataTypesName>
                 <QueryOutputCachedSchemaStatus>OptionalElement</QueryOutputCachedSchemaStatus>
+                <QueryOutputCachedSchemaColumns>SPLR_NM</QueryOutputCachedSchemaColumns>
+                <QueryOutputCachedSchemaDataTypes>12</QueryOutputCachedSchemaDataTypes>
+                <QueryOutputCachedSchemaDataTypesName>VARCHAR2</QueryOutputCachedSchemaDataTypesName>
+                <QueryOutputCachedSchemaStatus>OptionalElement</QueryOutputCachedSchemaStatus>
                 <QueryOutputCachedSchemaColumns>PROD_GP_CD</QueryOutputCachedSchemaColumns>
                 <QueryOutputCachedSchemaDataTypes>12</QueryOutputCachedSchemaDataTypes>
                 <QueryOutputCachedSchemaDataTypesName>VARCHAR2</QueryOutputCachedSchemaDataTypesName>