--4.2
update contratproduit_ set cr_statut = (select refid from refvalues r where  refval ='RP' and reftabid = (select tabid from "tables" where tabradical ='Ls_')),
cr_etat = (select refid from refvalues r where  refval ='FRM' and reftabid = (select tabid from "tables" where tabradical ='Ent')),
cr_datefin = '31-12-2024' where cr_produit in (select prdid from product where prdcode in ('LEXSF LE-SE BLEU','LEXSF LE-TD-SE BLEU','LEXSF LE-TD BLEU','LEXSF LE-TE-SE','LEXSF LE-TE BLEU','LEXSF LE BLEU','LFCCLDF','LFCCLDF/LED','LFCCLSF','LFENSDFLE','LFENSDFSH','LFENSINSOLITE','LFENSMAISON','LFENSSAUVDFSC','LFENSSFSC','LFENSSFSH','LFENSSPLE'));

--4.4
update contratproduit_ set cr_statut = (select refid from refvalues r where  refval ='RP' and reftabid = (select tabid from "tables" where tabradical ='Ls_')),
cr_etat = (select refid from refvalues r where  refval ='FRM' and reftabid = (select tabid from "tables" where tabradical ='Ent')),
cr_datefin = '31-12-2024' where cr_produit in (select prdid from product where prdcode in ('LOCENS16','LOCENS17'));

--4.6
update contratproduit_ set cr_statut = (select refid from refvalues r where  refval ='RP' and reftabid = (select tabid from "tables" where tabradical ='Ls_')),
cr_etat = (select refid from refvalues r where  refval ='FRM' and reftabid = (select tabid from "tables" where tabradical ='Ent')),
cr_datefin = '31-12-2024' where cr_produit in (select prdid from product where prdcode in ('PLMILL','PLMILLSUPP16','PLMILLSUPP17'));

--4.7
update enterprise  set entplaquealu_ = 0, entplaquecosseriz_ = 0;