MATERIALIZED VIEW: APPS.MTH_MTL_CONS_LT_MV

Source

SELECT "A1"."DAY_ID" "DAY_ID","A1"."CALENDAR_MONTH_ID" "CALENDAR_MONTH_ID","A1"."PRODUCT_FK_KEY" "PRODUCT_FK_KEY","A1"."PRODUCT_LEVEL9_KEY" "PRODUCT_LEVEL9_KEY","A1"."ITEM_LEVEL9_KEY" "ITEM_LEVEL9_KEY",SUM("A1"."PLANNED_USAGE_QTY_G") "PLANNED_USAGE_QTY_G",COUNT("A1"."PLANNED_USAGE_QTY_G") "PLANNED_QTY_G_COUNT",SUM("A1"."PLANNED_USAGE_QTY_SG") "PLANNED_USAGE_QTY_SG",COUNT("A1"."PLANNED_USAGE_QTY_SG") "PLANNED_USAGE_QTY_SG_COUNT",SUM("A1"."PLANNED_USAGE_VAL") "PLANNED_USAGE_VAL",COUNT("A1"."PLANNED_USAGE_VAL") "PLANNED_USAGE_VAL_COUNT",SUM("A1"."ACTUAL_USAGE_QTY_G") "ACTUAL_USAGE_QTY_G",COUNT("A1"."ACTUAL_USAGE_QTY_G") "ACTUAL_USAGE_QTY_G_COUNT",SUM("A1"."ACTUAL_USAGE_QTY_SG") "ACTUAL_USAGE_QTY_SG",COUNT("A1"."ACTUAL_USAGE_QTY_SG") "ACTUAL_USAGE_QTY_SG_COUNT",SUM("A1"."ACTUAL_USAGE_VAL") "ACTUAL_USAGE_VAL",COUNT("A1"."ACTUAL_USAGE_VAL") "ACTUAL_USAGE_VAL_COUNT",SUM("A1"."UNIT_STANDARD_QTY_G") "UNIT_STANDARD_QTY_G",COUNT("A1"."UNIT_STANDARD_QTY_G") "UNIT_STANDARD_QTY_G_COUNT",SUM("A1"."UNIT_STANDARD_QTY_SG") "UNIT_STANDARD_QTY_SG",COUNT("A1"."UNIT_STANDARD_QTY_SG") "UNIT_STANDARD_QTY_SG_COUNT",COUNT(*) "TOTAL_COUNT",GROUPING_ID("A1"."DAY_ID","A1"."CALENDAR_MONTH_ID","A1"."PRODUCT_FK_KEY","A1"."PRODUCT_LEVEL9_KEY","A1"."ITEM_LEVEL9_KEY") "GROUPING_ID",DECODE(GROUPING_ID("A1"."DAY_ID","A1"."CALENDAR_MONTH_ID"),1,"A1"."DAY_ID",2,"A1"."CALENDAR_MONTH_ID") "TIME_DIM_KEY",DECODE(GROUPING_ID("A1"."DAY_ID","A1"."CALENDAR_MONTH_ID"),1,10,2,9) "TIME_DIM_LEVEL",DECODE(GROUPING_ID("A1"."PRODUCT_FK_KEY","A1"."PRODUCT_LEVEL9_KEY"),1,"A1"."PRODUCT_FK_KEY",2,"A1"."PRODUCT_LEVEL9_KEY") "PRODUCT_DIM_KEY",DECODE(GROUPING_ID("A1"."PRODUCT_FK_KEY","A1"."PRODUCT_LEVEL9_KEY"),1,10,2,9) "PRODUCT_DIM_LEVEL" FROM "APPS"."MTH_MTL_CONS_IT_MV" "A1" GROUP BY  GROUPING SETS (("A1"."ITEM_LEVEL9_KEY", "A1"."PRODUCT_FK_KEY", "A1"."CALENDAR_MONTH_ID"), ("A1"."ITEM_LEVEL9_KEY", "A1"."PRODUCT_LEVEL9_KEY", "A1"."DAY_ID"), ("A1"."ITEM_LEVEL9_KEY", "A1"."PRODUCT_LEVEL9_KEY", "A1"."CALENDAR_MONTH_ID"))