update <PREFIXE_DW>ETATS_CA set ETA_LIBELLE_ETAT_CA='Livré partiellement' where ETA_CODE_ETAT_CA='L'
update <PREFIXE_DW>PAR_GEN set PAR_GEN_DATE=SYSDATETIME() where PAR_GEN_T='LOG' and PAR_GEN_C='RESULT_CODE'

<SEPARATEUR>
/*update records created by Foreign spec */
update cc set CC_DESIGNATION=c.LIBELLE 
from <PREFIXE_DW>CODES_COMPLEMTAIRES cc , <PREFIXE_HA>CODECOMP c where cc.CC_CODE_COMPLEMENTAIRE=c.CODE_CDC and CC_DESIGNATION='' and cc.CC_CODE_SOCIETE<>''

update ss set ss.SI_DESIGNATION  =s.LIBELLE 
from <PREFIXE_DW>SECTIONS_IMPUTATIONS ss , <PREFIXE_HA>SECTIMPU s where ss.SI_CODE_SECTION_IMPUTATION=s.CODE_SI and ss.SI_DESIGNATION='' and ss.SI_CODE_SOCIETE<>''

update sca set sca.SCA_DESIGNATION  =s.LIBELLE 
from <PREFIXE_DW>SOUS_CPTES_ANALYSE sca , <PREFIXE_HA>SSCPTANA s where sca.SCA_CODE_SOUS_CPTE_ANALYSE=s.CODE_SCA and sca.SCA_DESIGNATION='' and sca.SCA_CODE_SOCIETE<>''