Hi

I have to write a trigger on Oppportunity Object  , the Opportunity product line is connect to oracle system and records are updated in the opportunity product through oracle and also contract admin can update the Opportunity product record,

there is one deal summary object , which is child to Opportunity and also has lookup relation with opportunity product

Schedule ID is the field on opportunity product which we are using do differentiate the records

and schedule ID will be the name of the record in deal summary object

when ever the Opportunity product is updated , if there is no Schedule ID present in deal summary object it should create new record and if there exist a record with same schedule ID it should update that record

Asked to use agregate soql

the fields to update are MRR, INCREMENTAL MRR

I have created one custom Object which is in master detail relation with Opportunity object(Master) and lookup reation with Opportunity product line , when ever the opportunity is Updated, Trigger should Create new record in the custom object  with the details of Product line .