INSERT INTO [dbo].[AOIQ_Temp] ([Stage], [Qty]) VALUES (@Stage, @Qty) SELECT Stage, Qty FROM dbo.AOIQ_Temp DELETE FROM [dbo].[batch] WHERE (([batchId] = @Original_batchId) AND ((@IsNull_batchNo = 1 AND [batchNo] IS NULL) OR ([batchNo] = @Original_batchNo)) AND ((@IsNull_partNo = 1 AND [partNo] IS NULL) OR ([partNo] = @Original_partNo)) AND ((@IsNull_line = 1 AND [line] IS NULL) OR ([line] = @Original_line)) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_prefix = 1 AND [prefix] IS NULL) OR ([prefix] = @Original_prefix)) AND ((@IsNull_suffix = 1 AND [suffix] IS NULL) OR ([suffix] = @Original_suffix)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate))) INSERT INTO [dbo].[batch] ([batchNo], [partNo], [line], [quantity], [prefix], [suffix], [lastupdatedby], [lastupdate]) VALUES (@batchNo, @partNo, @line, @quantity, @prefix, @suffix, @lastupdatedby, @lastupdate); SELECT batchId, batchNo, partNo, line, quantity, prefix, suffix, lastupdatedby, lastupdate FROM batch WHERE (batchId = SCOPE_IDENTITY()) SELECT batchId, batchNo, partNo, line, quantity, prefix, suffix, lastupdatedby, lastupdate FROM dbo.batch UPDATE [dbo].[batch] SET [batchNo] = @batchNo, [partNo] = @partNo, [line] = @line, [quantity] = @quantity, [prefix] = @prefix, [suffix] = @suffix, [lastupdatedby] = @lastupdatedby, [lastupdate] = @lastupdate WHERE (([batchId] = @Original_batchId) AND ((@IsNull_batchNo = 1 AND [batchNo] IS NULL) OR ([batchNo] = @Original_batchNo)) AND ((@IsNull_partNo = 1 AND [partNo] IS NULL) OR ([partNo] = @Original_partNo)) AND ((@IsNull_line = 1 AND [line] IS NULL) OR ([line] = @Original_line)) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_prefix = 1 AND [prefix] IS NULL) OR ([prefix] = @Original_prefix)) AND ((@IsNull_suffix = 1 AND [suffix] IS NULL) OR ([suffix] = @Original_suffix)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate))); SELECT batchId, batchNo, partNo, line, quantity, prefix, suffix, lastupdatedby, lastupdate FROM batch WHERE (batchId = @batchId) DELETE FROM [dbo].[card] WHERE (([cardno] = @Original_cardno) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_ptno = 1 AND [ptno] IS NULL) OR ([ptno] = @Original_ptno)) AND ((@IsNull_lotno = 1 AND [lotno] IS NULL) OR ([lotno] = @Original_lotno)) AND ((@IsNull_partno = 1 AND [partno] IS NULL) OR ([partno] = @Original_partno)) AND ((@IsNull_revision = 1 AND [revision] IS NULL) OR ([revision] = @Original_revision)) AND ((@IsNull_linecode = 1 AND [linecode] IS NULL) OR ([linecode] = @Original_linecode)) AND ((@IsNull_holdflag = 1 AND [holdflag] IS NULL) OR ([holdflag] = @Original_holdflag)) AND ((@IsNull_packflag = 1 AND [packflag] IS NULL) OR ([packflag] = @Original_packflag)) AND ((@IsNull_shipflag = 1 AND [shipflag] IS NULL) OR ([shipflag] = @Original_shipflag)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lottype = 1 AND [lottype] IS NULL) OR ([lottype] = @Original_lottype)) AND ((@IsNull_curtstage = 1 AND [curtstage] IS NULL) OR ([curtstage] = @Original_curtstage)) AND ((@IsNull_starttime = 1 AND [starttime] IS NULL) OR ([starttime] = @Original_starttime)) AND ((@IsNull_starttimeRef = 1 AND [starttimeRef] IS NULL) OR ([starttimeRef] = @Original_starttimeRef)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[card] ([cardno], [serialno], [ptno], [lotno], [partno], [revision], [linecode], [holdflag], [packflag], [shipflag], [status], [lottype], [curtstage], [starttime], [starttimeRef], [lastupdate], [lastupdatedby]) VALUES (@cardno, @serialno, @ptno, @lotno, @partno, @revision, @linecode, @holdflag, @packflag, @shipflag, @status, @lottype, @curtstage, @starttime, @starttimeRef, @lastupdate, @lastupdatedby); SELECT cardno, serialno, ptno, lotno, partno, revision, linecode, holdflag, packflag, shipflag, status, lottype, curtstage, starttime, starttimeRef, lastupdate, lastupdatedby FROM card WHERE (cardno = @cardno) SELECT cardno, serialno, ptno, lotno, partno, revision, linecode, holdflag, packflag, shipflag, status, lottype, curtstage, starttime, starttimeRef, lastupdate, lastupdatedby FROM dbo.card UPDATE [dbo].[card] SET [cardno] = @cardno, [serialno] = @serialno, [ptno] = @ptno, [lotno] = @lotno, [partno] = @partno, [revision] = @revision, [linecode] = @linecode, [holdflag] = @holdflag, [packflag] = @packflag, [shipflag] = @shipflag, [status] = @status, [lottype] = @lottype, [curtstage] = @curtstage, [starttime] = @starttime, [starttimeRef] = @starttimeRef, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([cardno] = @Original_cardno) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_ptno = 1 AND [ptno] IS NULL) OR ([ptno] = @Original_ptno)) AND ((@IsNull_lotno = 1 AND [lotno] IS NULL) OR ([lotno] = @Original_lotno)) AND ((@IsNull_partno = 1 AND [partno] IS NULL) OR ([partno] = @Original_partno)) AND ((@IsNull_revision = 1 AND [revision] IS NULL) OR ([revision] = @Original_revision)) AND ((@IsNull_linecode = 1 AND [linecode] IS NULL) OR ([linecode] = @Original_linecode)) AND ((@IsNull_holdflag = 1 AND [holdflag] IS NULL) OR ([holdflag] = @Original_holdflag)) AND ((@IsNull_packflag = 1 AND [packflag] IS NULL) OR ([packflag] = @Original_packflag)) AND ((@IsNull_shipflag = 1 AND [shipflag] IS NULL) OR ([shipflag] = @Original_shipflag)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lottype = 1 AND [lottype] IS NULL) OR ([lottype] = @Original_lottype)) AND ((@IsNull_curtstage = 1 AND [curtstage] IS NULL) OR ([curtstage] = @Original_curtstage)) AND ((@IsNull_starttime = 1 AND [starttime] IS NULL) OR ([starttime] = @Original_starttime)) AND ((@IsNull_starttimeRef = 1 AND [starttimeRef] IS NULL) OR ([starttimeRef] = @Original_starttimeRef)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT cardno, serialno, ptno, lotno, partno, revision, linecode, holdflag, packflag, shipflag, status, lottype, curtstage, starttime, starttimeRef, lastupdate, lastupdatedby FROM card WHERE (cardno = @cardno) INSERT INTO [dbo].[card_backup] ([cardno], [serialno], [ptno], [lotno], [partno], [revision], [linecode], [holdflag], [packflag], [shipflag], [status], [lottype], [curtstage], [starttime], [starttimeRef], [lastupdate], [lastupdatedby]) VALUES (@cardno, @serialno, @ptno, @lotno, @partno, @revision, @linecode, @holdflag, @packflag, @shipflag, @status, @lottype, @curtstage, @starttime, @starttimeRef, @lastupdate, @lastupdatedby) SELECT cardno, serialno, ptno, lotno, partno, revision, linecode, holdflag, packflag, shipflag, status, lottype, curtstage, starttime, starttimeRef, lastupdate, lastupdatedby FROM dbo.card_backup INSERT INTO [dbo].[card_Hist] ([cardno], [serialno], [ptno], [lotno], [partno], [revision], [linecode], [holdflag], [packflag], [shipflag], [status], [lottype], [curtstage], [starttime], [starttimeRef], [lastupdate], [lastupdatedby]) VALUES (@cardno, @serialno, @ptno, @lotno, @partno, @revision, @linecode, @holdflag, @packflag, @shipflag, @status, @lottype, @curtstage, @starttime, @starttimeRef, @lastupdate, @lastupdatedby) SELECT cardno, serialno, ptno, lotno, partno, revision, linecode, holdflag, packflag, shipflag, status, lottype, curtstage, starttime, starttimeRef, lastupdate, lastupdatedby FROM dbo.card_Hist DELETE FROM [dbo].[cardHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_cardno = 1 AND [cardno] IS NULL) OR ([cardno] = @Original_cardno)) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_partno = 1 AND [partno] IS NULL) OR ([partno] = @Original_partno)) AND ((@IsNull_revision = 1 AND [revision] IS NULL) OR ([revision] = @Original_revision)) AND ((@IsNull_linecode = 1 AND [linecode] IS NULL) OR ([linecode] = @Original_linecode)) AND ((@IsNull_holdflag = 1 AND [holdflag] IS NULL) OR ([holdflag] = @Original_holdflag)) AND ((@IsNull_packflag = 1 AND [packflag] IS NULL) OR ([packflag] = @Original_packflag)) AND ((@IsNull_shipflag = 1 AND [shipflag] IS NULL) OR ([shipflag] = @Original_shipflag)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lottype = 1 AND [lottype] IS NULL) OR ([lottype] = @Original_lottype)) AND ((@IsNull_curtstage = 1 AND [curtstage] IS NULL) OR ([curtstage] = @Original_curtstage)) AND ((@IsNull_starttime = 1 AND [starttime] IS NULL) OR ([starttime] = @Original_starttime)) AND ((@IsNull_starttimeRef = 1 AND [starttimeRef] IS NULL) OR ([starttimeRef] = @Original_starttimeRef)) AND ((@IsNull_action = 1 AND [action] IS NULL) OR ([action] = @Original_action)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[cardHist] ([cardno], [serialno], [partno], [revision], [linecode], [holdflag], [packflag], [shipflag], [status], [lottype], [curtstage], [starttime], [starttimeRef], [action], [lastupdate], [lastupdatedby]) VALUES (@cardno, @serialno, @partno, @revision, @linecode, @holdflag, @packflag, @shipflag, @status, @lottype, @curtstage, @starttime, @starttimeRef, @action, @lastupdate, @lastupdatedby); SELECT lineNum, cardno, serialno, partno, revision, linecode, holdflag, packflag, shipflag, status, lottype, curtstage, starttime, starttimeRef, action, lastupdate, lastupdatedby FROM cardHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, cardno, serialno, partno, revision, linecode, holdflag, packflag, shipflag, status, lottype, curtstage, starttime, starttimeRef, action, lastupdate, lastupdatedby FROM dbo.cardHist UPDATE [dbo].[cardHist] SET [cardno] = @cardno, [serialno] = @serialno, [partno] = @partno, [revision] = @revision, [linecode] = @linecode, [holdflag] = @holdflag, [packflag] = @packflag, [shipflag] = @shipflag, [status] = @status, [lottype] = @lottype, [curtstage] = @curtstage, [starttime] = @starttime, [starttimeRef] = @starttimeRef, [action] = @action, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_cardno = 1 AND [cardno] IS NULL) OR ([cardno] = @Original_cardno)) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_partno = 1 AND [partno] IS NULL) OR ([partno] = @Original_partno)) AND ((@IsNull_revision = 1 AND [revision] IS NULL) OR ([revision] = @Original_revision)) AND ((@IsNull_linecode = 1 AND [linecode] IS NULL) OR ([linecode] = @Original_linecode)) AND ((@IsNull_holdflag = 1 AND [holdflag] IS NULL) OR ([holdflag] = @Original_holdflag)) AND ((@IsNull_packflag = 1 AND [packflag] IS NULL) OR ([packflag] = @Original_packflag)) AND ((@IsNull_shipflag = 1 AND [shipflag] IS NULL) OR ([shipflag] = @Original_shipflag)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lottype = 1 AND [lottype] IS NULL) OR ([lottype] = @Original_lottype)) AND ((@IsNull_curtstage = 1 AND [curtstage] IS NULL) OR ([curtstage] = @Original_curtstage)) AND ((@IsNull_starttime = 1 AND [starttime] IS NULL) OR ([starttime] = @Original_starttime)) AND ((@IsNull_starttimeRef = 1 AND [starttimeRef] IS NULL) OR ([starttimeRef] = @Original_starttimeRef)) AND ((@IsNull_action = 1 AND [action] IS NULL) OR ([action] = @Original_action)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, cardno, serialno, partno, revision, linecode, holdflag, packflag, shipflag, status, lottype, curtstage, starttime, starttimeRef, action, lastupdate, lastupdatedby FROM cardHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[component_parts] ([parent], [component]) VALUES (@parent, @component) SELECT parent, component FROM dbo.component_parts INSERT INTO [dbo].[CTS] ([serialno], [location], [partno], [lotnumber], [lastupdate], [lastupdatedby]) VALUES (@serialno, @location, @partno, @lotnumber, @lastupdate, @lastupdatedby) SELECT serialno, location, partno, lotnumber, lastupdate, lastupdatedby FROM dbo.CTS DELETE FROM [dbo].[defectCatProd] WHERE (([defectCatCode] = @Original_defectCatCode) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[defectCatProd] ([defectCatCode], [description], [active], [lastupdate], [lastupdatedby]) VALUES (@defectCatCode, @description, @active, @lastupdate, @lastupdatedby); SELECT defectCatCode, description, active, lastupdate, lastupdatedby FROM defectCatProd WHERE (defectCatCode = @defectCatCode) SELECT defectCatCode, description, active, lastupdate, lastupdatedby FROM dbo.defectCatProd UPDATE [dbo].[defectCatProd] SET [defectCatCode] = @defectCatCode, [description] = @description, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([defectCatCode] = @Original_defectCatCode) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT defectCatCode, description, active, lastupdate, lastupdatedby FROM defectCatProd WHERE (defectCatCode = @defectCatCode) DELETE FROM [dbo].[defectCatProdHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_defectCatCode = 1 AND [defectCatCode] IS NULL) OR ([defectCatCode] = @Original_defectCatCode)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[defectCatProdHist] ([defectCatCode], [description], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@defectCatCode, @description, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, defectCatCode, description, active, status, lastupdate, lastupdatedby FROM defectCatProdHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, defectCatCode, description, active, status, lastupdate, lastupdatedby FROM dbo.defectCatProdHist UPDATE [dbo].[defectCatProdHist] SET [defectCatCode] = @defectCatCode, [description] = @description, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_defectCatCode = 1 AND [defectCatCode] IS NULL) OR ([defectCatCode] = @Original_defectCatCode)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, defectCatCode, description, active, status, lastupdate, lastupdatedby FROM defectCatProdHist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[defectCatQC] WHERE (([defectCatCode] = @Original_defectCatCode) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[defectCatQC] ([defectCatCode], [description], [active], [lastupdate], [lastupdatedby]) VALUES (@defectCatCode, @description, @active, @lastupdate, @lastupdatedby); SELECT defectCatCode, description, active, lastupdate, lastupdatedby FROM defectCatQC WHERE (defectCatCode = @defectCatCode) SELECT defectCatCode, description, active, lastupdate, lastupdatedby FROM dbo.defectCatQC UPDATE [dbo].[defectCatQC] SET [defectCatCode] = @defectCatCode, [description] = @description, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([defectCatCode] = @Original_defectCatCode) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT defectCatCode, description, active, lastupdate, lastupdatedby FROM defectCatQC WHERE (defectCatCode = @defectCatCode) DELETE FROM [dbo].[defectCatQCHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_defectCatCode = 1 AND [defectCatCode] IS NULL) OR ([defectCatCode] = @Original_defectCatCode)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[defectCatQCHist] ([defectCatCode], [description], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@defectCatCode, @description, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, defectCatCode, description, active, status, lastupdate, lastupdatedby FROM defectCatQCHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, defectCatCode, description, active, status, lastupdate, lastupdatedby FROM dbo.defectCatQCHist UPDATE [dbo].[defectCatQCHist] SET [defectCatCode] = @defectCatCode, [description] = @description, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_defectCatCode = 1 AND [defectCatCode] IS NULL) OR ([defectCatCode] = @Original_defectCatCode)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, defectCatCode, description, active, status, lastupdate, lastupdatedby FROM defectCatQCHist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[defectProd] WHERE (([defectCode] = @Original_defectCode) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[defectProd] ([defectCode], [description], [active], [lastupdate], [lastupdatedby]) VALUES (@defectCode, @description, @active, @lastupdate, @lastupdatedby); SELECT defectCode, description, active, lastupdate, lastupdatedby FROM defectProd WHERE (defectCode = @defectCode) SELECT defectCode, description, active, lastupdate, lastupdatedby FROM dbo.defectProd UPDATE [dbo].[defectProd] SET [defectCode] = @defectCode, [description] = @description, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([defectCode] = @Original_defectCode) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT defectCode, description, active, lastupdate, lastupdatedby FROM defectProd WHERE (defectCode = @defectCode) DELETE FROM [dbo].[defectProdHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_defectCode = 1 AND [defectCode] IS NULL) OR ([defectCode] = @Original_defectCode)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[defectProdHist] ([defectCode], [description], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@defectCode, @description, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, defectCode, description, active, status, lastupdate, lastupdatedby FROM defectProdHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, defectCode, description, active, status, lastupdate, lastupdatedby FROM dbo.defectProdHist UPDATE [dbo].[defectProdHist] SET [defectCode] = @defectCode, [description] = @description, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_defectCode = 1 AND [defectCode] IS NULL) OR ([defectCode] = @Original_defectCode)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, defectCode, description, active, status, lastupdate, lastupdatedby FROM defectProdHist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[defectQC] WHERE (([defectCode] = @Original_defectCode) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[defectQC] ([defectCode], [description], [active], [lastupdate], [lastupdatedby]) VALUES (@defectCode, @description, @active, @lastupdate, @lastupdatedby); SELECT defectCode, description, active, lastupdate, lastupdatedby FROM defectQC WHERE (defectCode = @defectCode) SELECT defectCode, description, active, lastupdate, lastupdatedby FROM dbo.defectQC UPDATE [dbo].[defectQC] SET [defectCode] = @defectCode, [description] = @description, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([defectCode] = @Original_defectCode) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT defectCode, description, active, lastupdate, lastupdatedby FROM defectQC WHERE (defectCode = @defectCode) DELETE FROM [dbo].[defectQCHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_defectCode = 1 AND [defectCode] IS NULL) OR ([defectCode] = @Original_defectCode)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[defectQCHist] ([defectCode], [description], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@defectCode, @description, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, defectCode, description, active, status, lastupdate, lastupdatedby FROM defectQCHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, defectCode, description, active, status, lastupdate, lastupdatedby FROM dbo.defectQCHist UPDATE [dbo].[defectQCHist] SET [defectCode] = @defectCode, [description] = @description, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_defectCode = 1 AND [defectCode] IS NULL) OR ([defectCode] = @Original_defectCode)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, defectCode, description, active, status, lastupdate, lastupdatedby FROM defectQCHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[FA_NewPT] ([PTno], [FAno], [Quantity], [RegisteredBy], [RegisteredDate]) VALUES (@PTno, @FAno, @Quantity, @RegisteredBy, @RegisteredDate) SELECT PTno, FAno, Quantity, RegisteredBy, RegisteredDate FROM dbo.FA_NewPT DELETE FROM [dbo].[faNo] WHERE (([faId] = @Original_faId) AND ((@IsNull_faNo = 1 AND [faNo] IS NULL) OR ([faNo] = @Original_faNo)) AND ((@IsNull_ptNo = 1 AND [ptNo] IS NULL) OR ([ptNo] = @Original_ptNo)) AND ((@IsNull_suffix = 1 AND [suffix] IS NULL) OR ([suffix] = @Original_suffix)) AND ((@IsNull_stage = 1 AND [stage] IS NULL) OR ([stage] = @Original_stage)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby)) AND ((@IsNull_Quantity = 1 AND [Quantity] IS NULL) OR ([Quantity] = @Original_Quantity)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status))) INSERT INTO [dbo].[faNo] ([faNo], [ptNo], [suffix], [stage], [lastupdate], [lastupdatedby], [Quantity], [status]) VALUES (@faNo, @ptNo, @suffix, @stage, @lastupdate, @lastupdatedby, @Quantity, @status); SELECT faId, faNo, ptNo, suffix, stage, lastupdate, lastupdatedby, Quantity, status FROM faNo WHERE (faId = SCOPE_IDENTITY()) SELECT faId, faNo, ptNo, suffix, stage, lastupdate, lastupdatedby, Quantity, status FROM dbo.faNo UPDATE [dbo].[faNo] SET [faNo] = @faNo, [ptNo] = @ptNo, [suffix] = @suffix, [stage] = @stage, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby, [Quantity] = @Quantity, [status] = @status WHERE (([faId] = @Original_faId) AND ((@IsNull_faNo = 1 AND [faNo] IS NULL) OR ([faNo] = @Original_faNo)) AND ((@IsNull_ptNo = 1 AND [ptNo] IS NULL) OR ([ptNo] = @Original_ptNo)) AND ((@IsNull_suffix = 1 AND [suffix] IS NULL) OR ([suffix] = @Original_suffix)) AND ((@IsNull_stage = 1 AND [stage] IS NULL) OR ([stage] = @Original_stage)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby)) AND ((@IsNull_Quantity = 1 AND [Quantity] IS NULL) OR ([Quantity] = @Original_Quantity)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status))); SELECT faId, faNo, ptNo, suffix, stage, lastupdate, lastupdatedby, Quantity, status FROM faNo WHERE (faId = @faId) INSERT INTO [dbo].[KITTING] ([REV], [PARTNO], [DESC1], [USAGE], [SPQ], [OPERATOR], [KITTINGDATE], [QTY], [FEEDER], [ACCOUNT], [MACHINE], [MODEL], [TYPE], [LINE], [EOH]) VALUES (@REV, @PARTNO, @DESC1, @USAGE, @SPQ, @OPERATOR, @KITTINGDATE, @QTY, @FEEDER, @ACCOUNT, @MACHINE, @MODEL, @TYPE, @LINE, @EOH) SELECT REV, PARTNO, DESC1, USAGE, SPQ, OPERATOR, KITTINGDATE, QTY, FEEDER, ACCOUNT, MACHINE, MODEL, TYPE, LINE, EOH FROM dbo.KITTING INSERT INTO [dbo].[KMOUNTING] ([KMTDATE], [KMTMACHINE], [KMTREVISION], [KMTFEEDER], [KMTPARTNO], [KMTQTY], [KMTLOT], [KMTOPERATOR], [KMTVERIFY], [KMT3PL], [KSEQUENCENO]) VALUES (@KMTDATE, @KMTMACHINE, @KMTREVISION, @KMTFEEDER, @KMTPARTNO, @KMTQTY, @KMTLOT, @KMTOPERATOR, @KMTVERIFY, @KMT3PL, @KSEQUENCENO) SELECT KMTDATE, KMTMACHINE, KMTREVISION, KMTFEEDER, KMTPARTNO, KMTQTY, KMTLOT, KMTOPERATOR, KMTVERIFY, KMT3PL, KSEQUENCENO FROM dbo.KMOUNTING INSERT INTO [dbo].[KSEQUENCE_DETAIL] ([KSQMODULE], [KSQFEEDERNO], [KSQFEEDERTYP], [KSQPARTNO], [KSQTOPSDLOC], [KSQFSBSQTY], [KSQDESC1], [KSQDESC2], [KSQTOPMARK], [KSQREMARKS], [KSEQUENCENO]) VALUES (@KSQMODULE, @KSQFEEDERNO, @KSQFEEDERTYP, @KSQPARTNO, @KSQTOPSDLOC, @KSQFSBSQTY, @KSQDESC1, @KSQDESC2, @KSQTOPMARK, @KSQREMARKS, @KSEQUENCENO) SELECT KSQMODULE, KSQFEEDERNO, KSQFEEDERTYP, KSQPARTNO, KSQTOPSDLOC, KSQFSBSQTY, KSQDESC1, KSQDESC2, KSQTOPMARK, KSQREMARKS, KSEQUENCENO FROM dbo.KSEQUENCE_DETAIL INSERT INTO [dbo].[KSEQUENCE_HEADER] ([KSACCOUNT], [KSQREVISION], [KSQMACHINE], [KSQPCBSIDE], [KSQPREPBY], [KSQCHECKBY], [KSQCHKDATE], [KSQMODEL], [KUPDTTIME], [KSQSTATUS], [KSQLINE], [KSEQUENCENO]) VALUES (@KSACCOUNT, @KSQREVISION, @KSQMACHINE, @KSQPCBSIDE, @KSQPREPBY, @KSQCHECKBY, @KSQCHKDATE, @KSQMODEL, @KUPDTTIME, @KSQSTATUS, @KSQLINE, @KSEQUENCENO) SELECT KSACCOUNT, KSQREVISION, KSQMACHINE, KSQPCBSIDE, KSQPREPBY, KSQCHECKBY, KSQCHKDATE, KSQMODEL, KUPDTTIME, KSQSTATUS, KSQLINE, KSEQUENCENO FROM dbo.KSEQUENCE_HEADER INSERT INTO [dbo].[KSETTINGS] ([line], [ksequence]) VALUES (@line, @ksequence) SELECT set_id, line, ksequence FROM dbo.KSETTINGS DELETE FROM [dbo].[LabelDef] WHERE (([labelFormat1] = @Original_labelFormat1) AND ([labelFormat2] = @Original_labelFormat2) AND ((@IsNull_bartenderFile = 1 AND [bartenderFile] IS NULL) OR ([bartenderFile] = @Original_bartenderFile)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[LabelDef] ([labelFormat1], [labelFormat2], [bartenderFile], [lastupdate], [lastupdatedby]) VALUES (@labelFormat1, @labelFormat2, @bartenderFile, @lastupdate, @lastupdatedby); SELECT labelFormat1, labelFormat2, bartenderFile, lastupdate, lastupdatedby FROM LabelDef WHERE (labelFormat1 = @labelFormat1) AND (labelFormat2 = @labelFormat2) SELECT labelFormat1, labelFormat2, bartenderFile, lastupdate, lastupdatedby FROM dbo.LabelDef UPDATE [dbo].[LabelDef] SET [labelFormat1] = @labelFormat1, [labelFormat2] = @labelFormat2, [bartenderFile] = @bartenderFile, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([labelFormat1] = @Original_labelFormat1) AND ([labelFormat2] = @Original_labelFormat2) AND ((@IsNull_bartenderFile = 1 AND [bartenderFile] IS NULL) OR ([bartenderFile] = @Original_bartenderFile)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT labelFormat1, labelFormat2, bartenderFile, lastupdate, lastupdatedby FROM LabelDef WHERE (labelFormat1 = @labelFormat1) AND (labelFormat2 = @labelFormat2) DELETE FROM [dbo].[LabelDefHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_labelFormat1 = 1 AND [labelFormat1] IS NULL) OR ([labelFormat1] = @Original_labelFormat1)) AND ((@IsNull_labelFormat2 = 1 AND [labelFormat2] IS NULL) OR ([labelFormat2] = @Original_labelFormat2)) AND ((@IsNull_bartenderFile = 1 AND [bartenderFile] IS NULL) OR ([bartenderFile] = @Original_bartenderFile)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[LabelDefHist] ([labelFormat1], [labelFormat2], [bartenderFile], [status], [lastupdate], [lastupdatedby]) VALUES (@labelFormat1, @labelFormat2, @bartenderFile, @status, @lastupdate, @lastupdatedby); SELECT lineNum, labelFormat1, labelFormat2, bartenderFile, status, lastupdate, lastupdatedby FROM LabelDefHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, labelFormat1, labelFormat2, bartenderFile, status, lastupdate, lastupdatedby FROM dbo.LabelDefHist UPDATE [dbo].[LabelDefHist] SET [labelFormat1] = @labelFormat1, [labelFormat2] = @labelFormat2, [bartenderFile] = @bartenderFile, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_labelFormat1 = 1 AND [labelFormat1] IS NULL) OR ([labelFormat1] = @Original_labelFormat1)) AND ((@IsNull_labelFormat2 = 1 AND [labelFormat2] IS NULL) OR ([labelFormat2] = @Original_labelFormat2)) AND ((@IsNull_bartenderFile = 1 AND [bartenderFile] IS NULL) OR ([bartenderFile] = @Original_bartenderFile)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, labelFormat1, labelFormat2, bartenderFile, status, lastupdate, lastupdatedby FROM LabelDefHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[log_action] ([trackingno], [reference], [refType], [serialno], [reason], [lastupdate], [lastupdatedby]) VALUES (@trackingno, @reference, @refType, @serialno, @reason, @lastupdate, @lastupdatedby) SELECT trackingno, reference, refType, serialno, reason, lastupdate, lastupdatedby FROM dbo.log_action DELETE FROM [dbo].[log_alvarion_serial] WHERE (([batchno] = @Original_batchno) AND ((@IsNull_serialStart = 1 AND [serialStart] IS NULL) OR ([serialStart] = @Original_serialStart)) AND ((@IsNull_serialEnd = 1 AND [serialEnd] IS NULL) OR ([serialEnd] = @Original_serialEnd)) AND ((@IsNull_serialStartHex = 1 AND [serialStartHex] IS NULL) OR ([serialStartHex] = @Original_serialStartHex)) AND ((@IsNull_serialEndHex = 1 AND [serialEndHex] IS NULL) OR ([serialEndHex] = @Original_serialEndHex)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_revision = 1 AND [revision] IS NULL) OR ([revision] = @Original_revision)) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_generated = 1 AND [generated] IS NULL) OR ([generated] = @Original_generated)) AND ((@IsNull_generatedby = 1 AND [generatedby] IS NULL) OR ([generatedby] = @Original_generatedby)) AND ((@IsNull_family = 1 AND [family] IS NULL) OR ([family] = @Original_family))) INSERT INTO [dbo].[log_alvarion_serial] ([batchno], [serialStart], [serialEnd], [serialStartHex], [serialEndHex], [model], [revision], [quantity], [generated], [generatedby], [family]) VALUES (@batchno, @serialStart, @serialEnd, @serialStartHex, @serialEndHex, @model, @revision, @quantity, @generated, @generatedby, @family); SELECT batchno, serialStart, serialEnd, serialStartHex, serialEndHex, model, revision, quantity, generated, generatedby, family FROM log_alvarion_serial WHERE (batchno = @batchno) SELECT batchno, serialStart, serialEnd, serialStartHex, serialEndHex, model, revision, quantity, generated, generatedby, family FROM dbo.log_alvarion_serial UPDATE [dbo].[log_alvarion_serial] SET [batchno] = @batchno, [serialStart] = @serialStart, [serialEnd] = @serialEnd, [serialStartHex] = @serialStartHex, [serialEndHex] = @serialEndHex, [model] = @model, [revision] = @revision, [quantity] = @quantity, [generated] = @generated, [generatedby] = @generatedby, [family] = @family WHERE (([batchno] = @Original_batchno) AND ((@IsNull_serialStart = 1 AND [serialStart] IS NULL) OR ([serialStart] = @Original_serialStart)) AND ((@IsNull_serialEnd = 1 AND [serialEnd] IS NULL) OR ([serialEnd] = @Original_serialEnd)) AND ((@IsNull_serialStartHex = 1 AND [serialStartHex] IS NULL) OR ([serialStartHex] = @Original_serialStartHex)) AND ((@IsNull_serialEndHex = 1 AND [serialEndHex] IS NULL) OR ([serialEndHex] = @Original_serialEndHex)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_revision = 1 AND [revision] IS NULL) OR ([revision] = @Original_revision)) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_generated = 1 AND [generated] IS NULL) OR ([generated] = @Original_generated)) AND ((@IsNull_generatedby = 1 AND [generatedby] IS NULL) OR ([generatedby] = @Original_generatedby)) AND ((@IsNull_family = 1 AND [family] IS NULL) OR ([family] = @Original_family))); SELECT batchno, serialStart, serialEnd, serialStartHex, serialEndHex, model, revision, quantity, generated, generatedby, family FROM log_alvarion_serial WHERE (batchno = @batchno) INSERT INTO [dbo].[log_ATE_error] ([serialno], [result], [station], [pc_name], [errormsg], [checked_pn], [mac], [timestamp]) VALUES (@serialno, @result, @station, @pc_name, @errormsg, @checked_pn, @mac, @timestamp) SELECT serialno, result, station, pc_name, errormsg, checked_pn, mac, timestamp FROM dbo.log_ATE_error INSERT INTO [dbo].[log_BL_Detail] ([boxno], [cardno], [serialno], [qty], [model], [modelWt], [lastupdate], [lastupdatedby]) VALUES (@boxno, @cardno, @serialno, @qty, @model, @modelWt, @lastupdate, @lastupdatedby) SELECT boxno, cardno, serialno, qty, model, modelWt, lastupdate, lastupdatedby FROM dbo.log_BL_Detail DELETE FROM [dbo].[log_BL_Detail_Hist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_boxno = 1 AND [boxno] IS NULL) OR ([boxno] = @Original_boxno)) AND ((@IsNull_cardno = 1 AND [cardno] IS NULL) OR ([cardno] = @Original_cardno)) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_qty = 1 AND [qty] IS NULL) OR ([qty] = @Original_qty)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_modelWt = 1 AND [modelWt] IS NULL) OR ([modelWt] = @Original_modelWt)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_BL_Detail_Hist] ([boxno], [cardno], [serialno], [qty], [model], [modelWt], [status], [lastupdate], [lastupdatedby]) VALUES (@boxno, @cardno, @serialno, @qty, @model, @modelWt, @status, @lastupdate, @lastupdatedby); SELECT lineNum, boxno, cardno, serialno, qty, model, modelWt, status, lastupdate, lastupdatedby FROM log_BL_Detail_Hist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, boxno, cardno, serialno, qty, model, modelWt, status, lastupdate, lastupdatedby FROM dbo.log_BL_Detail_Hist UPDATE [dbo].[log_BL_Detail_Hist] SET [boxno] = @boxno, [cardno] = @cardno, [serialno] = @serialno, [qty] = @qty, [model] = @model, [modelWt] = @modelWt, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_boxno = 1 AND [boxno] IS NULL) OR ([boxno] = @Original_boxno)) AND ((@IsNull_cardno = 1 AND [cardno] IS NULL) OR ([cardno] = @Original_cardno)) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_qty = 1 AND [qty] IS NULL) OR ([qty] = @Original_qty)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_modelWt = 1 AND [modelWt] IS NULL) OR ([modelWt] = @Original_modelWt)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, boxno, cardno, serialno, qty, model, modelWt, status, lastupdate, lastupdatedby FROM log_BL_Detail_Hist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[log_BL_Header] WHERE (([boxno] = @Original_boxno) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_po = 1 AND [po] IS NULL) OR ([po] = @Original_po)) AND ((@IsNull_poLine = 1 AND [poLine] IS NULL) OR ([poLine] = @Original_poLine)) AND ((@IsNull_pkType = 1 AND [pkType] IS NULL) OR ([pkType] = @Original_pkType)) AND ((@IsNull_maxQty = 1 AND [maxQty] IS NULL) OR ([maxQty] = @Original_maxQty)) AND ((@IsNull_boxWt = 1 AND [boxWt] IS NULL) OR ([boxWt] = @Original_boxWt)) AND ((@IsNull_boxDim = 1 AND [boxDim] IS NULL) OR ([boxDim] = @Original_boxDim)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_BL_Header] ([boxno], [model], [po], [poLine], [pkType], [maxQty], [boxWt], [boxDim], [lastupdate], [lastupdatedby]) VALUES (@boxno, @model, @po, @poLine, @pkType, @maxQty, @boxWt, @boxDim, @lastupdate, @lastupdatedby); SELECT boxno, model, po, poLine, pkType, maxQty, boxWt, boxDim, lastupdate, lastupdatedby FROM log_BL_Header WHERE (boxno = @boxno) SELECT boxno, model, po, poLine, pkType, maxQty, boxWt, boxDim, lastupdate, lastupdatedby FROM dbo.log_BL_Header UPDATE [dbo].[log_BL_Header] SET [boxno] = @boxno, [model] = @model, [po] = @po, [poLine] = @poLine, [pkType] = @pkType, [maxQty] = @maxQty, [boxWt] = @boxWt, [boxDim] = @boxDim, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([boxno] = @Original_boxno) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_po = 1 AND [po] IS NULL) OR ([po] = @Original_po)) AND ((@IsNull_poLine = 1 AND [poLine] IS NULL) OR ([poLine] = @Original_poLine)) AND ((@IsNull_pkType = 1 AND [pkType] IS NULL) OR ([pkType] = @Original_pkType)) AND ((@IsNull_maxQty = 1 AND [maxQty] IS NULL) OR ([maxQty] = @Original_maxQty)) AND ((@IsNull_boxWt = 1 AND [boxWt] IS NULL) OR ([boxWt] = @Original_boxWt)) AND ((@IsNull_boxDim = 1 AND [boxDim] IS NULL) OR ([boxDim] = @Original_boxDim)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT boxno, model, po, poLine, pkType, maxQty, boxWt, boxDim, lastupdate, lastupdatedby FROM log_BL_Header WHERE (boxno = @boxno) DELETE FROM [dbo].[log_BL_Header_Hist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_boxno = 1 AND [boxno] IS NULL) OR ([boxno] = @Original_boxno)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_po = 1 AND [po] IS NULL) OR ([po] = @Original_po)) AND ((@IsNull_poLine = 1 AND [poLine] IS NULL) OR ([poLine] = @Original_poLine)) AND ((@IsNull_pkType = 1 AND [pkType] IS NULL) OR ([pkType] = @Original_pkType)) AND ((@IsNull_maxQty = 1 AND [maxQty] IS NULL) OR ([maxQty] = @Original_maxQty)) AND ((@IsNull_boxWt = 1 AND [boxWt] IS NULL) OR ([boxWt] = @Original_boxWt)) AND ((@IsNull_boxDim = 1 AND [boxDim] IS NULL) OR ([boxDim] = @Original_boxDim)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_BL_Header_Hist] ([boxno], [model], [po], [poLine], [pkType], [maxQty], [boxWt], [boxDim], [status], [lastupdate], [lastupdatedby]) VALUES (@boxno, @model, @po, @poLine, @pkType, @maxQty, @boxWt, @boxDim, @status, @lastupdate, @lastupdatedby); SELECT lineNum, boxno, model, po, poLine, pkType, maxQty, boxWt, boxDim, status, lastupdate, lastupdatedby FROM log_BL_Header_Hist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, boxno, model, po, poLine, pkType, maxQty, boxWt, boxDim, status, lastupdate, lastupdatedby FROM dbo.log_BL_Header_Hist UPDATE [dbo].[log_BL_Header_Hist] SET [boxno] = @boxno, [model] = @model, [po] = @po, [poLine] = @poLine, [pkType] = @pkType, [maxQty] = @maxQty, [boxWt] = @boxWt, [boxDim] = @boxDim, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_boxno = 1 AND [boxno] IS NULL) OR ([boxno] = @Original_boxno)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_po = 1 AND [po] IS NULL) OR ([po] = @Original_po)) AND ((@IsNull_poLine = 1 AND [poLine] IS NULL) OR ([poLine] = @Original_poLine)) AND ((@IsNull_pkType = 1 AND [pkType] IS NULL) OR ([pkType] = @Original_pkType)) AND ((@IsNull_maxQty = 1 AND [maxQty] IS NULL) OR ([maxQty] = @Original_maxQty)) AND ((@IsNull_boxWt = 1 AND [boxWt] IS NULL) OR ([boxWt] = @Original_boxWt)) AND ((@IsNull_boxDim = 1 AND [boxDim] IS NULL) OR ([boxDim] = @Original_boxDim)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, boxno, model, po, poLine, pkType, maxQty, boxWt, boxDim, status, lastupdate, lastupdatedby FROM log_BL_Header_Hist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[log_CAPA] ([poNumber], [poLine], [cause], [correctiveAction], [category], [rejectdate], [rejectLocation], [lastupdate], [lastupdatedby]) VALUES (@poNumber, @poLine, @cause, @correctiveAction, @category, @rejectdate, @rejectLocation, @lastupdate, @lastupdatedby) SELECT poNumber, poLine, cause, correctiveAction, category, rejectdate, rejectLocation, lastupdate, lastupdatedby FROM dbo.log_CAPA INSERT INTO [dbo].[log_card] ([cardno], [serialno], [status], [lastupdate], [lastupdatedby]) VALUES (@cardno, @serialno, @status, @lastupdate, @lastupdatedby) SELECT cardno, serialno, status, lastupdate, lastupdatedby FROM dbo.log_card INSERT INTO [dbo].[log_CT_Detail] ([CNno], [boxno], [lastupdate], [lastupdatedby]) VALUES (@CNno, @boxno, @lastupdate, @lastupdatedby) SELECT CNno, boxno, lastupdate, lastupdatedby FROM dbo.log_CT_Detail DELETE FROM [dbo].[log_CT_Detail_Hist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_CNno = 1 AND [CNno] IS NULL) OR ([CNno] = @Original_CNno)) AND ((@IsNull_boxno = 1 AND [boxno] IS NULL) OR ([boxno] = @Original_boxno)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_CT_Detail_Hist] ([CNno], [boxno], [status], [lastupdate], [lastupdatedby]) VALUES (@CNno, @boxno, @status, @lastupdate, @lastupdatedby); SELECT lineNum, CNno, boxno, status, lastupdate, lastupdatedby FROM log_CT_Detail_Hist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, CNno, boxno, status, lastupdate, lastupdatedby FROM dbo.log_CT_Detail_Hist UPDATE [dbo].[log_CT_Detail_Hist] SET [CNno] = @CNno, [boxno] = @boxno, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_CNno = 1 AND [CNno] IS NULL) OR ([CNno] = @Original_CNno)) AND ((@IsNull_boxno = 1 AND [boxno] IS NULL) OR ([boxno] = @Original_boxno)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, CNno, boxno, status, lastupdate, lastupdatedby FROM log_CT_Detail_Hist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[log_CT_Header] WHERE (([CNno] = @Original_CNno) AND ((@IsNull_layer = 1 AND [layer] IS NULL) OR ([layer] = @Original_layer)) AND ((@IsNull_dimension = 1 AND [dimension] IS NULL) OR ([dimension] = @Original_dimension)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_CT_Header] ([CNno], [layer], [dimension], [type], [lastupdate], [lastupdatedby]) VALUES (@CNno, @layer, @dimension, @type, @lastupdate, @lastupdatedby); SELECT CNno, layer, dimension, type, lastupdate, lastupdatedby FROM log_CT_Header WHERE (CNno = @CNno) SELECT CNno, layer, dimension, type, lastupdate, lastupdatedby FROM dbo.log_CT_Header UPDATE [dbo].[log_CT_Header] SET [CNno] = @CNno, [layer] = @layer, [dimension] = @dimension, [type] = @type, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([CNno] = @Original_CNno) AND ((@IsNull_layer = 1 AND [layer] IS NULL) OR ([layer] = @Original_layer)) AND ((@IsNull_dimension = 1 AND [dimension] IS NULL) OR ([dimension] = @Original_dimension)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT CNno, layer, dimension, type, lastupdate, lastupdatedby FROM log_CT_Header WHERE (CNno = @CNno) DELETE FROM [dbo].[log_CT_Header_Hist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_CNno = 1 AND [CNno] IS NULL) OR ([CNno] = @Original_CNno)) AND ((@IsNull_layer = 1 AND [layer] IS NULL) OR ([layer] = @Original_layer)) AND ((@IsNull_dimension = 1 AND [dimension] IS NULL) OR ([dimension] = @Original_dimension)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_CT_Header_Hist] ([CNno], [layer], [dimension], [type], [status], [lastupdate], [lastupdatedby]) VALUES (@CNno, @layer, @dimension, @type, @status, @lastupdate, @lastupdatedby); SELECT lineNum, CNno, layer, dimension, type, status, lastupdate, lastupdatedby FROM log_CT_Header_Hist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, CNno, layer, dimension, type, status, lastupdate, lastupdatedby FROM dbo.log_CT_Header_Hist UPDATE [dbo].[log_CT_Header_Hist] SET [CNno] = @CNno, [layer] = @layer, [dimension] = @dimension, [type] = @type, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_CNno = 1 AND [CNno] IS NULL) OR ([CNno] = @Original_CNno)) AND ((@IsNull_layer = 1 AND [layer] IS NULL) OR ([layer] = @Original_layer)) AND ((@IsNull_dimension = 1 AND [dimension] IS NULL) OR ([dimension] = @Original_dimension)) AND ((@IsNull_type = 1 AND [type] IS NULL) OR ([type] = @Original_type)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, CNno, layer, dimension, type, status, lastupdate, lastupdatedby FROM log_CT_Header_Hist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[log_ct_header_temp] ([CNno], [layer], [dimension], [type], [lastupdate], [lastupdatedby]) VALUES (@CNno, @layer, @dimension, @type, @lastupdate, @lastupdatedby) SELECT CNno, layer, dimension, type, lastupdate, lastupdatedby FROM dbo.log_ct_header_temp INSERT INTO [dbo].[log_DA] ([trackingno], [inputType], [serial], [serialFrom], [serialTo], [batchNo], [daNumber], [daDesc], [daRemarks], [lastupdate], [lastupdatedby]) VALUES (@trackingno, @inputType, @serial, @serialFrom, @serialTo, @batchNo, @daNumber, @daDesc, @daRemarks, @lastupdate, @lastupdatedby) SELECT trackingno, inputType, serial, serialFrom, serialTo, batchNo, daNumber, daDesc, daRemarks, lastupdate, lastupdatedby FROM dbo.log_DA INSERT INTO [dbo].[log_label] ([cardno], [serialno], [so], [line], [lastupdate], [lastupdatedby]) VALUES (@cardno, @serialno, @so, @line, @lastupdate, @lastupdatedby) SELECT cardno, serialno, so, line, lastupdate, lastupdatedby FROM dbo.log_label DELETE FROM [dbo].[log_labelHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_cardno = 1 AND [cardno] IS NULL) OR ([cardno] = @Original_cardno)) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_so = 1 AND [so] IS NULL) OR ([so] = @Original_so)) AND ((@IsNull_line = 1 AND [line] IS NULL) OR ([line] = @Original_line)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_labelHist] ([cardno], [serialno], [so], [line], [status], [lastupdate], [lastupdatedby]) VALUES (@cardno, @serialno, @so, @line, @status, @lastupdate, @lastupdatedby); SELECT lineNum, cardno, serialno, so, line, status, lastupdate, lastupdatedby FROM log_labelHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, cardno, serialno, so, line, status, lastupdate, lastupdatedby FROM dbo.log_labelHist UPDATE [dbo].[log_labelHist] SET [cardno] = @cardno, [serialno] = @serialno, [so] = @so, [line] = @line, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_cardno = 1 AND [cardno] IS NULL) OR ([cardno] = @Original_cardno)) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_so = 1 AND [so] IS NULL) OR ([so] = @Original_so)) AND ((@IsNull_line = 1 AND [line] IS NULL) OR ([line] = @Original_line)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, cardno, serialno, so, line, status, lastupdate, lastupdatedby FROM log_labelHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[log_link] ([trackingno], [cardno], [serialno], [cardnoLink], [serialnoLink], [lastupdate], [lastupdatedby]) VALUES (@trackingno, @cardno, @serialno, @cardnoLink, @serialnoLink, @lastupdate, @lastupdatedby) SELECT trackingno, cardno, serialno, cardnoLink, serialnoLink, lastupdate, lastupdatedby FROM dbo.log_link DELETE FROM [dbo].[log_linkHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_cardno = 1 AND [cardno] IS NULL) OR ([cardno] = @Original_cardno)) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_cardnoLink = 1 AND [cardnoLink] IS NULL) OR ([cardnoLink] = @Original_cardnoLink)) AND ((@IsNull_serialnoLink = 1 AND [serialnoLink] IS NULL) OR ([serialnoLink] = @Original_serialnoLink)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_linkHist] ([cardno], [serialno], [cardnoLink], [serialnoLink], [status], [lastupdate], [lastupdatedby]) VALUES (@cardno, @serialno, @cardnoLink, @serialnoLink, @status, @lastupdate, @lastupdatedby); SELECT lineNum, cardno, serialno, cardnoLink, serialnoLink, status, lastupdate, lastupdatedby FROM log_linkHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, cardno, serialno, cardnoLink, serialnoLink, status, lastupdate, lastupdatedby FROM dbo.log_linkHist UPDATE [dbo].[log_linkHist] SET [cardno] = @cardno, [serialno] = @serialno, [cardnoLink] = @cardnoLink, [serialnoLink] = @serialnoLink, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_cardno = 1 AND [cardno] IS NULL) OR ([cardno] = @Original_cardno)) AND ((@IsNull_serialno = 1 AND [serialno] IS NULL) OR ([serialno] = @Original_serialno)) AND ((@IsNull_cardnoLink = 1 AND [cardnoLink] IS NULL) OR ([cardnoLink] = @Original_cardnoLink)) AND ((@IsNull_serialnoLink = 1 AND [serialnoLink] IS NULL) OR ([serialnoLink] = @Original_serialnoLink)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, cardno, serialno, cardnoLink, serialnoLink, status, lastupdate, lastupdatedby FROM log_linkHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[log_lot] ([lotNumber], [stage], [status], [samplingSize], [lastupdate], [lastupdatedby]) VALUES (@lotNumber, @stage, @status, @samplingSize, @lastupdate, @lastupdatedby) SELECT lotNumber, stage, status, samplingSize, lastupdate, lastupdatedby FROM dbo.log_lot INSERT INTO [dbo].[log_pass] ([trackingno], [ptNo], [stage], [quantity], [machine], [status], [lastupdate], [lastupdatedby]) VALUES (@trackingno, @ptNo, @stage, @quantity, @machine, @status, @lastupdate, @lastupdatedby) SELECT trackingno, ptNo, stage, quantity, machine, status, lastupdate, lastupdatedby FROM dbo.log_pass INSERT INTO [dbo].[log_pass_serial] ([trackingno], [cardno], [stage], [machine], [status], [lastupdate], [lastupdatedby]) VALUES (@trackingno, @cardno, @stage, @machine, @status, @lastupdate, @lastupdatedby) SELECT trackingno, cardno, stage, machine, status, lastupdate, lastupdatedby FROM dbo.log_pass_serial INSERT INTO [dbo].[log_PreTest_Detail] ([poNumber], [poLine], [serialno], [serialStatus], [boxNo], [cnNo], [shipNo], [lastupdate], [lastupdatedby]) VALUES (@poNumber, @poLine, @serialno, @serialStatus, @boxNo, @cnNo, @shipNo, @lastupdate, @lastupdatedby) SELECT poNumber, poLine, serialno, serialStatus, boxNo, cnNo, shipNo, lastupdate, lastupdatedby FROM dbo.log_PreTest_Detail DELETE FROM [dbo].[log_repair] WHERE (([trackingno] = @Original_trackingno) AND ((@IsNull_ptNo = 1 AND [ptNo] IS NULL) OR ([ptNo] = @Original_ptNo)) AND ((@IsNull_stage = 1 AND [stage] IS NULL) OR ([stage] = @Original_stage)) AND ((@IsNull_machine = 1 AND [machine] IS NULL) OR ([machine] = @Original_machine)) AND ((@IsNull_category = 1 AND [category] IS NULL) OR ([category] = @Original_category)) AND ((@IsNull_defect = 1 AND [defect] IS NULL) OR ([defect] = @Original_defect)) AND ((@IsNull_location = 1 AND [location] IS NULL) OR ([location] = @Original_location)) AND ((@IsNull_details = 1 AND [details] IS NULL) OR ([details] = @Original_details)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_unitQuantity = 1 AND [unitQuantity] IS NULL) OR ([unitQuantity] = @Original_unitQuantity)) AND ((@IsNull_addinfo = 1 AND [addinfo] IS NULL) OR ([addinfo] = @Original_addinfo)) AND ((@IsNull_serialAffected = 1 AND [serialAffected] IS NULL) OR ([serialAffected] = @Original_serialAffected)) AND ((@IsNull_component = 1 AND [component] IS NULL) OR ([component] = @Original_component)) AND ((@IsNull_remarks = 1 AND [remarks] IS NULL) OR ([remarks] = @Original_remarks)) AND ((@IsNull_rejectDate = 1 AND [rejectDate] IS NULL) OR ([rejectDate] = @Original_rejectDate)) AND ((@IsNull_rejectUser = 1 AND [rejectUser] IS NULL) OR ([rejectUser] = @Original_rejectUser)) AND ((@IsNull_repairDate = 1 AND [repairDate] IS NULL) OR ([repairDate] = @Original_repairDate)) AND ((@IsNull_repairUser = 1 AND [repairUser] IS NULL) OR ([repairUser] = @Original_repairUser)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_repair] ([trackingno], [ptNo], [stage], [machine], [category], [defect], [location], [details], [status], [quantity], [unitQuantity], [addinfo], [serialAffected], [component], [remarks], [rejectDate], [rejectUser], [repairDate], [repairUser], [lastupdate], [lastupdatedby]) VALUES (@trackingno, @ptNo, @stage, @machine, @category, @defect, @location, @details, @status, @quantity, @unitQuantity, @addinfo, @serialAffected, @component, @remarks, @rejectDate, @rejectUser, @repairDate, @repairUser, @lastupdate, @lastupdatedby); SELECT trackingno, ptNo, stage, machine, category, defect, location, details, status, quantity, unitQuantity, addinfo, serialAffected, component, remarks, rejectDate, rejectUser, repairDate, repairUser, lastupdate, lastupdatedby FROM log_repair WHERE (trackingno = @trackingno) SELECT trackingno, ptNo, stage, machine, category, defect, location, details, status, quantity, unitQuantity, addinfo, serialAffected, component, remarks, rejectDate, rejectUser, repairDate, repairUser, lastupdate, lastupdatedby FROM dbo.log_repair UPDATE [dbo].[log_repair] SET [trackingno] = @trackingno, [ptNo] = @ptNo, [stage] = @stage, [machine] = @machine, [category] = @category, [defect] = @defect, [location] = @location, [details] = @details, [status] = @status, [quantity] = @quantity, [unitQuantity] = @unitQuantity, [addinfo] = @addinfo, [serialAffected] = @serialAffected, [component] = @component, [remarks] = @remarks, [rejectDate] = @rejectDate, [rejectUser] = @rejectUser, [repairDate] = @repairDate, [repairUser] = @repairUser, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([trackingno] = @Original_trackingno) AND ((@IsNull_ptNo = 1 AND [ptNo] IS NULL) OR ([ptNo] = @Original_ptNo)) AND ((@IsNull_stage = 1 AND [stage] IS NULL) OR ([stage] = @Original_stage)) AND ((@IsNull_machine = 1 AND [machine] IS NULL) OR ([machine] = @Original_machine)) AND ((@IsNull_category = 1 AND [category] IS NULL) OR ([category] = @Original_category)) AND ((@IsNull_defect = 1 AND [defect] IS NULL) OR ([defect] = @Original_defect)) AND ((@IsNull_location = 1 AND [location] IS NULL) OR ([location] = @Original_location)) AND ((@IsNull_details = 1 AND [details] IS NULL) OR ([details] = @Original_details)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_unitQuantity = 1 AND [unitQuantity] IS NULL) OR ([unitQuantity] = @Original_unitQuantity)) AND ((@IsNull_addinfo = 1 AND [addinfo] IS NULL) OR ([addinfo] = @Original_addinfo)) AND ((@IsNull_serialAffected = 1 AND [serialAffected] IS NULL) OR ([serialAffected] = @Original_serialAffected)) AND ((@IsNull_component = 1 AND [component] IS NULL) OR ([component] = @Original_component)) AND ((@IsNull_remarks = 1 AND [remarks] IS NULL) OR ([remarks] = @Original_remarks)) AND ((@IsNull_rejectDate = 1 AND [rejectDate] IS NULL) OR ([rejectDate] = @Original_rejectDate)) AND ((@IsNull_rejectUser = 1 AND [rejectUser] IS NULL) OR ([rejectUser] = @Original_rejectUser)) AND ((@IsNull_repairDate = 1 AND [repairDate] IS NULL) OR ([repairDate] = @Original_repairDate)) AND ((@IsNull_repairUser = 1 AND [repairUser] IS NULL) OR ([repairUser] = @Original_repairUser)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT trackingno, ptNo, stage, machine, category, defect, location, details, status, quantity, unitQuantity, addinfo, serialAffected, component, remarks, rejectDate, rejectUser, repairDate, repairUser, lastupdate, lastupdatedby FROM log_repair WHERE (trackingno = @trackingno) INSERT INTO [dbo].[log_repair_fa] ([trackingno], [ptNo], [stage], [machine], [category], [defect], [location], [details], [status], [quantity], [unitQuantity], [addinfo], [serialAffected], [component], [remarks], [rejectDate], [rejectUser], [repairDate], [repairUser], [lastupdate], [lastupdatedby]) VALUES (@trackingno, @ptNo, @stage, @machine, @category, @defect, @location, @details, @status, @quantity, @unitQuantity, @addinfo, @serialAffected, @component, @remarks, @rejectDate, @rejectUser, @repairDate, @repairUser, @lastupdate, @lastupdatedby) SELECT trackingno, ptNo, stage, machine, category, defect, location, details, status, quantity, unitQuantity, addinfo, serialAffected, component, remarks, rejectDate, rejectUser, repairDate, repairUser, lastupdate, lastupdatedby FROM dbo.log_repair_fa INSERT INTO [dbo].[log_repair_serial] ([trackingno], [cardno], [stage], [machine], [category], [defect], [location], [details], [status], [addinfo], [serialAffected], [component], [remarks], [rejectDate], [rejectUser], [repairDate], [repairUser], [lastupdate], [lastupdatedby]) VALUES (@trackingno, @cardno, @stage, @machine, @category, @defect, @location, @details, @status, @addinfo, @serialAffected, @component, @remarks, @rejectDate, @rejectUser, @repairDate, @repairUser, @lastupdate, @lastupdatedby) SELECT trackingno, cardno, stage, machine, category, defect, location, details, status, addinfo, serialAffected, component, remarks, rejectDate, rejectUser, repairDate, repairUser, lastupdate, lastupdatedby FROM dbo.log_repair_serial DELETE FROM [dbo].[log_serial] WHERE (([batchno] = @Original_batchno) AND ((@IsNull_serialStart = 1 AND [serialStart] IS NULL) OR ([serialStart] = @Original_serialStart)) AND ((@IsNull_serialEnd = 1 AND [serialEnd] IS NULL) OR ([serialEnd] = @Original_serialEnd)) AND ((@IsNull_serialStartHex = 1 AND [serialStartHex] IS NULL) OR ([serialStartHex] = @Original_serialStartHex)) AND ((@IsNull_serialEndHex = 1 AND [serialEndHex] IS NULL) OR ([serialEndHex] = @Original_serialEndHex)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_revision = 1 AND [revision] IS NULL) OR ([revision] = @Original_revision)) AND ((@IsNull_modelRef = 1 AND [modelRef] IS NULL) OR ([modelRef] = @Original_modelRef)) AND ((@IsNull_modelRefRev = 1 AND [modelRefRev] IS NULL) OR ([modelRefRev] = @Original_modelRefRev)) AND ((@IsNull_alvBatchRef = 1 AND [alvBatchRef] IS NULL) OR ([alvBatchRef] = @Original_alvBatchRef)) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_remarks = 1 AND [remarks] IS NULL) OR ([remarks] = @Original_remarks)) AND ((@IsNull_fileRef = 1 AND [fileRef] IS NULL) OR ([fileRef] = @Original_fileRef)) AND ((@IsNull_fileRef2 = 1 AND [fileRef2] IS NULL) OR ([fileRef2] = @Original_fileRef2)) AND ((@IsNull_generated = 1 AND [generated] IS NULL) OR ([generated] = @Original_generated)) AND ((@IsNull_generatedby = 1 AND [generatedby] IS NULL) OR ([generatedby] = @Original_generatedby))) INSERT INTO [dbo].[log_serial] ([batchno], [serialStart], [serialEnd], [serialStartHex], [serialEndHex], [model], [revision], [modelRef], [modelRefRev], [alvBatchRef], [quantity], [remarks], [fileRef], [fileRef2], [generated], [generatedby]) VALUES (@batchno, @serialStart, @serialEnd, @serialStartHex, @serialEndHex, @model, @revision, @modelRef, @modelRefRev, @alvBatchRef, @quantity, @remarks, @fileRef, @fileRef2, @generated, @generatedby); SELECT batchno, serialStart, serialEnd, serialStartHex, serialEndHex, model, revision, modelRef, modelRefRev, alvBatchRef, quantity, remarks, fileRef, fileRef2, generated, generatedby FROM log_serial WHERE (batchno = @batchno) SELECT batchno, serialStart, serialEnd, serialStartHex, serialEndHex, model, revision, modelRef, modelRefRev, alvBatchRef, quantity, remarks, fileRef, fileRef2, generated, generatedby FROM dbo.log_serial UPDATE [dbo].[log_serial] SET [batchno] = @batchno, [serialStart] = @serialStart, [serialEnd] = @serialEnd, [serialStartHex] = @serialStartHex, [serialEndHex] = @serialEndHex, [model] = @model, [revision] = @revision, [modelRef] = @modelRef, [modelRefRev] = @modelRefRev, [alvBatchRef] = @alvBatchRef, [quantity] = @quantity, [remarks] = @remarks, [fileRef] = @fileRef, [fileRef2] = @fileRef2, [generated] = @generated, [generatedby] = @generatedby WHERE (([batchno] = @Original_batchno) AND ((@IsNull_serialStart = 1 AND [serialStart] IS NULL) OR ([serialStart] = @Original_serialStart)) AND ((@IsNull_serialEnd = 1 AND [serialEnd] IS NULL) OR ([serialEnd] = @Original_serialEnd)) AND ((@IsNull_serialStartHex = 1 AND [serialStartHex] IS NULL) OR ([serialStartHex] = @Original_serialStartHex)) AND ((@IsNull_serialEndHex = 1 AND [serialEndHex] IS NULL) OR ([serialEndHex] = @Original_serialEndHex)) AND ((@IsNull_model = 1 AND [model] IS NULL) OR ([model] = @Original_model)) AND ((@IsNull_revision = 1 AND [revision] IS NULL) OR ([revision] = @Original_revision)) AND ((@IsNull_modelRef = 1 AND [modelRef] IS NULL) OR ([modelRef] = @Original_modelRef)) AND ((@IsNull_modelRefRev = 1 AND [modelRefRev] IS NULL) OR ([modelRefRev] = @Original_modelRefRev)) AND ((@IsNull_alvBatchRef = 1 AND [alvBatchRef] IS NULL) OR ([alvBatchRef] = @Original_alvBatchRef)) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_remarks = 1 AND [remarks] IS NULL) OR ([remarks] = @Original_remarks)) AND ((@IsNull_fileRef = 1 AND [fileRef] IS NULL) OR ([fileRef] = @Original_fileRef)) AND ((@IsNull_fileRef2 = 1 AND [fileRef2] IS NULL) OR ([fileRef2] = @Original_fileRef2)) AND ((@IsNull_generated = 1 AND [generated] IS NULL) OR ([generated] = @Original_generated)) AND ((@IsNull_generatedby = 1 AND [generatedby] IS NULL) OR ([generatedby] = @Original_generatedby))); SELECT batchno, serialStart, serialEnd, serialStartHex, serialEndHex, model, revision, modelRef, modelRefRev, alvBatchRef, quantity, remarks, fileRef, fileRef2, generated, generatedby FROM log_serial WHERE (batchno = @batchno) INSERT INTO [dbo].[log_SH_Detail] ([shipNo], [cnNo], [lastupdate], [lastupdatedby]) VALUES (@shipNo, @cnNo, @lastupdate, @lastupdatedby) SELECT shipNo, cnNo, lastupdate, lastupdatedby FROM dbo.log_SH_Detail DELETE FROM [dbo].[log_SH_Detail_Hist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_shipNo = 1 AND [shipNo] IS NULL) OR ([shipNo] = @Original_shipNo)) AND ((@IsNull_cnNo = 1 AND [cnNo] IS NULL) OR ([cnNo] = @Original_cnNo)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_SH_Detail_Hist] ([shipNo], [cnNo], [status], [lastupdate], [lastupdatedby]) VALUES (@shipNo, @cnNo, @status, @lastupdate, @lastupdatedby); SELECT lineNum, shipNo, cnNo, status, lastupdate, lastupdatedby FROM log_SH_Detail_Hist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, shipNo, cnNo, status, lastupdate, lastupdatedby FROM dbo.log_SH_Detail_Hist UPDATE [dbo].[log_SH_Detail_Hist] SET [shipNo] = @shipNo, [cnNo] = @cnNo, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_shipNo = 1 AND [shipNo] IS NULL) OR ([shipNo] = @Original_shipNo)) AND ((@IsNull_cnNo = 1 AND [cnNo] IS NULL) OR ([cnNo] = @Original_cnNo)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, shipNo, cnNo, status, lastupdate, lastupdatedby FROM log_SH_Detail_Hist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[log_SH_Header] WHERE (([shipNo] = @Original_shipNo) AND ((@IsNull_shipdate = 1 AND [shipdate] IS NULL) OR ([shipdate] = @Original_shipdate)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_SH_Header] ([shipNo], [shipdate], [lastupdate], [lastupdatedby]) VALUES (@shipNo, @shipdate, @lastupdate, @lastupdatedby); SELECT shipNo, shipdate, lastupdate, lastupdatedby FROM log_SH_Header WHERE (shipNo = @shipNo) SELECT shipNo, shipdate, lastupdate, lastupdatedby FROM dbo.log_SH_Header UPDATE [dbo].[log_SH_Header] SET [shipNo] = @shipNo, [shipdate] = @shipdate, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([shipNo] = @Original_shipNo) AND ((@IsNull_shipdate = 1 AND [shipdate] IS NULL) OR ([shipdate] = @Original_shipdate)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT shipNo, shipdate, lastupdate, lastupdatedby FROM log_SH_Header WHERE (shipNo = @shipNo) DELETE FROM [dbo].[log_SH_Header_Hist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_shipNo = 1 AND [shipNo] IS NULL) OR ([shipNo] = @Original_shipNo)) AND ((@IsNull_shipdate = 1 AND [shipdate] IS NULL) OR ([shipdate] = @Original_shipdate)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[log_SH_Header_Hist] ([shipNo], [shipdate], [status], [lastupdate], [lastupdatedby]) VALUES (@shipNo, @shipdate, @status, @lastupdate, @lastupdatedby); SELECT lineNum, shipNo, shipdate, status, lastupdate, lastupdatedby FROM log_SH_Header_Hist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, shipNo, shipdate, status, lastupdate, lastupdatedby FROM dbo.log_SH_Header_Hist UPDATE [dbo].[log_SH_Header_Hist] SET [shipNo] = @shipNo, [shipdate] = @shipdate, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_shipNo = 1 AND [shipNo] IS NULL) OR ([shipNo] = @Original_shipNo)) AND ((@IsNull_shipdate = 1 AND [shipdate] IS NULL) OR ([shipdate] = @Original_shipdate)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, shipNo, shipdate, status, lastupdate, lastupdatedby FROM log_SH_Header_Hist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[lotNo] ([lotNo], [referenceNo], [partno], [stage], [status], [samplingSize], [starttime], [lastupdate], [lastupdatedby]) VALUES (@lotNo, @referenceNo, @partno, @stage, @status, @samplingSize, @starttime, @lastupdate, @lastupdatedby) SELECT lotNo, referenceNo, partno, stage, status, samplingSize, starttime, lastupdate, lastupdatedby FROM dbo.lotNo DELETE FROM [dbo].[LotNumber] WHERE (([Lotnumber] = @Original_Lotnumber) AND ((@IsNull_LotStatus = 1 AND [LotStatus] IS NULL) OR ([LotStatus] = @Original_LotStatus)) AND ([CreatedDate] = @Original_CreatedDate) AND ([CreatedBy] = @Original_CreatedBy) AND ((@IsNull_UpdatedDate = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)) AND ((@IsNull_UpdatedBy = 1 AND [UpdatedBy] IS NULL) OR ([UpdatedBy] = @Original_UpdatedBy)) AND ((@IsNull_SampleQuantity = 1 AND [SampleQuantity] IS NULL) OR ([SampleQuantity] = @Original_SampleQuantity))) INSERT INTO [dbo].[LotNumber] ([Lotnumber], [LotStatus], [CreatedDate], [CreatedBy], [UpdatedDate], [UpdatedBy], [SampleQuantity]) VALUES (@Lotnumber, @LotStatus, @CreatedDate, @CreatedBy, @UpdatedDate, @UpdatedBy, @SampleQuantity); SELECT Lotnumber, LotStatus, CreatedDate, CreatedBy, UpdatedDate, UpdatedBy, SampleQuantity FROM LotNumber WHERE (Lotnumber = @Lotnumber) SELECT Lotnumber, LotStatus, CreatedDate, CreatedBy, UpdatedDate, UpdatedBy, SampleQuantity FROM dbo.LotNumber UPDATE [dbo].[LotNumber] SET [Lotnumber] = @Lotnumber, [LotStatus] = @LotStatus, [CreatedDate] = @CreatedDate, [CreatedBy] = @CreatedBy, [UpdatedDate] = @UpdatedDate, [UpdatedBy] = @UpdatedBy, [SampleQuantity] = @SampleQuantity WHERE (([Lotnumber] = @Original_Lotnumber) AND ((@IsNull_LotStatus = 1 AND [LotStatus] IS NULL) OR ([LotStatus] = @Original_LotStatus)) AND ([CreatedDate] = @Original_CreatedDate) AND ([CreatedBy] = @Original_CreatedBy) AND ((@IsNull_UpdatedDate = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)) AND ((@IsNull_UpdatedBy = 1 AND [UpdatedBy] IS NULL) OR ([UpdatedBy] = @Original_UpdatedBy)) AND ((@IsNull_SampleQuantity = 1 AND [SampleQuantity] IS NULL) OR ([SampleQuantity] = @Original_SampleQuantity))); SELECT Lotnumber, LotStatus, CreatedDate, CreatedBy, UpdatedDate, UpdatedBy, SampleQuantity FROM LotNumber WHERE (Lotnumber = @Lotnumber) DELETE FROM [dbo].[machine] WHERE (([machine] = @Original_machine) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[machine] ([machine], [description], [active], [lastupdate], [lastupdatedby]) VALUES (@machine, @description, @active, @lastupdate, @lastupdatedby); SELECT machine, description, active, lastupdate, lastupdatedby FROM machine WHERE (machine = @machine) SELECT machine, description, active, lastupdate, lastupdatedby FROM dbo.machine UPDATE [dbo].[machine] SET [machine] = @machine, [description] = @description, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([machine] = @Original_machine) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT machine, description, active, lastupdate, lastupdatedby FROM machine WHERE (machine = @machine) DELETE FROM [dbo].[machineHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_machine = 1 AND [machine] IS NULL) OR ([machine] = @Original_machine)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[machineHist] ([machine], [description], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@machine, @description, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, machine, description, active, status, lastupdate, lastupdatedby FROM machineHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, machine, description, active, status, lastupdate, lastupdatedby FROM dbo.machineHist UPDATE [dbo].[machineHist] SET [machine] = @machine, [description] = @description, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_machine = 1 AND [machine] IS NULL) OR ([machine] = @Original_machine)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, machine, description, active, status, lastupdate, lastupdatedby FROM machineHist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[model] WHERE (([modelno] = @Original_modelno) AND ((@IsNull_modelDesc1 = 1 AND [modelDesc1] IS NULL) OR ([modelDesc1] = @Original_modelDesc1)) AND ((@IsNull_modelDesc2 = 1 AND [modelDesc2] IS NULL) OR ([modelDesc2] = @Original_modelDesc2)) AND ((@IsNull_modelFamily = 1 AND [modelFamily] IS NULL) OR ([modelFamily] = @Original_modelFamily)) AND ((@IsNull_modelType = 1 AND [modelType] IS NULL) OR ([modelType] = @Original_modelType)) AND ((@IsNull_minRev = 1 AND [minRev] IS NULL) OR ([minRev] = @Original_minRev)) AND ((@IsNull_latestRev = 1 AND [latestRev] IS NULL) OR ([latestRev] = @Original_latestRev)) AND ((@IsNull_itemWt = 1 AND [itemWt] IS NULL) OR ([itemWt] = @Original_itemWt)) AND ((@IsNull_batch = 1 AND [batch] IS NULL) OR ([batch] = @Original_batch)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[model] ([modelno], [modelDesc1], [modelDesc2], [modelFamily], [modelType], [minRev], [latestRev], [itemWt], [batch], [active], [lastupdate], [lastupdatedby]) VALUES (@modelno, @modelDesc1, @modelDesc2, @modelFamily, @modelType, @minRev, @latestRev, @itemWt, @batch, @active, @lastupdate, @lastupdatedby); SELECT modelno, modelDesc1, modelDesc2, modelFamily, modelType, minRev, latestRev, itemWt, batch, active, lastupdate, lastupdatedby FROM model WHERE (modelno = @modelno) SELECT modelno, modelDesc1, modelDesc2, modelFamily, modelType, minRev, latestRev, itemWt, batch, active, lastupdate, lastupdatedby FROM dbo.model UPDATE [dbo].[model] SET [modelno] = @modelno, [modelDesc1] = @modelDesc1, [modelDesc2] = @modelDesc2, [modelFamily] = @modelFamily, [modelType] = @modelType, [minRev] = @minRev, [latestRev] = @latestRev, [itemWt] = @itemWt, [batch] = @batch, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([modelno] = @Original_modelno) AND ((@IsNull_modelDesc1 = 1 AND [modelDesc1] IS NULL) OR ([modelDesc1] = @Original_modelDesc1)) AND ((@IsNull_modelDesc2 = 1 AND [modelDesc2] IS NULL) OR ([modelDesc2] = @Original_modelDesc2)) AND ((@IsNull_modelFamily = 1 AND [modelFamily] IS NULL) OR ([modelFamily] = @Original_modelFamily)) AND ((@IsNull_modelType = 1 AND [modelType] IS NULL) OR ([modelType] = @Original_modelType)) AND ((@IsNull_minRev = 1 AND [minRev] IS NULL) OR ([minRev] = @Original_minRev)) AND ((@IsNull_latestRev = 1 AND [latestRev] IS NULL) OR ([latestRev] = @Original_latestRev)) AND ((@IsNull_itemWt = 1 AND [itemWt] IS NULL) OR ([itemWt] = @Original_itemWt)) AND ((@IsNull_batch = 1 AND [batch] IS NULL) OR ([batch] = @Original_batch)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT modelno, modelDesc1, modelDesc2, modelFamily, modelType, minRev, latestRev, itemWt, batch, active, lastupdate, lastupdatedby FROM model WHERE (modelno = @modelno) INSERT INTO [dbo].[modelBackup] ([modelno], [modelDesc1], [modelDesc2], [modelFamily], [modelType], [minRev], [latestRev], [active], [lastupdate], [lastupdatedby]) VALUES (@modelno, @modelDesc1, @modelDesc2, @modelFamily, @modelType, @minRev, @latestRev, @active, @lastupdate, @lastupdatedby) SELECT modelno, modelDesc1, modelDesc2, modelFamily, modelType, minRev, latestRev, active, lastupdate, lastupdatedby FROM dbo.modelBackup DELETE FROM [dbo].[modelDim] WHERE (([modelno] = @Original_modelno) AND ((@IsNull_length = 1 AND [length] IS NULL) OR ([length] = @Original_length)) AND ((@IsNull_width = 1 AND [width] IS NULL) OR ([width] = @Original_width)) AND ((@IsNull_height = 1 AND [height] IS NULL) OR ([height] = @Original_height)) AND ((@IsNull_layerCount = 1 AND [layerCount] IS NULL) OR ([layerCount] = @Original_layerCount)) AND ((@IsNull_dimType = 1 AND [dimType] IS NULL) OR ([dimType] = @Original_dimType)) AND ((@IsNull_packingno = 1 AND [packingno] IS NULL) OR ([packingno] = @Original_packingno)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelDim] ([modelno], [length], [width], [height], [layerCount], [dimType], [packingno], [lastupdate], [lastupdatedby]) VALUES (@modelno, @length, @width, @height, @layerCount, @dimType, @packingno, @lastupdate, @lastupdatedby); SELECT modelno, length, width, height, layerCount, dimType, packingno, lastupdate, lastupdatedby FROM modelDim WHERE (modelno = @modelno) SELECT modelno, length, width, height, layerCount, dimType, packingno, lastupdate, lastupdatedby FROM dbo.modelDim UPDATE [dbo].[modelDim] SET [modelno] = @modelno, [length] = @length, [width] = @width, [height] = @height, [layerCount] = @layerCount, [dimType] = @dimType, [packingno] = @packingno, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([modelno] = @Original_modelno) AND ((@IsNull_length = 1 AND [length] IS NULL) OR ([length] = @Original_length)) AND ((@IsNull_width = 1 AND [width] IS NULL) OR ([width] = @Original_width)) AND ((@IsNull_height = 1 AND [height] IS NULL) OR ([height] = @Original_height)) AND ((@IsNull_layerCount = 1 AND [layerCount] IS NULL) OR ([layerCount] = @Original_layerCount)) AND ((@IsNull_dimType = 1 AND [dimType] IS NULL) OR ([dimType] = @Original_dimType)) AND ((@IsNull_packingno = 1 AND [packingno] IS NULL) OR ([packingno] = @Original_packingno)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT modelno, length, width, height, layerCount, dimType, packingno, lastupdate, lastupdatedby FROM modelDim WHERE (modelno = @modelno) DELETE FROM [dbo].[modelDimHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelno = 1 AND [modelno] IS NULL) OR ([modelno] = @Original_modelno)) AND ((@IsNull_length = 1 AND [length] IS NULL) OR ([length] = @Original_length)) AND ((@IsNull_width = 1 AND [width] IS NULL) OR ([width] = @Original_width)) AND ((@IsNull_height = 1 AND [height] IS NULL) OR ([height] = @Original_height)) AND ((@IsNull_layerCount = 1 AND [layerCount] IS NULL) OR ([layerCount] = @Original_layerCount)) AND ((@IsNull_dimType = 1 AND [dimType] IS NULL) OR ([dimType] = @Original_dimType)) AND ((@IsNull_packingno = 1 AND [packingno] IS NULL) OR ([packingno] = @Original_packingno)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelDimHist] ([modelno], [length], [width], [height], [layerCount], [dimType], [packingno], [status], [lastupdate], [lastupdatedby]) VALUES (@modelno, @length, @width, @height, @layerCount, @dimType, @packingno, @status, @lastupdate, @lastupdatedby); SELECT lineNum, modelno, length, width, height, layerCount, dimType, packingno, status, lastupdate, lastupdatedby FROM modelDimHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, modelno, length, width, height, layerCount, dimType, packingno, status, lastupdate, lastupdatedby FROM dbo.modelDimHist UPDATE [dbo].[modelDimHist] SET [modelno] = @modelno, [length] = @length, [width] = @width, [height] = @height, [layerCount] = @layerCount, [dimType] = @dimType, [packingno] = @packingno, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelno = 1 AND [modelno] IS NULL) OR ([modelno] = @Original_modelno)) AND ((@IsNull_length = 1 AND [length] IS NULL) OR ([length] = @Original_length)) AND ((@IsNull_width = 1 AND [width] IS NULL) OR ([width] = @Original_width)) AND ((@IsNull_height = 1 AND [height] IS NULL) OR ([height] = @Original_height)) AND ((@IsNull_layerCount = 1 AND [layerCount] IS NULL) OR ([layerCount] = @Original_layerCount)) AND ((@IsNull_dimType = 1 AND [dimType] IS NULL) OR ([dimType] = @Original_dimType)) AND ((@IsNull_packingno = 1 AND [packingno] IS NULL) OR ([packingno] = @Original_packingno)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, modelno, length, width, height, layerCount, dimType, packingno, status, lastupdate, lastupdatedby FROM modelDimHist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[modelFamily] WHERE (([modelFamily] = @Original_modelFamily) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelFamily] ([modelFamily], [description], [active], [lastupdate], [lastupdatedby]) VALUES (@modelFamily, @description, @active, @lastupdate, @lastupdatedby); SELECT modelFamily, description, active, lastupdate, lastupdatedby FROM modelFamily WHERE (modelFamily = @modelFamily) SELECT modelFamily, description, active, lastupdate, lastupdatedby FROM dbo.modelFamily UPDATE [dbo].[modelFamily] SET [modelFamily] = @modelFamily, [description] = @description, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([modelFamily] = @Original_modelFamily) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT modelFamily, description, active, lastupdate, lastupdatedby FROM modelFamily WHERE (modelFamily = @modelFamily) DELETE FROM [dbo].[modelFamilyHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelFamily = 1 AND [modelFamily] IS NULL) OR ([modelFamily] = @Original_modelFamily)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelFamilyHist] ([modelFamily], [description], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@modelFamily, @description, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, modelFamily, description, active, status, lastupdate, lastupdatedby FROM modelFamilyHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, modelFamily, description, active, status, lastupdate, lastupdatedby FROM dbo.modelFamilyHist UPDATE [dbo].[modelFamilyHist] SET [modelFamily] = @modelFamily, [description] = @description, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelFamily = 1 AND [modelFamily] IS NULL) OR ([modelFamily] = @Original_modelFamily)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, modelFamily, description, active, status, lastupdate, lastupdatedby FROM modelFamilyHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[modelHierarchy] ([modelno], [descendant], [mlevel], [carrySerial], [active], [lastupdate], [lastupdatedby]) VALUES (@modelno, @descendant, @mlevel, @carrySerial, @active, @lastupdate, @lastupdatedby) SELECT modelno, descendant, mlevel, carrySerial, active, lastupdate, lastupdatedby FROM dbo.modelHierarchy DELETE FROM [dbo].[modelHierarchyHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelno = 1 AND [modelno] IS NULL) OR ([modelno] = @Original_modelno)) AND ((@IsNull_descendant = 1 AND [descendant] IS NULL) OR ([descendant] = @Original_descendant)) AND ((@IsNull_mlevel = 1 AND [mlevel] IS NULL) OR ([mlevel] = @Original_mlevel)) AND ((@IsNull_carrySerial = 1 AND [carrySerial] IS NULL) OR ([carrySerial] = @Original_carrySerial)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelHierarchyHist] ([modelno], [descendant], [mlevel], [carrySerial], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@modelno, @descendant, @mlevel, @carrySerial, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, modelno, descendant, mlevel, carrySerial, active, status, lastupdate, lastupdatedby FROM modelHierarchyHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, modelno, descendant, mlevel, carrySerial, active, status, lastupdate, lastupdatedby FROM dbo.modelHierarchyHist UPDATE [dbo].[modelHierarchyHist] SET [modelno] = @modelno, [descendant] = @descendant, [mlevel] = @mlevel, [carrySerial] = @carrySerial, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelno = 1 AND [modelno] IS NULL) OR ([modelno] = @Original_modelno)) AND ((@IsNull_descendant = 1 AND [descendant] IS NULL) OR ([descendant] = @Original_descendant)) AND ((@IsNull_mlevel = 1 AND [mlevel] IS NULL) OR ([mlevel] = @Original_mlevel)) AND ((@IsNull_carrySerial = 1 AND [carrySerial] IS NULL) OR ([carrySerial] = @Original_carrySerial)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, modelno, descendant, mlevel, carrySerial, active, status, lastupdate, lastupdatedby FROM modelHierarchyHist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[modelHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelno = 1 AND [modelno] IS NULL) OR ([modelno] = @Original_modelno)) AND ((@IsNull_modelDesc1 = 1 AND [modelDesc1] IS NULL) OR ([modelDesc1] = @Original_modelDesc1)) AND ((@IsNull_modelDesc2 = 1 AND [modelDesc2] IS NULL) OR ([modelDesc2] = @Original_modelDesc2)) AND ((@IsNull_modelFamily = 1 AND [modelFamily] IS NULL) OR ([modelFamily] = @Original_modelFamily)) AND ((@IsNull_modelType = 1 AND [modelType] IS NULL) OR ([modelType] = @Original_modelType)) AND ((@IsNull_minRev = 1 AND [minRev] IS NULL) OR ([minRev] = @Original_minRev)) AND ((@IsNull_latestRev = 1 AND [latestRev] IS NULL) OR ([latestRev] = @Original_latestRev)) AND ((@IsNull_itemWt = 1 AND [itemWt] IS NULL) OR ([itemWt] = @Original_itemWt)) AND ((@IsNull_batch = 1 AND [batch] IS NULL) OR ([batch] = @Original_batch)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelHist] ([modelno], [modelDesc1], [modelDesc2], [modelFamily], [modelType], [minRev], [latestRev], [itemWt], [batch], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@modelno, @modelDesc1, @modelDesc2, @modelFamily, @modelType, @minRev, @latestRev, @itemWt, @batch, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, modelno, modelDesc1, modelDesc2, modelFamily, modelType, minRev, latestRev, itemWt, batch, active, status, lastupdate, lastupdatedby FROM modelHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, modelno, modelDesc1, modelDesc2, modelFamily, modelType, minRev, latestRev, itemWt, batch, active, status, lastupdate, lastupdatedby FROM dbo.modelHist UPDATE [dbo].[modelHist] SET [modelno] = @modelno, [modelDesc1] = @modelDesc1, [modelDesc2] = @modelDesc2, [modelFamily] = @modelFamily, [modelType] = @modelType, [minRev] = @minRev, [latestRev] = @latestRev, [itemWt] = @itemWt, [batch] = @batch, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelno = 1 AND [modelno] IS NULL) OR ([modelno] = @Original_modelno)) AND ((@IsNull_modelDesc1 = 1 AND [modelDesc1] IS NULL) OR ([modelDesc1] = @Original_modelDesc1)) AND ((@IsNull_modelDesc2 = 1 AND [modelDesc2] IS NULL) OR ([modelDesc2] = @Original_modelDesc2)) AND ((@IsNull_modelFamily = 1 AND [modelFamily] IS NULL) OR ([modelFamily] = @Original_modelFamily)) AND ((@IsNull_modelType = 1 AND [modelType] IS NULL) OR ([modelType] = @Original_modelType)) AND ((@IsNull_minRev = 1 AND [minRev] IS NULL) OR ([minRev] = @Original_minRev)) AND ((@IsNull_latestRev = 1 AND [latestRev] IS NULL) OR ([latestRev] = @Original_latestRev)) AND ((@IsNull_itemWt = 1 AND [itemWt] IS NULL) OR ([itemWt] = @Original_itemWt)) AND ((@IsNull_batch = 1 AND [batch] IS NULL) OR ([batch] = @Original_batch)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, modelno, modelDesc1, modelDesc2, modelFamily, modelType, minRev, latestRev, itemWt, batch, active, status, lastupdate, lastupdatedby FROM modelHist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[modelRoute] WHERE (([modelno] = @Original_modelno) AND ((@IsNull_flowsequence = 1 AND [flowsequence] IS NULL) OR ([flowsequence] = @Original_flowsequence)) AND ([station] = @Original_station) AND ((@IsNull_skip = 1 AND [skip] IS NULL) OR ([skip] = @Original_skip)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastStation = 1 AND [lastStation] IS NULL) OR ([lastStation] = @Original_lastStation)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelRoute] ([modelno], [flowsequence], [station], [skip], [active], [lastStation], [lastupdate], [lastupdatedby]) VALUES (@modelno, @flowsequence, @station, @skip, @active, @lastStation, @lastupdate, @lastupdatedby); SELECT modelno, flowsequence, station, skip, active, lastStation, lastupdate, lastupdatedby FROM modelRoute WHERE (modelno = @modelno) AND (station = @station) SELECT modelno, flowsequence, station, skip, active, lastStation, lastupdate, lastupdatedby FROM dbo.modelRoute UPDATE [dbo].[modelRoute] SET [modelno] = @modelno, [flowsequence] = @flowsequence, [station] = @station, [skip] = @skip, [active] = @active, [lastStation] = @lastStation, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([modelno] = @Original_modelno) AND ((@IsNull_flowsequence = 1 AND [flowsequence] IS NULL) OR ([flowsequence] = @Original_flowsequence)) AND ([station] = @Original_station) AND ((@IsNull_skip = 1 AND [skip] IS NULL) OR ([skip] = @Original_skip)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastStation = 1 AND [lastStation] IS NULL) OR ([lastStation] = @Original_lastStation)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT modelno, flowsequence, station, skip, active, lastStation, lastupdate, lastupdatedby FROM modelRoute WHERE (modelno = @modelno) AND (station = @station) INSERT INTO [dbo].[modelRoute_backup_1] ([modelno], [flowsequence], [station], [skip], [active], [lastStation], [lastupdate], [lastupdatedby]) VALUES (@modelno, @flowsequence, @station, @skip, @active, @lastStation, @lastupdate, @lastupdatedby) SELECT modelno, flowsequence, station, skip, active, lastStation, lastupdate, lastupdatedby FROM dbo.modelRoute_backup_1 DELETE FROM [dbo].[modelRouteHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelno = 1 AND [modelno] IS NULL) OR ([modelno] = @Original_modelno)) AND ((@IsNull_flowsequence = 1 AND [flowsequence] IS NULL) OR ([flowsequence] = @Original_flowsequence)) AND ((@IsNull_station = 1 AND [station] IS NULL) OR ([station] = @Original_station)) AND ((@IsNull_skip = 1 AND [skip] IS NULL) OR ([skip] = @Original_skip)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastStation = 1 AND [lastStation] IS NULL) OR ([lastStation] = @Original_lastStation)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelRouteHist] ([modelno], [flowsequence], [station], [skip], [active], [lastStation], [status], [lastupdate], [lastupdatedby]) VALUES (@modelno, @flowsequence, @station, @skip, @active, @lastStation, @status, @lastupdate, @lastupdatedby); SELECT lineNum, modelno, flowsequence, station, skip, active, lastStation, status, lastupdate, lastupdatedby FROM modelRouteHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, modelno, flowsequence, station, skip, active, lastStation, status, lastupdate, lastupdatedby FROM dbo.modelRouteHist UPDATE [dbo].[modelRouteHist] SET [modelno] = @modelno, [flowsequence] = @flowsequence, [station] = @station, [skip] = @skip, [active] = @active, [lastStation] = @lastStation, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelno = 1 AND [modelno] IS NULL) OR ([modelno] = @Original_modelno)) AND ((@IsNull_flowsequence = 1 AND [flowsequence] IS NULL) OR ([flowsequence] = @Original_flowsequence)) AND ((@IsNull_station = 1 AND [station] IS NULL) OR ([station] = @Original_station)) AND ((@IsNull_skip = 1 AND [skip] IS NULL) OR ([skip] = @Original_skip)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastStation = 1 AND [lastStation] IS NULL) OR ([lastStation] = @Original_lastStation)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, modelno, flowsequence, station, skip, active, lastStation, status, lastupdate, lastupdatedby FROM modelRouteHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[modelTemp] ([modelno], [modelDesc1], [modelDesc2], [modelFamily], [modelType], [minRev], [latestRev], [batch], [active], [lastupdate], [lastupdatedby]) VALUES (@modelno, @modelDesc1, @modelDesc2, @modelFamily, @modelType, @minRev, @latestRev, @batch, @active, @lastupdate, @lastupdatedby) SELECT modelno, modelDesc1, modelDesc2, modelFamily, modelType, minRev, latestRev, batch, active, lastupdate, lastupdatedby FROM dbo.modelTemp DELETE FROM [dbo].[modelType] WHERE (([modelType] = @Original_modelType) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelType] ([modelType], [description], [active], [lastupdate], [lastupdatedby]) VALUES (@modelType, @description, @active, @lastupdate, @lastupdatedby); SELECT modelType, description, active, lastupdate, lastupdatedby FROM modelType WHERE (modelType = @modelType) SELECT modelType, description, active, lastupdate, lastupdatedby FROM dbo.modelType UPDATE [dbo].[modelType] SET [modelType] = @modelType, [description] = @description, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([modelType] = @Original_modelType) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT modelType, description, active, lastupdate, lastupdatedby FROM modelType WHERE (modelType = @modelType) DELETE FROM [dbo].[modelTypeHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelType = 1 AND [modelType] IS NULL) OR ([modelType] = @Original_modelType)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[modelTypeHist] ([modelType], [description], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@modelType, @description, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, modelType, description, active, status, lastupdate, lastupdatedby FROM modelTypeHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, modelType, description, active, status, lastupdate, lastupdatedby FROM dbo.modelTypeHist UPDATE [dbo].[modelTypeHist] SET [modelType] = @modelType, [description] = @description, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_modelType = 1 AND [modelType] IS NULL) OR ([modelType] = @Original_modelType)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, modelType, description, active, status, lastupdate, lastupdatedby FROM modelTypeHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[Parts_List] ([Descriptions_Parameter_Desc], [Item_Code], [Item_Item_Desc]) VALUES (@Descriptions_Parameter_Desc, @Item_Code, @Item_Item_Desc) SELECT Descriptions_Parameter_Desc, Item_Code, Item_Item_Desc FROM dbo.Parts_List DELETE FROM [dbo].[partsCode] WHERE (([part_id] = @Original_part_id) AND ([standardpack] = @Original_standardpack) AND ((@IsNull_lastupdated = 1 AND [lastupdated] IS NULL) OR ([lastupdated] = @Original_lastupdated))) INSERT INTO [dbo].[partsCode] ([partcode], [partname], [standardpack], [model], [additional], [factory], [lastupdated], [lastupdatedby]) VALUES (@partcode, @partname, @standardpack, @model, @additional, @factory, @lastupdated, @lastupdatedby); SELECT part_id, partcode, partname, standardpack, model, additional, factory, lastupdated, lastupdatedby FROM partsCode WHERE (part_id = SCOPE_IDENTITY()) SELECT part_id, partcode, partname, standardpack, model, additional, factory, lastupdated, lastupdatedby FROM dbo.partsCode UPDATE [dbo].[partsCode] SET [partcode] = @partcode, [partname] = @partname, [standardpack] = @standardpack, [model] = @model, [additional] = @additional, [factory] = @factory, [lastupdated] = @lastupdated, [lastupdatedby] = @lastupdatedby WHERE (([part_id] = @Original_part_id) AND ([standardpack] = @Original_standardpack) AND ((@IsNull_lastupdated = 1 AND [lastupdated] IS NULL) OR ([lastupdated] = @Original_lastupdated))); SELECT part_id, partcode, partname, standardpack, model, additional, factory, lastupdated, lastupdatedby FROM partsCode WHERE (part_id = @part_id) DELETE FROM [dbo].[PartsModel] WHERE (([ModelCode] = @Original_ModelCode) AND ([ControlID] = @Original_ControlID)) INSERT INTO [dbo].[PartsModel] ([Account], [ModelCode], [Description]) VALUES (@Account, @ModelCode, @Description); SELECT Account, ModelCode, Description, ControlID FROM PartsModel WHERE (ControlID = SCOPE_IDENTITY()) SELECT Account, ModelCode, Description, ControlID FROM dbo.PartsModel UPDATE [dbo].[PartsModel] SET [Account] = @Account, [ModelCode] = @ModelCode, [Description] = @Description WHERE (([ModelCode] = @Original_ModelCode) AND ([ControlID] = @Original_ControlID)); SELECT Account, ModelCode, Description, ControlID FROM PartsModel WHERE (ControlID = @ControlID) DELETE FROM [dbo].[PartsPrep] WHERE (([Control_ID] = @Original_Control_ID) AND ([Ionics_PN] = @Original_Ionics_PN) AND ([Epson_PN] = @Original_Epson_PN) AND ([Supplier_PN] = @Original_Supplier_PN) AND ([Rack] = @Original_Rack) AND ([Com_Type] = @Original_Com_Type)) INSERT INTO [dbo].[PartsPrep] ([Ionics_PN], [Epson_PN], [Supplier_PN], [Description], [Rack], [Com_Type], [ModelCode]) VALUES (@Ionics_PN, @Epson_PN, @Supplier_PN, @Description, @Rack, @Com_Type, @ModelCode); SELECT Control_ID, Ionics_PN, Epson_PN, Supplier_PN, Description, Rack, Com_Type, ModelCode FROM PartsPrep WHERE (Control_ID = SCOPE_IDENTITY()) SELECT Control_ID, Ionics_PN, Epson_PN, Supplier_PN, Description, Rack, Com_Type, ModelCode FROM dbo.PartsPrep UPDATE [dbo].[PartsPrep] SET [Ionics_PN] = @Ionics_PN, [Epson_PN] = @Epson_PN, [Supplier_PN] = @Supplier_PN, [Description] = @Description, [Rack] = @Rack, [Com_Type] = @Com_Type, [ModelCode] = @ModelCode WHERE (([Control_ID] = @Original_Control_ID) AND ([Ionics_PN] = @Original_Ionics_PN) AND ([Epson_PN] = @Original_Epson_PN) AND ([Supplier_PN] = @Original_Supplier_PN) AND ([Rack] = @Original_Rack) AND ([Com_Type] = @Original_Com_Type)); SELECT Control_ID, Ionics_PN, Epson_PN, Supplier_PN, Description, Rack, Com_Type, ModelCode FROM PartsPrep WHERE (Control_ID = @Control_ID) INSERT INTO [dbo].[PartsRecords] ([SerialNum], [IonicsPN], [EpsonPN], [SupplierPN], [Description], [LotNO], [Rack], [Qty], [Status], [EOH], [SPQ], [MFGDate], [RCVDate], [PrintedDate], [PrintedBy], [Returned], [Remarks], [ModelCode]) VALUES (@SerialNum, @IonicsPN, @EpsonPN, @SupplierPN, @Description, @LotNO, @Rack, @Qty, @Status, @EOH, @SPQ, @MFGDate, @RCVDate, @PrintedDate, @PrintedBy, @Returned, @Remarks, @ModelCode) SELECT SerialNum, IonicsPN, EpsonPN, SupplierPN, Description, LotNO, Rack, Qty, Status, EOH, SPQ, MFGDate, RCVDate, PrintedDate, PrintedBy, Returned, ControlID, Remarks, ModelCode FROM dbo.PartsRecords INSERT INTO [dbo].[partsStation] ([station_code], [supplier_id], [lastupdated], [lastupdatedby]) VALUES (@station_code, @supplier_id, @lastupdated, @lastupdatedby) SELECT station_id, station_code, supplier_id, lastupdated, lastupdatedby FROM dbo.partsStation INSERT INTO [dbo].[partsSupplier] ([supplier_name], [lastupdated], [lastupdatedby]) VALUES (@supplier_name, @lastupdated, @lastupdatedby) SELECT supplier_id, supplier_name, lastupdated, lastupdatedby FROM dbo.partsSupplier INSERT INTO [dbo].[po_detail] ([poNumber], [soNumber], [poDate], [poLine], [custPoLine], [soline], [alvsoline], [duedate], [custpartnumber], [parentpartnumber], [childpartnumber], [quantity], [custpart], [custpartno], [custpartdesc], [custgif], [targetDate], [flag2], [flag3], [remarks], [lineComments]) VALUES (@poNumber, @soNumber, @poDate, @poLine, @custPoLine, @soline, @alvsoline, @duedate, @custpartnumber, @parentpartnumber, @childpartnumber, @quantity, @custpart, @custpartno, @custpartdesc, @custgif, @targetDate, @flag2, @flag3, @remarks, @lineComments) SELECT poNumber, soNumber, poDate, poLine, custPoLine, soline, alvsoline, duedate, custpartnumber, parentpartnumber, childpartnumber, quantity, custpart, custpartno, custpartdesc, custgif, targetDate, flag2, flag3, remarks, lineComments FROM dbo.po_detail INSERT INTO [dbo].[po_detail_backup] ([Company], [CodeType], [TypHD], [ModeHD], [PONUmber], [SONumber], [PODate], [POLine], [CustPOLine], [SOLine], [DueDate], [CustPartNumber], [ParentPartNumber], [ChildPartNumber], [quantity], [ParentPrice], [s21Price], [UnitofMeasure], [TargetDate], [CustPart], [CustPartDesc], [CustGif], [Flag], [Flag1], [Flag2], [Flag3], [Remarks], [Field1], [Field2], [Field3], [LineComments], [DateCreated], [TimeCreated], [UserID], [DateLastChanged]) VALUES (@Company, @CodeType, @TypHD, @ModeHD, @PONUmber, @SONumber, @PODate, @POLine, @CustPOLine, @SOLine, @DueDate, @CustPartNumber, @ParentPartNumber, @ChildPartNumber, @quantity, @ParentPrice, @s21Price, @UnitofMeasure, @TargetDate, @CustPart, @CustPartDesc, @CustGif, @Flag, @Flag1, @Flag2, @Flag3, @Remarks, @Field1, @Field2, @Field3, @LineComments, @DateCreated, @TimeCreated, @UserID, @DateLastChanged) SELECT Company, CodeType, TypHD, ModeHD, PONUmber, SONumber, PODate, POLine, CustPOLine, SOLine, DueDate, CustPartNumber, ParentPartNumber, ChildPartNumber, quantity, ParentPrice, s21Price, UnitofMeasure, TargetDate, CustPart, CustPartDesc, CustGif, Flag, Flag1, Flag2, Flag3, Remarks, Field1, Field2, Field3, LineComments, DateCreated, TimeCreated, UserID, DateLastChanged FROM dbo.po_detail_backup INSERT INTO [dbo].[po_detail_temp] ([Company], [CodeType], [TypHD], [ModeHD], [PONumber], [SONumber], [PODate], [POLine], [CustPOLine], [SOLine], [AlvSOLine], [DueDate], [CustPartNumber], [ParentPartNumber], [ChildPartNumber], [quantity], [ParentPrice], [s21Price], [UnitofMeasure], [TargetDate], [CustPart], [CustPartNo], [CustPartDesc], [CustGif], [Flag], [Flag1], [Flag2], [Flag3], [Remarks], [Field1], [Field2], [Field3], [LineComments], [DateCreated], [TimeCreated], [UserID], [DateLastChanged]) VALUES (@Company, @CodeType, @TypHD, @ModeHD, @PONumber, @SONumber, @PODate, @POLine, @CustPOLine, @SOLine, @AlvSOLine, @DueDate, @CustPartNumber, @ParentPartNumber, @ChildPartNumber, @quantity, @ParentPrice, @s21Price, @UnitofMeasure, @TargetDate, @CustPart, @CustPartNo, @CustPartDesc, @CustGif, @Flag, @Flag1, @Flag2, @Flag3, @Remarks, @Field1, @Field2, @Field3, @LineComments, @DateCreated, @TimeCreated, @UserID, @DateLastChanged) SELECT Company, CodeType, TypHD, ModeHD, PONumber, SONumber, PODate, POLine, CustPOLine, SOLine, AlvSOLine, DueDate, CustPartNumber, ParentPartNumber, ChildPartNumber, quantity, ParentPrice, s21Price, UnitofMeasure, TargetDate, CustPart, CustPartNo, CustPartDesc, CustGif, Flag, Flag1, Flag2, Flag3, Remarks, Field1, Field2, Field3, LineComments, DateCreated, TimeCreated, UserID, DateLastChanged FROM dbo.po_detail_temp INSERT INTO [dbo].[po_header] ([Company], [CodeType], [TypeHD], [ModeHD], [Prefix], [GenDate], [GenHour], [PONumber], [PONumberPrev], [SONumber], [PODate], [Revision], [Status], [AlvSO], [CustPO], [ShipVia], [ShipTo], [SipAdd1], [ShipAdd2], [ShipAdd3], [City], [State], [PostalCode], [CountryCode], [ShipToNum], [Flag0], [Flag1], [Flag2], [Flag3], [Remark], [Fild1], [Fild2], [Fild3], [Fild4], [Fild5], [Comments], [DateCreated], [TimeCreated], [UserID], [DateLastChanged]) VALUES (@Company, @CodeType, @TypeHD, @ModeHD, @Prefix, @GenDate, @GenHour, @PONumber, @PONumberPrev, @SONumber, @PODate, @Revision, @Status, @AlvSO, @CustPO, @ShipVia, @ShipTo, @SipAdd1, @ShipAdd2, @ShipAdd3, @City, @State, @PostalCode, @CountryCode, @ShipToNum, @Flag0, @Flag1, @Flag2, @Flag3, @Remark, @Fild1, @Fild2, @Fild3, @Fild4, @Fild5, @Comments, @DateCreated, @TimeCreated, @UserID, @DateLastChanged) SELECT Company, CodeType, TypeHD, ModeHD, Prefix, GenDate, GenHour, PONumber, PONumberPrev, SONumber, PODate, Revision, Status, AlvSO, CustPO, ShipVia, ShipTo, SipAdd1, ShipAdd2, ShipAdd3, City, State, PostalCode, CountryCode, ShipToNum, Flag0, Flag1, Flag2, Flag3, Remark, Fild1, Fild2, Fild3, Fild4, Fild5, Comments, DateCreated, TimeCreated, UserID, DateLastChanged FROM dbo.po_header INSERT INTO [dbo].[po_header_backup] ([Company], [CodeType], [TypeHD], [ModeHD], [Prefix], [GenDate], [GenHour], [PONumber], [SONumber], [PODate], [Revision], [Status], [CustPO], [ShipVia], [ShipTo], [SipAdd1], [ShipAdd2], [ShipAdd3], [City], [State], [PostalCode], [CountryCode], [Flag0], [Flag1], [Flag2], [Flag3], [Remark], [Fild1], [Fild2], [Fild3], [Comments], [DateCreated], [TimeCreated], [UserID], [DateLastChanged]) VALUES (@Company, @CodeType, @TypeHD, @ModeHD, @Prefix, @GenDate, @GenHour, @PONumber, @SONumber, @PODate, @Revision, @Status, @CustPO, @ShipVia, @ShipTo, @SipAdd1, @ShipAdd2, @ShipAdd3, @City, @State, @PostalCode, @CountryCode, @Flag0, @Flag1, @Flag2, @Flag3, @Remark, @Fild1, @Fild2, @Fild3, @Comments, @DateCreated, @TimeCreated, @UserID, @DateLastChanged) SELECT Company, CodeType, TypeHD, ModeHD, Prefix, GenDate, GenHour, PONumber, SONumber, PODate, Revision, Status, CustPO, ShipVia, ShipTo, SipAdd1, ShipAdd2, ShipAdd3, City, State, PostalCode, CountryCode, Flag0, Flag1, Flag2, Flag3, Remark, Fild1, Fild2, Fild3, Comments, DateCreated, TimeCreated, UserID, DateLastChanged FROM dbo.po_header_backup INSERT INTO [dbo].[po_history_detail] ([poNumber], [revision], [chg_type], [poLine], [change], [from_value], [to_value], [lastupdate], [content]) VALUES (@poNumber, @revision, @chg_type, @poLine, @change, @from_value, @to_value, @lastupdate, @content) SELECT poNumber, revision, chg_type, poLine, change, from_value, to_value, lastupdate, content FROM dbo.po_history_detail INSERT INTO [dbo].[po_orig_detail] ([poNumber], [poLine], [soLine], [targetDate], [lineComments], [custPartNumber], [quantity], [unitPrice], [custPartNo], [dueDate], [custPart], [custPartGif], [custPartDesc]) VALUES (@poNumber, @poLine, @soLine, @targetDate, @lineComments, @custPartNumber, @quantity, @unitPrice, @custPartNo, @dueDate, @custPart, @custPartGif, @custPartDesc) SELECT poNumber, poLine, soLine, targetDate, lineComments, custPartNumber, quantity, unitPrice, custPartNo, dueDate, custPart, custPartGif, custPartDesc FROM dbo.po_orig_detail INSERT INTO [dbo].[po_orig_header] ([poNumber], [poDate], [poRev], [comments], [status], [custPo], [alvSo], [shipVia], [shipTo], [shipAdd1], [shipAdd2], [shipAdd3], [shipToNum], [city], [state], [postalCode], [countryCode], [insertDate], [content]) VALUES (@poNumber, @poDate, @poRev, @comments, @status, @custPo, @alvSo, @shipVia, @shipTo, @shipAdd1, @shipAdd2, @shipAdd3, @shipToNum, @city, @state, @postalCode, @countryCode, @insertDate, @content) SELECT poNumber, poDate, poRev, comments, status, custPo, alvSo, shipVia, shipTo, shipAdd1, shipAdd2, shipAdd3, shipToNum, city, state, postalCode, countryCode, insertDate, content FROM dbo.po_orig_header INSERT INTO [dbo].[printer] ([printerName]) VALUES (@printerName) SELECT printerName FROM dbo.printer DELETE FROM [dbo].[pt] WHERE (([ptID] = @Original_ptID) AND ((@IsNull_batchNo = 1 AND [batchNo] IS NULL) OR ([batchNo] = @Original_batchNo)) AND ((@IsNull_ptNo = 1 AND [ptNo] IS NULL) OR ([ptNo] = @Original_ptNo)) AND ((@IsNull_partNo = 1 AND [partNo] IS NULL) OR ([partNo] = @Original_partNo)) AND ((@IsNull_curtstage = 1 AND [curtstage] IS NULL) OR ([curtstage] = @Original_curtstage)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_ptParent = 1 AND [ptParent] IS NULL) OR ([ptParent] = @Original_ptParent)) AND ((@IsNull_ptStart = 1 AND [ptStart] IS NULL) OR ([ptStart] = @Original_ptStart)) AND ((@IsNull_prefix = 1 AND [prefix] IS NULL) OR ([prefix] = @Original_prefix)) AND ((@IsNull_suffix = 1 AND [suffix] IS NULL) OR ([suffix] = @Original_suffix)) AND ((@IsNull_origQuantity = 1 AND [origQuantity] IS NULL) OR ([origQuantity] = @Original_origQuantity)) AND ((@IsNull_currQuantity = 1 AND [currQuantity] IS NULL) OR ([currQuantity] = @Original_currQuantity)) AND ((@IsNull_startTime = 1 AND [startTime] IS NULL) OR ([startTime] = @Original_startTime)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[pt] ([batchNo], [ptNo], [partNo], [curtstage], [status], [ptParent], [ptStart], [prefix], [suffix], [origQuantity], [currQuantity], [startTime], [lastupdate], [lastupdatedby]) VALUES (@batchNo, @ptNo, @partNo, @curtstage, @status, @ptParent, @ptStart, @prefix, @suffix, @origQuantity, @currQuantity, @startTime, @lastupdate, @lastupdatedby); SELECT ptID, batchNo, ptNo, partNo, curtstage, status, ptParent, ptStart, prefix, suffix, origQuantity, currQuantity, startTime, lastupdate, lastupdatedby FROM pt WHERE (ptID = SCOPE_IDENTITY()) SELECT ptID, batchNo, ptNo, partNo, curtstage, status, ptParent, ptStart, prefix, suffix, origQuantity, currQuantity, startTime, lastupdate, lastupdatedby FROM dbo.pt UPDATE [dbo].[pt] SET [batchNo] = @batchNo, [ptNo] = @ptNo, [partNo] = @partNo, [curtstage] = @curtstage, [status] = @status, [ptParent] = @ptParent, [ptStart] = @ptStart, [prefix] = @prefix, [suffix] = @suffix, [origQuantity] = @origQuantity, [currQuantity] = @currQuantity, [startTime] = @startTime, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([ptID] = @Original_ptID) AND ((@IsNull_batchNo = 1 AND [batchNo] IS NULL) OR ([batchNo] = @Original_batchNo)) AND ((@IsNull_ptNo = 1 AND [ptNo] IS NULL) OR ([ptNo] = @Original_ptNo)) AND ((@IsNull_partNo = 1 AND [partNo] IS NULL) OR ([partNo] = @Original_partNo)) AND ((@IsNull_curtstage = 1 AND [curtstage] IS NULL) OR ([curtstage] = @Original_curtstage)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_ptParent = 1 AND [ptParent] IS NULL) OR ([ptParent] = @Original_ptParent)) AND ((@IsNull_ptStart = 1 AND [ptStart] IS NULL) OR ([ptStart] = @Original_ptStart)) AND ((@IsNull_prefix = 1 AND [prefix] IS NULL) OR ([prefix] = @Original_prefix)) AND ((@IsNull_suffix = 1 AND [suffix] IS NULL) OR ([suffix] = @Original_suffix)) AND ((@IsNull_origQuantity = 1 AND [origQuantity] IS NULL) OR ([origQuantity] = @Original_origQuantity)) AND ((@IsNull_currQuantity = 1 AND [currQuantity] IS NULL) OR ([currQuantity] = @Original_currQuantity)) AND ((@IsNull_startTime = 1 AND [startTime] IS NULL) OR ([startTime] = @Original_startTime)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT ptID, batchNo, ptNo, partNo, curtstage, status, ptParent, ptStart, prefix, suffix, origQuantity, currQuantity, startTime, lastupdate, lastupdatedby FROM pt WHERE (ptID = @ptID) INSERT INTO [dbo].[pt_Hist] ([batchNo], [ptNo], [partNo], [curtstage], [status], [ptParent], [ptStart], [prefix], [suffix], [origQuantity], [currQuantity], [startTime], [lastupdate], [lastupdatedby]) VALUES (@batchNo, @ptNo, @partNo, @curtstage, @status, @ptParent, @ptStart, @prefix, @suffix, @origQuantity, @currQuantity, @startTime, @lastupdate, @lastupdatedby) SELECT ptID, batchNo, ptNo, partNo, curtstage, status, ptParent, ptStart, prefix, suffix, origQuantity, currQuantity, startTime, lastupdate, lastupdatedby FROM dbo.pt_Hist DELETE FROM [dbo].[serialAlvariset] WHERE (([cardno] = @Original_cardno) AND ((@IsNull_mpPartno = 1 AND [mpPartno] IS NULL) OR ([mpPartno] = @Original_mpPartno)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[serialAlvariset] ([cardno], [mpPartno], [lastupdate], [lastupdatedby]) VALUES (@cardno, @mpPartno, @lastupdate, @lastupdatedby); SELECT cardno, mpPartno, lastupdate, lastupdatedby FROM serialAlvariset WHERE (cardno = @cardno) SELECT cardno, mpPartno, lastupdate, lastupdatedby FROM dbo.serialAlvariset UPDATE [dbo].[serialAlvariset] SET [cardno] = @cardno, [mpPartno] = @mpPartno, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([cardno] = @Original_cardno) AND ((@IsNull_mpPartno = 1 AND [mpPartno] IS NULL) OR ([mpPartno] = @Original_mpPartno)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT cardno, mpPartno, lastupdate, lastupdatedby FROM serialAlvariset WHERE (cardno = @cardno) DELETE FROM [dbo].[serialMac] WHERE (([cardno] = @Original_cardno) AND ((@IsNull_macaddress = 1 AND [macaddress] IS NULL) OR ([macaddress] = @Original_macaddress)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[serialMac] ([cardno], [macaddress], [lastupdate], [lastupdatedby]) VALUES (@cardno, @macaddress, @lastupdate, @lastupdatedby); SELECT cardno, macaddress, lastupdate, lastupdatedby FROM serialMac WHERE (cardno = @cardno) SELECT cardno, macaddress, lastupdate, lastupdatedby FROM dbo.serialMac UPDATE [dbo].[serialMac] SET [cardno] = @cardno, [macaddress] = @macaddress, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([cardno] = @Original_cardno) AND ((@IsNull_macaddress = 1 AND [macaddress] IS NULL) OR ([macaddress] = @Original_macaddress)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT cardno, macaddress, lastupdate, lastupdatedby FROM serialMac WHERE (cardno = @cardno) INSERT INTO [dbo].[SHIPPER_REPORT_TABLE] ([cnNo], [shipno], [shipDate], [shipto], [sipAdd1], [shipAdd2], [shipAdd3], [ZIP], [countryCode], [Phone], [shipVia], [POLine], [modelDesc1], [CustPO], [AlvSO], [AlvSOLine], [Flag3], [model], [custPart], [SNQty], [serialno], [layer], [dimension]) VALUES (@cnNo, @shipno, @shipDate, @shipto, @sipAdd1, @shipAdd2, @shipAdd3, @ZIP, @countryCode, @Phone, @shipVia, @POLine, @modelDesc1, @CustPO, @AlvSO, @AlvSOLine, @Flag3, @model, @custPart, @SNQty, @serialno, @layer, @dimension) SELECT cnNo, shipno, shipDate, shipto, sipAdd1, shipAdd2, shipAdd3, ZIP, countryCode, Phone, shipVia, POLine, modelDesc1, CustPO, AlvSO, AlvSOLine, Flag3, model, custPart, SNQty, serialno, layer, dimension FROM dbo.SHIPPER_REPORT_TABLE INSERT INTO [dbo].[SHIPPER_STATUS] ([Shipno], [Process], [Result], [Remarks], [UPDTime]) VALUES (@Shipno, @Process, @Result, @Remarks, @UPDTime) SELECT Shipno, Process, Result, Remarks, UPDTime FROM dbo.SHIPPER_STATUS INSERT INTO [dbo].[SHIPPER_SUMMARY_TABLE] ([cnNo], [shipno], [shipDate], [shipto], [sipAdd1], [shipAdd2], [shipAdd3], [ZIP], [countryCode], [Phone], [shipVia], [POLine], [modelDesc1], [CustPO], [AlvSO], [AlvSOLine], [Flag3], [model], [CustPart], [SNQty], [serialno], [layer], [dimension]) VALUES (@cnNo, @shipno, @shipDate, @shipto, @sipAdd1, @shipAdd2, @shipAdd3, @ZIP, @countryCode, @Phone, @shipVia, @POLine, @modelDesc1, @CustPO, @AlvSO, @AlvSOLine, @Flag3, @model, @CustPart, @SNQty, @serialno, @layer, @dimension) SELECT cnNo, shipno, shipDate, shipto, sipAdd1, shipAdd2, shipAdd3, ZIP, countryCode, Phone, shipVia, POLine, modelDesc1, CustPO, AlvSO, AlvSOLine, Flag3, model, CustPart, SNQty, serialno, layer, dimension FROM dbo.SHIPPER_SUMMARY_TABLE DELETE FROM [dbo].[station] WHERE (([station] = @Original_station) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_sequence = 1 AND [sequence] IS NULL) OR ([sequence] = @Original_sequence)) AND ((@IsNull_stype = 1 AND [stype] IS NULL) OR ([stype] = @Original_stype)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[station] ([station], [description], [sequence], [stype], [active], [lastupdate], [lastupdatedby]) VALUES (@station, @description, @sequence, @stype, @active, @lastupdate, @lastupdatedby); SELECT station, description, sequence, stype, active, lastupdate, lastupdatedby FROM station WHERE (station = @station) SELECT station, description, sequence, stype, active, lastupdate, lastupdatedby FROM dbo.station UPDATE [dbo].[station] SET [station] = @station, [description] = @description, [sequence] = @sequence, [stype] = @stype, [active] = @active, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([station] = @Original_station) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_sequence = 1 AND [sequence] IS NULL) OR ([sequence] = @Original_sequence)) AND ((@IsNull_stype = 1 AND [stype] IS NULL) OR ([stype] = @Original_stype)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT station, description, sequence, stype, active, lastupdate, lastupdatedby FROM station WHERE (station = @station) INSERT INTO [dbo].[station_convert] ([ioStation], [alvStation]) VALUES (@ioStation, @alvStation) SELECT ioStation, alvStation FROM dbo.station_convert DELETE FROM [dbo].[stationHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_station = 1 AND [station] IS NULL) OR ([station] = @Original_station)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_sequence = 1 AND [sequence] IS NULL) OR ([sequence] = @Original_sequence)) AND ((@IsNull_stype = 1 AND [stype] IS NULL) OR ([stype] = @Original_stype)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))) INSERT INTO [dbo].[stationHist] ([station], [description], [sequence], [stype], [active], [status], [lastupdate], [lastupdatedby]) VALUES (@station, @description, @sequence, @stype, @active, @status, @lastupdate, @lastupdatedby); SELECT lineNum, station, description, sequence, stype, active, status, lastupdate, lastupdatedby FROM stationHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, station, description, sequence, stype, active, status, lastupdate, lastupdatedby FROM dbo.stationHist UPDATE [dbo].[stationHist] SET [station] = @station, [description] = @description, [sequence] = @sequence, [stype] = @stype, [active] = @active, [status] = @status, [lastupdate] = @lastupdate, [lastupdatedby] = @lastupdatedby WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_station = 1 AND [station] IS NULL) OR ([station] = @Original_station)) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_sequence = 1 AND [sequence] IS NULL) OR ([sequence] = @Original_sequence)) AND ((@IsNull_stype = 1 AND [stype] IS NULL) OR ([stype] = @Original_stype)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_lastupdate = 1 AND [lastupdate] IS NULL) OR ([lastupdate] = @Original_lastupdate)) AND ((@IsNull_lastupdatedby = 1 AND [lastupdatedby] IS NULL) OR ([lastupdatedby] = @Original_lastupdatedby))); SELECT lineNum, station, description, sequence, stype, active, status, lastupdate, lastupdatedby FROM stationHist WHERE (lineNum = @lineNum) DELETE FROM [dbo].[users] WHERE (([username] = @Original_username) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_employeeCode = 1 AND [employeeCode] IS NULL) OR ([employeeCode] = @Original_employeeCode)) AND ((@IsNull_dateJoined = 1 AND [dateJoined] IS NULL) OR ([dateJoined] = @Original_dateJoined)) AND ((@IsNull_authentication = 1 AND [authentication] IS NULL) OR ([authentication] = @Original_authentication)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active))) INSERT INTO [dbo].[users] ([username], [password], [employeeCode], [dateJoined], [authentication], [active]) VALUES (@username, @password, @employeeCode, @dateJoined, @authentication, @active); SELECT username, password, employeeCode, dateJoined, authentication, active FROM users WHERE (username = @username) SELECT username, password, employeeCode, dateJoined, authentication, active FROM dbo.users UPDATE [dbo].[users] SET [username] = @username, [password] = @password, [employeeCode] = @employeeCode, [dateJoined] = @dateJoined, [authentication] = @authentication, [active] = @active WHERE (([username] = @Original_username) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_employeeCode = 1 AND [employeeCode] IS NULL) OR ([employeeCode] = @Original_employeeCode)) AND ((@IsNull_dateJoined = 1 AND [dateJoined] IS NULL) OR ([dateJoined] = @Original_dateJoined)) AND ((@IsNull_authentication = 1 AND [authentication] IS NULL) OR ([authentication] = @Original_authentication)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active))); SELECT username, password, employeeCode, dateJoined, authentication, active FROM users WHERE (username = @username) DELETE FROM [dbo].[usersHist] WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_username = 1 AND [username] IS NULL) OR ([username] = @Original_username)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_employeeCode = 1 AND [employeeCode] IS NULL) OR ([employeeCode] = @Original_employeeCode)) AND ((@IsNull_dateJoined = 1 AND [dateJoined] IS NULL) OR ([dateJoined] = @Original_dateJoined)) AND ((@IsNull_authentication = 1 AND [authentication] IS NULL) OR ([authentication] = @Original_authentication)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active))) INSERT INTO [dbo].[usersHist] ([username], [password], [employeeCode], [dateJoined], [authentication], [active]) VALUES (@username, @password, @employeeCode, @dateJoined, @authentication, @active); SELECT lineNum, username, password, employeeCode, dateJoined, authentication, active FROM usersHist WHERE (lineNum = SCOPE_IDENTITY()) SELECT lineNum, username, password, employeeCode, dateJoined, authentication, active FROM dbo.usersHist UPDATE [dbo].[usersHist] SET [username] = @username, [password] = @password, [employeeCode] = @employeeCode, [dateJoined] = @dateJoined, [authentication] = @authentication, [active] = @active WHERE (([lineNum] = @Original_lineNum) AND ((@IsNull_username = 1 AND [username] IS NULL) OR ([username] = @Original_username)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_employeeCode = 1 AND [employeeCode] IS NULL) OR ([employeeCode] = @Original_employeeCode)) AND ((@IsNull_dateJoined = 1 AND [dateJoined] IS NULL) OR ([dateJoined] = @Original_dateJoined)) AND ((@IsNull_authentication = 1 AND [authentication] IS NULL) OR ([authentication] = @Original_authentication)) AND ((@IsNull_active = 1 AND [active] IS NULL) OR ([active] = @Original_active))); SELECT lineNum, username, password, employeeCode, dateJoined, authentication, active FROM usersHist WHERE (lineNum = @lineNum) INSERT INTO [dbo].[WIP_TEMP] ([modelno], [station], [previous], [description], [WIP], [date]) VALUES (@modelno, @station, @previous, @description, @WIP, @date) SELECT modelno, station, previous, description, WIP, date FROM dbo.WIP_TEMP SELECT ModuleAndFeeder, PartNo, Lot, Location, DateAndTimeMounted, Operator FROM dbo.[CTSB9-00001] SELECT ModuleAndFeeder, PartNo, Lot, Location, DateAndTimeMounted, Operator FROM dbo.[CTSB9-00002] SELECT serialno, lastupdate FROM dbo.getMaxDate SELECT serialno, lastupdate FROM dbo.getMinDate SELECT shipno, shipDate, shipVia, shipto, sipAdd1, shipAdd2, shipAdd3, city, state, postalCode, countryCode, cnNo, layer, dimension, serialno, poLine, model FROM dbo.Shipper_File SELECT POLine, modelDesc1, CustPO, Flag3, model, CustPart, serialno FROM dbo.Shipper_File_Body SELECT shipno, shipDate, shipVia, shipto, sipAdd1, shipAdd2, shipAdd3, ZIP, countryCode, cnNo, layer, dimension, poLine, model FROM dbo.Shipper_File_Header dbo.container dbo.createView dbo.item dbo.PO dbo.POLINE dbo.shipAdd1 dbo.shipAdd2 dbo.shipAdd3 dbo.validatePOTransfer dbo.AeroMacEnd_Procedure dbo.AeroMacRange dbo.AeroMacStart_Procedure dbo.AeroModel_Procedure dbo.ARS_FAR dbo.ARS_WIP dbo.batchYield dbo.buybackPOLine dbo.CancelledShipper dbo.DorinaWIP dbo.FPY dbo.FTY dbo.packingInfo dbo.po_update dbo.prodOutput dbo.prodOutputDorina dbo.repairDetails dbo.repairDetailsPerDate dbo.SHIPPER_REPORT dbo.SHIPPER_SUMMARY dbo.transferPOLine dbo.unpackPO dbo.unpackPOLine dbo.WIP dbo.WIPperFamily dbo.yield dbo.getDANumber