SELECT DISTINCT 
CASE
WHEN co.CONTRACTGROUPID = 'G4' THEN 'UPDATE RLTT.T_PE_COBJECT SET CURRENTACCOUNTBALANCE = '''|| regexp_replace(co.amount, '^(-?)([.,])', '\10\2') ||''', ACCOUNTCREDITED = '''|| cra.ACCNO || ''', ACCOUNTDEBITED = '''|| dea.ACCNO ||''' where CID = '''|| co.SOURCEID || ''' '
WHEN co.CONTRACTGROUPID != 'G4' THEN 'UPDATE RLTT.T_PE_COBJECT SET CURRENTACCOUNTBALANCE = '''|| regexp_replace(co.amount, '^(-?)([.,])', '\10\2') ||''', ACCOUNTDEBITED = '''|| cra.ACCNO || ''', ACCOUNTCREDITED = '''|| dea.ACCNO ||''' where CID = '''|| co.SOURCEID || ''' '
END AS "script"
FROM CDO_OBJECTS co
INNER JOIN CDO_ACCOUNTS cra ON cra.id = co.CONTRAACCOUNT_ID
INNER JOIN CDO_ACCOUNTS dea ON dea.id = co.MAINACCOUNT_ID
INNER JOIN CDO_MSG_OBJECTS cmo ON cmo.SOURCEID = co.SOURCEID
WHERE cmo.MESSAGE_ID in (select m.id
from cdi.cdo_MSG_OBJECTS mo
right join cdi.cdo_messages m on mo.message_id=m.id
where 1=1
and mo.id > (max (mo.id)-10000)

and mo.RESPONSEMESSAGEDATE >= TO_TIMESTAMP(CURRENT_DATE,'dd.mm.yy')
and mo.status ='SENT'
and m.operation in ('newAccount'));