Flusso: aggiunta serial number nel route in Loading

Select di scrittura coinvolte aggiungendo il prodotto MTETGS
REP06_DELIVERY_NOTES_DETAILS

"INSERT INTO REP06_DELIVERY_NOTES_DETAILS(UI_DELIVERY_NOTE,CD_MOVEMENT_TYPE,CD_VISIT_TYPE,CD_MOVEMENT_CAUSE,ID_MASTERCODE,CD_MASTERCODE,DS_MASTERCODE,ID_SUBCODE,CD_SUBCODE,DS_SUBCODE,TX_ADR_DESCRIPTION,ID_TREATMENT,IS_IHS,CD_PLANNED_CAPACITY,CD_AIC,FL_QUANTITY,CD_UM,FL_SALE_QTY,CD_UM_SALE,FL_PRINTED_QTY,CD_PRINTED_UM,CD_ITEM_BATCH,CD_KIT_BARCODE,CD_PALLET,CD_VAR1,CD_VAR2,CD_VAR3,CD_VAR4,CD_VAR5,UI_SERIAL_NUMBER,CD_SN_BARCODE,CD_PRODUCER,TX_PRODUCER_NAME,TX_PRODUCER_SN,ID_CONTENT,CD_CONTENT,DS_CONTENT,CD_CONTENT_BATCH,FL_CAPACITY_VALUE,TX_PARAMETERS,UI_ROUTE,ID_CENTER_SRC,CD_CENTER_CODE_SRC,CD_LOC_TYPE_SRC,ID_LOCATION_SRC,ID_WAREHOUSE_SRC,CD_WAREHOUSE_SRC,DS_WAREHOUSE_SRC,DS_ALT_WAREHOUSE_SRC,ID_WH_OWNER,ID_PRINTED_WH,CD_PRINTED_WH,DS_PRINTED_WH,DS_ALT_PRINTED_WH,ID_EN_OWNER,TX_OWNER_NAME,FL_VAT_PERC,IF_MOVEMENT_MODE,UI_REF_ORDER,TX_REF_ORDER,NR_REF_ORDER_ROW,UI_REF_PURCHASE_ORDER,TX_REF_PURCHASE_ORDER,DT_REF_PURCHASE_ORDER,NR_REF_PURCHASE_ORDER_ROW,IS_TO_INVOICE,ID_CONTRACT,ID_ERP_CONTRACT,CD_ERP_CONTRACT,TX_REF_DOC,CD_PROVISION,CD_ERP_PROVISION_CODE,CD_ERP_TREATMENT_CODE,CD_INVOICE_PRIORITY,CD_FISCAL_CATEGORY,ID_EN_REFERENCE,FL_PRICE,CD_CURRENCY,FL_DISCOUNT,FL_SALE_PRICE,TX_NOTE,ID_US_INSERT,DT_INSERT,ID_US_UPDATE,DT_UPDATE,UI_SYNC,CD_FISCAL_NATURE,CD_LOC_STATUS,CD_FINAL_FISCAL_NATURE,CD_AREA_SRC,ID_PALLET_TYPE,UI_REF_PRICE,ID_SUBCODE_AIC,CD_SUBCODE_AIC,DS_SUBCODE_AIC,TX_REF_TENDER,TX_REF_PROJECT,CD_SN_LIST,UI_PRESCRIPTION,CD_LOC_STATUS_BEFORE,IS_STATUS_CHANGE,UI_BACK_ORDER,TX_BACK_ORDER,NR_BACK_ORDER_ROW) VALUES (NULL,'LOA',NULL,NULL,12507,'X26387','POMPA COMPACT',212507,'26387','POMPA COMPACT',NULL,NULL,0,NULL,NULL,1,'Nr',1,'Nr',1,'Nr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,x'05F6D6A81B5EC6456E84002B3566D143','MTETGS','P_NESTLE','NESTLE','269347',NULL,NULL,NULL,NULL,NULL,NULL,x'AC74B597246DEC4DBD9C25C469ABDA31',2080,'V80','W',3093,3093,'0003','Mag. materiali Sesto',NULL,NULL,3093,'0003','Mag. materiali Sesto',NULL,263189,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3383,'2018-01-23 15:04:23.000',3383,'2018-01-23 15:04:23.000',x'A33A261D9A4D1C4B43629DED506A984C',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL)"

STO11---
"INSERT INTO STO11_MOVEMENTS_SN(CD_MOVEMENT_TYPE,CD_ITEM_TYPE,ID_ITEM,CD_ITEM_BATCH,CD_KIT_BARCODE,CD_PALLET,CD_SACK_BARCODE,UI_SERIAL_NUMBER,CD_SN_BARCODE,CD_RETURNED_BARCODE,ID_CENTER,CD_LOC_TYPE,ID_LOCATION,CD_AREA,ID_WH_OWNER,IS_NO_STOCK_UPDATE,TX_NOTE,CD_SN_STATUS,ID_CONTENT,CD_CONTENT_BATCH,FL_CONTENT_QTY,IS_FINAL_CONTENT_QTY,CD_UM_CONTENT,ID_CENTER_SRC,CD_LOC_TYPE_SRC,ID_LOCATION_SRC,CD_AREA_SRC,ID_CONTENT_SRC,CD_ORIGIN_TYPE,ID_ORIGIN,CD_PLANT_TYPE,DT_MOVEMENT,CD_PDA,IF_MOVEMENT_MODE,UI_REF_ORDER,NR_REF_ORDER_ROW,DT_REF_DN,TX_REF_DN,UI_DELIVERY_NOTE,IF_ERP_SENT,ID_US_INSERT,DT_INSERT,ID_US_UPDATE,DT_UPDATE,UI_SYNC,CD_ADX_CAUSE,UI_POUR_SN,CD_LOC_STATUS,CD_PLANT_CODE,FL_WRITTEN_OFF_QTY,IS_WRITTEN_OFF,ID_PALLET_TYPE,IS_IN_PLANT,ID_TREATMENT,UI_INTERVENTION_RET,FL_FULL_WEIGHT,ID_ADDRESS) VALUES ('LOA','PRO',12507,NULL,NULL,NULL,NULL,x'05F6D6A81B5EC6456E84002B3566D143','MTETGS',NULL,2080,'L',3383,NULL,NULL,0,NULL,'O',NULL,NULL,NULL,1,NULL,2080,'W',3093,NULL,NULL,NULL,NULL,NULL,'2018-01-23 15:05:53.000','1185AA60',NULL,NULL,NULL,NULL,NULL,NULL,0,3383,'2018-01-23 15:05:53.000',3383,'2018-01-23 15:05:53.000',x'101CFAD8C0A477466DAD3DAAB818E453',NULL,NULL,'N',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL)"

PLA06_ROUTING_OPERATIONS

"INSERT INTO PLA06_ROUTING_OPERATIONS(UI_ROUTE,CD_OPERATION,DT_OPERATION,UI_POSITION,ID_US_INSERT,DT_INSERT,ID_US_UPDATE,DT_UPDATE,UI_SYNC,CD_CAUSE,TX_NOTE) VALUES (x'AC74B597246DEC4DBD9C25C469ABDA31','NORMAL_LOAD','2018-01-23 15:06:38.000',NULL,3383,'2018-01-23 15:06:38.000',3383,'2018-01-23 15:06:38.000',x'E8279C771644A448739DADEDAD490B91',NULL,NULL)"