I am new to Apex Coding and have a hurdle people with more experience may be able to help me overcome.  When an update to an order is triggered, it is performing an Apex Class that does sharing and some other things.  I am attempting to add a method to this Class that will identify duplicate orders item combinations and delete them from the order.

In the following code I am able to display that the "AggregateResult[] ccOrders" query is returning the correct information.  I would like to take those variables and load them into a list where I can delete the records.  I am getting "Error: Compile Error: Invalid bind expression type of APEX_OBJECT for column of type Id at line ......" when i try to compile the class with "List<ccrz__E_OrderItem__c> OrdItemDel" query.  I have displayed the values that are used in the WHERE clause and those values are correct.

Question 1:  Is this the best way to delete those extra Order Item records that are duplicates (I have identified them successfully now want to delete them).
Question 2:  Can someone suggest what would fix the compile issue.
Question 3:  Once the query works and loads the rows to the list, i was planning to use the delete statement with exception processing around it, if you have suggestion on that, it is much appreciated.

The current code for the method in question is listed below.

Dan


/******************************************************************************
 * Determine if any of the orders have duplicate Items.
 * @param List<Id> orderIds 
 */
    public static void checkDuplicateOrderItems( List<Id> orderIds )
    {
        if( orderIds.isEmpty() ) return;

        // Identify Orders within the list that have duplicate items
                AggregateResult[] ccOrders =
             [SELECT ccrz__order__c ord_id
                              ,ccrz__product__r.ccrz__sku__c ord_sku
                              ,ccrz__orderlinetype__c ord_sku_type
                              ,ccrz__category__r.ccrz__categoryid__c ord_sku_catid
                              ,ccrz__category__r.name ord_sku_catname
                              ,COUNT(Id) dupitemcnt
                        FROM ccrz__E_OrderItem__c 
                        WHERE ccrz__Order__r.Id IN :orderIds 
                        GROUP BY ccrz__order__c
                                    ,ccrz__product__r.ccrz__sku__c
                                    ,ccrz__orderlinetype__c
                                    ,ccrz__category__r.ccrz__categoryid__c
                                    ,ccrz__category__r.name
                        HAVING Count(Id) > 1];

                 // Exit Method loop if there are no duplicates in the orders being processed
        if( ccOrders.isEmpty() ) return;
        
                for (AggregateResult ar : ccOrders)  {
                    Object v_ord_id = ar.get('ord_id');
                    Object v_ord_sku = ar.get('ord_sku');
                    Object v_ord_sku_type = ar.get('ord_sku_type');
                    Object v_ord_sku_catid = ar.get('ord_sku_catid');
                    Object v_ord_sku_catname = ar.get('ord_sku_catname');
                    Integer v_dupitemcnt = (Integer)ar.get('dupitemcnt');
                    System.debug('-------- DUPLICATE ORDER SKU -----------');
                    System.debug('ord_id = ' + v_ord_id);
                    System.debug('ord_sku   = ' + v_ord_sku);
                    System.debug('ord_sku_type = ' + v_ord_sku_type);
                    System.debug('ord_sku_catid = ' + v_ord_sku_catid);
                    System.debug('ord_sku_catname = ' + v_ord_sku_catname);
                    System.debug('dupitemcnt = ' + v_dupitemcnt);
                    
                    List<ccrz__E_OrderItem__c> OrdItemDel =
                        [SELECT ID 
                                   ,ccrz__product__r.ccrz__sku__c
                                   ,ccrz__orderlinetype__c
                                   ,ccrz__category__r.ccrz__categoryid__c
                                   ,ccrz__category__r.name
                                   ,ccrz__quantity__c
                         FROM ccrz__E_OrderItem__c
                         WHERE ccrz__order__c = :v_ord_id
                             AND ccrz__product__r.ccrz__sku__c = :v_ord_sku
                             AND ccrz__orderlinetype__c = :v_ord_sku_type
                             AND ccrz__category__r.ccrz__categoryid__c = :v_ord_sku_catid
                         ORDER BY ccrz__quantity__c DESC
                         LIMIT :v_dupitemcnt - 1];
                }
    }
}