UPDATE SUMMARY_TABLE 
 	SET v_parameter_1 = (SELECT i_parameter 
 			     FROM (SELECT MIN(i_parameter) i_parameter,v_parameter_3,v_parameter_4,v_parameter_5,v_parameter_17,
 								v_parameter_26,v_parameter_32,v_parameter_18,v_parameter_27,v_parameter_31,v_parameter_33
  				   FROM SUMMARY_TABLE a
 				   WHERE v_product_processor='CARDS' 
 				    AND v_parameter_1 IS NULL
 				     GROUP BY			v_parameter_3,
 								v_parameter_4,
 								v_parameter_5,
 								v_parameter_17,
 								v_parameter_26,
 								v_parameter_32,
 								v_parameter_18,
 								v_parameter_27,
 								v_parameter_31,
 								v_parameter_33) temp1
 			      WHERE coalesce(SUMMARY_TABLE.v_parameter_3,'MSG') = coalesce(temp1.v_parameter_3,'MSG') AND
 				    coalesce(SUMMARY_TABLE.v_parameter_4,'MSG') = coalesce(temp1.v_parameter_4,'MSG') AND
 				    coalesce(SUMMARY_TABLE.v_parameter_5,'MSG') = coalesce(temp1.v_parameter_5,'MSG') AND
 				    coalesce(SUMMARY_TABLE.v_parameter_17,'MSG') = coalesce(temp1.v_parameter_17,'MSG') AND
 				    coalesce(SUMMARY_TABLE.v_parameter_26,'MSG') = coalesce(temp1.v_parameter_26,'MSG') AND
 			        coalesce(SUMMARY_TABLE.v_parameter_32,'MSG') = coalesce(temp1.v_parameter_32,'MSG') AND
 				    coalesce(SUMMARY_TABLE.v_parameter_18,'MSG') = coalesce(temp1.v_parameter_18,'MSG') AND
 				    coalesce(SUMMARY_TABLE.v_parameter_27,'MSG') = coalesce(temp1.v_parameter_27,'MSG') AND
 				    coalesce(SUMMARY_TABLE.v_parameter_31,'MSG') = coalesce(temp1.v_parameter_31,'MSG') AND
 				    coalesce(SUMMARY_TABLE.v_parameter_33,'MSG') = coalesce(temp1.v_parameter_33 ,'MSG') )
 	WHERE v_product_processor='CARDS' 
           AND v_parameter_1 IS NULL;

UPDATE STATEMENT, GOAL = ALL_ROWS													Cost=2	Cardinality=1	Bytes=137
 UPDATE								Object owner=REVDEV	Object name=IL_OUTPUT				
  TABLE ACCESS BY INDEX ROWID		Object owner=REVDEV	Object name=IL_OUTPUT		Cost=2	Cardinality=1	Bytes=137
   INDEX RANGE SCAN					Object owner=REVDEV	Object name=IDX_ILO_PDTPSCR	Cost=2	Cardinality=1	
  VIEW	                                                      Object owner=REVDEV	Cost=3	Cardinality=1	Bytes=333
   SORT GROUP BY																	Cost=3	Cardinality=1	Bytes=143
    TABLE ACCESS BY INDEX ROWID	                            Object owner=REVDEV	Object name=IL_OUTPUT			Cost=2	Cardinality=1	Bytes=143
     INDEX RANGE SCAN	                                    Object owner=REVDEV	Object name=IDX_ILO_PDTPSCR				Cost=2	Cardinality=1	

SELECT COUNT(*) FROM SUMMARY_TABLE 
WHERE v_product_processor='CARDS' AND v_parameter_1 IS NULL