UPDATE adempiere.AD_PRINTFORMATITEM_TRL
SET printName = (SELECT e.Name FROM adempiere.AD_ELEMENT_TRL e, adempiere.AD_COLUMN c, adempiere.AD_PRINTFORMATITEM p WHERE e.AD_LANGUAGE=AD_PRINTFORMATITEM_TRL.AD_LANGUAGE AND e.AD_Element_ID=c.AD_Element_ID AND c.AD_Column_ID=p.AD_Column_ID AND p.AD_PrintFormatItem_ID=AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID),
Updated = CURRENT_TIMESTAMP WHERE EXISTS (SELECT 1 FROM adempiere.AD_PRINTFORMATITEM p, adempiere.AD_ELEMENT_TRL e, adempiere.AD_COLUMN c
WHERE AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID=p.AD_PrintFormatItem_ID AND p.AD_Column_ID=c.AD_Column_ID AND c.AD_Element_ID=e.AD_Element_ID AND c.AD_Process_ID IS NULL AND AD_PRINTFORMATITEM_TRL.AD_LANGUAGE=e.AD_LANGUAGE AND p.IsCentrallyMaintained='Y' AND p.IsActive='Y' AND (AD_PRINTFORMATITEM_TRL.printName <> e.Name))
;