SELECT  /*+  bypass_recursive_check  INDEX_COMBINE(V8)  */  
  SUM_284 SUM_284, 
  ((CASE GROUPING_ID_281
   WHEN  7 
   THEN 'PROD_ROLLUP::PROD_TOTAL::'
   WHEN  3 
   THEN 'PROD_ROLLUP::CATEGORY::'
   WHEN  1 
   THEN 'PROD_ROLLUP::SUBCATEGORY::'
   WHEN  0 
   THEN 'PROD_ROLLUP::PRODUCT::'
   ELSE NULL END)  || (CASE GROUPING_ID_281
   WHEN  7 
   THEN TO_CHAR(T5_PROD_TOTAL) 
   WHEN  3 
   THEN TO_CHAR(T5_PROD_CATEGORY) 
   WHEN  1 
   THEN TO_CHAR(T5_PROD_SUBCATEGORY) 
   ELSE TO_CHAR(T5_PROD_ID)  END) )  ALIAS_286, 
  GROUPING_ID_281 GROUPING_ID_281, 
  T5_PROD_TOTAL T5_PROD_TOTAL, 
  T5_PROD_CATEGORY T5_PROD_CATEGORY, 
  T5_PROD_SUBCATEGORY T5_PROD_SUBCATEGORY, 
  T5_PROD_ID T5_PROD_ID, 
  ((CASE GROUPING_ID_282
   WHEN  7 
   THEN 'CAL_ROLLUP::YEAR::'
   WHEN  3 
   THEN 'CAL_ROLLUP::QUARTER::'
   WHEN  1 
   THEN 'CAL_ROLLUP::MONTH::'
   WHEN  0 
   THEN 'CAL_ROLLUP::DAY::'
   ELSE NULL END)  || (CASE GROUPING_ID_282
   WHEN  7 
   THEN TO_CHAR(T6_CALENDAR_YEAR) 
   WHEN  3 
   THEN TO_CHAR(T6_CALENDAR_QUARTER_DESC) 
   WHEN  1 
   THEN TO_CHAR(T6_CALENDAR_MONTH_DESC) 
   ELSE TO_CHAR(T6_TIME_ID)  END) )  ALIAS_287, 
  GROUPING_ID_282 GROUPING_ID_282, 
  T6_CALENDAR_YEAR T6_CALENDAR_YEAR, 
  T6_CALENDAR_QUARTER_DESC T6_CALENDAR_QUARTER_DESC, 
  T6_CALENDAR_MONTH_DESC T6_CALENDAR_MONTH_DESC, 
  T6_TIME_ID T6_TIME_ID, 
  NULL ALIAS_288 
FROM 
  (
  SELECT  /*+  index_combine(*) */  
    GROUPING_ID(T5.PROD_TOTAL, T5.PROD_CATEGORY, T5.PROD_SUBCATEGORY, T5.PROD_ID)  GROUPING_ID_281, 
    T5.PROD_TOTAL T5_PROD_TOTAL, 
    T5.PROD_CATEGORY T5_PROD_CATEGORY, 
    T5.PROD_SUBCATEGORY T5_PROD_SUBCATEGORY, 
    T5.PROD_ID T5_PROD_ID, 
    GROUPING_ID(T6.CALENDAR_YEAR, T6.CALENDAR_QUARTER_DESC, T6.CALENDAR_MONTH_DESC, T6.TIME_ID)  GROUPING_ID_282, 
    T6.CALENDAR_YEAR T6_CALENDAR_YEAR, 
    T6.CALENDAR_QUARTER_DESC T6_CALENDAR_QUARTER_DESC, 
    T6.CALENDAR_MONTH_DESC T6_CALENDAR_MONTH_DESC, 
    T6.TIME_ID T6_TIME_ID, 
    SUM(T7.UNIT_COST)  SUM_284 
  FROM 
    SH.PRODUCTS T5, 
    SH.TIMES T6, 
    SH.COSTS T7 
  WHERE 
    ((T7.PROD_ID = T5.PROD_ID) 
      AND (T7.TIME_ID = T6.TIME_ID) )  
  GROUP BY 
    (T5.PROD_TOTAL) , 
    ROLLUP ((T5.PROD_CATEGORY) , (T5.PROD_SUBCATEGORY) , (T5.PROD_ID) ) , 
    (T6.CALENDAR_YEAR) , 
    ROLLUP ((T6.CALENDAR_QUARTER_DESC) , (T6.CALENDAR_MONTH_DESC) , (T6.TIME_ID) )  ) 
  V8 
WHERE 
  (((GROUPING_ID_282 =  7 . 000000 ) 
      AND ((T6_CALENDAR_YEAR)  IN (( 1998 . 000000 ) , ( 1999 . 000000 ) , ( 2000 . 000000 ) , ( 2001 . 000000 ) ) ) ) 
    AND ((GROUPING_ID_281 =  7 . 000000 ) 
      AND ((T5_PROD_TOTAL)  IN (('Product total') ) ) ) )