
            with RCS as (
                select RegistryCheckStatus_id
                from v_RegistryCheckStatus
                where RegistryCheckStatus_Code = 1
                limit 1
            )
            update r38.Registry
            set
                RegistryCheckStatus_id = (select RegistryCheckStatus_id from RCS),
                Registry_updDT = localtimestamp,
                pmUser_updID = 1
            where
                Registry_id in ('380101000013795','380101000014472','380101000014956','380101000014956','380101000014956','380101000014956','380101000011300','380101000013562','380101000013688','380101000013720','380101000013734','380101000013748','380101000013764','380101000013781','380101000013782','380101000013784','380101000013595','380101000013634','380101000013881','380101000013889','380101000014134','380101000014440','380101000014542','380101000014802','380101000013772','380101000013793','380101000013791','380101000013792','380101000013565','380101000013596','380101000013636','380101000013882','380101000014135','380101000014441','380101000014803','380101000013772','380101000013793','380101000013690','380101000013726','380101000013727','380101000013741','380101000013753','380101000013769','380101000013789','380101000013564','380101000013738','380101000013766','380101000013767','380101000013786','380101000013594','380101000013637','380101000013645','380101000013691','380101000013722','380101000013723','380101000013737','380101000013880','380101000013890','380101000014136','380101000014442','380101000014804','380101000013751','380101000013768','380101000013788','380101000001315','380101000014367','380101000011291','380101000011280','380101000011290','380101000011436','380101000013650','380101000014016','380101000014016','380101000014016','380101000014169','380101000014169','380101000014312','380101000014312','380101000014877','380101000013652','380101000014025','380101000014486','380101000013651','380101000013893','380101000013893','380101000014170','380101000014170','380101000014483','380101000013669','380101000014521','380101000013577','380101000013577','380101000013942','380101000014062','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014335','380101000014822','380101000014822','380101000014822','380101000014822','380101000014822','380101000014630','380101000014857','380101000013686','380101000013708','380101000013939','380101000013943','380101000014065','380101000014066','380101000014316','380101000014334','380101000014861','380101000013963','380101000014064','380101000014336','380101000014067','380101000013963','380101000014064','380101000014068','380101000014069','380101000013940','380101000014063','380101000014327','380101000014858','380101000000030','380101000000033','380101000001194','380101000001358','380101000001550','380101000013747','380101000013747','380101000014987','380101000000046','380101000014220','380101000014362','380101000000085','380101000001176','380101000013746','380101000013746','380101000013551','380101000013867','380101000001512','380101000000745','380101000001460','380101000000028','380101000000030','380101000000039','380101000000040','380101000014237','380101000014499','380101000011232','380101000011255','380101000011232','380101000011232','380101000011232','380101000011232','380101000011232','380101000011260','380101000011260','380101000011260','380101000011260','380101000011260','380101000011548','380101000011548','380101000011548','380101000011548','380101000011548','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000013865','380101000014114','380101000014114','380101000014114','380101000014114','380101000014114','380101000014114','380101000014345','380101000014345','380101000014345','380101000014345','380101000014345','380101000014345','380101000014345','380101000014784','380101000014784','380101000014784','380101000014784','380101000014094','380101000014269','380101000014799','380101000014983','380101000014523','380101000014523','380101000014523','380101000014523','380101000014523','380101000014523','380101000014523','380101000014523','380101000014766','380101000014766','380101000014766','380101000014766','380101000014526','380101000014798','380101000014983','380101000014408','380101000014837','380101000011235','380101000011257','380101000011259','380101000011434','380101000011547','380101000013543','380101000013812','380101000013885','380101000014113','380101000014344','380101000014811','380101000014355','380101000014356','380101000014896','380101000014602','380101000014624','380101000014898','380101000014352','380101000014221','380101000014178','380101000014132','380101000014159','380101000014167','380101000014180','380101000014160','380101000014179','380101000014306','380101000014307','380101000011446','380101000013763','380101000013730','380101000013763','380101000013649','380101000014061','380101000013830','380101000013830','380101000014061','380101000014061','380101000014061','380101000014061','380101000013830','380101000013830','380101000013830','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014109','380101000014424','380101000014424','380101000014424','380101000014424','380101000014424','380101000014424','380101000014424','380101000014424','380101000014424','380101000014878','380101000014878','380101000014878','380101000014878','380101000014878','380101000014833','380101000014831','380101000014559','380101000014559','380101000014559','380101000014559','380101000014559','380101000014559','380101000014879','380101000014879','380101000014879','380101000014879','380101000014879','380101000014879','380101000014831','380101000014929','380101000011310','380101000014601','380101000014224','380101000014600','380101000014425','380101000014880','380101000014601','380101000014690','380101000014782','380101000014764','380101000014783','380101000001352','380101000001483','380101000011198','380101000013544','380101000013800','380101000013853','380101000014110','380101000014314','380101000014850','380101000011266','380101000014241','380101000014241','380101000014458','380101000014458','380101000014458','380101000014458','380101000015015','380101000001420','380101000013640','380101000013656','380101000014037','380101000014038','380101000014514','380101000014961','380101000014515','380101000014962','380101000014631','380101000014836','380101000014836','380101000014836','380101000014633','380101000014801','380101000014594','380101000014652','380101000014685','380101000014841','380101000013867','380101000014613','380101000014613','380101000014835','380101000014835','380101000014685','380101000014841','380101000014642','380101000014842','380101000014838','380101000001475','380101000001552','380101000014387','380101000001555','380101000014389','380101000014826','380101000014390','380101000014468','380101000014826','380101000014374','380101000001381','380101000014455','380101000013558','380101000012319','380101000014203','380101000014208','380101000014209','380101000014668','380101000014207','380101000013879','380101000014210','380101000014176','380101000014211','380101000014206','380101000014205','380101000014174','380101000013581','380101000014364','380101000014623','380101000001406','380101000001407','380101000014560','380101000014560','380101000015012','380101000015007','380101000015010','380101000014193','380101000014672','380101000014342','380101000014924','380101000014924','380101000014924','380101000014924','380101000011311','380101000014586','380101000014673','380101000014926','380101000013545','380101000013546','380101000013687','380101000013876','380101000014194','380101000014439','380101000014925','380101000014925','380101000013775','380101000014212','380101000014555','380101000015006','380101000014168','380101000014994','380101000011191','380101000001448','380101000001449','380101000001451','380101000013663','380101000014265','380101000014383','380101000014456','380101000014534','380101000014832','380101000014590','380101000014590','380101000014590','380101000014874','380101000014874','380101000001528','380101000014945','380101000001409','380101000001447','380101000001498','380101000001566','380101000001576','380101000001597','380101000011293','380101000011514','380101000011539','380101000013888','380101000014107','380101000014376','380101000015002','380101000001566','380101000011514','380101000013575','380101000014544','380101000015020','380101000014409','380101000005881','380101000014139','380101000001466','380101000001539','380101000001345','380101000001416','380101000001416','380101000001540','380101000013670','380101000013797','380101000013835','380101000014033','380101000014533','380101000013836','380101000014036','380101000014508','380101000014612','380101000014522','380101000014522','380101000014582','380101000013573','380101000014510','380101000014518','380101000014509','380101000014525','380101000001399','380101000014246','380101000014246','380101000014795','380101000014795','380101000014795','380101000014795','380101000014795','380101000014795','380101000014795','380101000014796','380101000014796','380101000014796','380101000001349','380101000013671','380101000014264','380101000014819','380101000014271','380101000014816','380101000014261','380101000014261','380101000014817','380101000014817','380101000014817','380101000014817','380101000014817','380101000014817','380101000014259','380101000014818','380101000014271','380101000014816','380101000014262','380101000014821','380101000014255','380101000014812','380101000014257','380101000014754','380101000014750','380101000011287','380101000013804','380101000013678','380101000013860','380101000013871','380101000013948','380101000014026','380101000014105','380101000014275','380101000014771','380101000014714','380101000015017','380101000014273','380101000014775','380101000014913','380101000014776','380101000013808','380101000013809','380101000013610','380101000013841','380101000014070','380101000014319','380101000013659','380101000014485','380101000014810','380101000014443','380101000014900','380101000011421','380101000014453','380101000014478','380101000014489','380101000014550','380101000014552','380101000014653','380101000014654','380101000014655','380101000014662','380101000014706','380101000014707','380101000014708','380101000014736','380101000014737','380101000014738','380101000014755','380101000014758','380101000014759','380101000014763','380101000014774','380101000014451','380101000014903','380101000014946','380101000014947','380101000014949','380101000014852','380101000014853','380101000014854','380101000014855','380101000014866','380101000014912','380101000014948','380101000014950','380101000014951','380101000013695','380101000014018','380101000014657','380101000014658','380101000014660','380101000014709','380101000014710','380101000014711','380101000014868','380101000014914','380101000014952','380101000014953','380101000014954','380101000014955','380101000013697','380101000013862','380101000014202','380101000001596','380101000014155','380101000014396','380101000014824','380101000014236','380101000014236','380101000014236','380101000013844','380101000013844','380101000013844','380101000013844','380101000013844','380101000013844','380101000013844','380101000013844','380101000013844','380101000013844','380101000013844','380101000013844','380101000014146','380101000014240','380101000014240','380101000014240','380101000014240','380101000014240','380101000014240','380101000014240','380101000014240','380101000014240','380101000014146','380101000014366','380101000014366','380101000014366','380101000014366','380101000014366','380101000014366','380101000014366','380101000014366','380101000014366','380101000014366','380101000014849','380101000014849','380101000014849','380101000014236','380101000014236','380101000014236','380101000014545','380101000014968','380101000014023','380101000014503','380101000014870','380101000013667','380101000001478','380101000013715','380101000013828','380101000014112','380101000014297','380101000014848','380101000014213','380101000014592','380101000014969','380101000014964','380101000014964','380101000015019','380101000014970','380101000011540','380101000014768','380101000013567','380101000014770','380101000013657','380101000014779','380101000014769','380101000014599','380101000014399','380101000011297','380101000014031','380101000014039','380101000014091','380101000014310','380101000014806','380101000014787','380101000014411','380101000014786','380101000014378','380101000014378','380101000014378','380101000014378','380101000014664','380101000014664','380101000014664','380101000014664','380101000014867','380101000014867','380101000014283','380101000014604','380101000014845','380101000013599','380101000013599','380101000013598','380101000013661','380101000014352','380101000013583','380101000013583','380101000011414','380101000011415')  and RegistryCheckStatus_id is null;
        
