MATERIALIZED VIEW: APPS.MTH_EQUIP_ST_SUM_PM_MV

Source

SELECT "A1"."DAY_ID" "DAY_ID","A1"."CALENDAR_MONTH_ID" "CALENDAR_MONTH_ID","A1"."DEPT_KEY" "DEPT_KEY","A1"."DEPT_EFF_DATE" "DEPT_EFF_DATE","A1"."CUST_LEVEL9_KEY" "CUST_LEVEL9_KEY","A1"."CUST_LEVEL9_EFF_DATE" "CUST_LEVEL9_EFF_DATE",SUM("A1"."DOWN_HOURS") "DOWN_HOURS",COUNT("A1"."DOWN_HOURS") "DOWN_HOURS_COUNT",SUM("A1"."DOWN_HOURS_VAL") "DOWN_HOURS_VAL",COUNT("A1"."DOWN_HOURS_VAL") "DOWN_HOURS_VAL_COUNT",SUM("A1"."RUN_HOURS") "RUN_HOURS",COUNT("A1"."RUN_HOURS") "RUN_HOURS_COUNT",SUM("A1"."RUN_HOURS_VAL") "RUN_HOURS_VAL",COUNT("A1"."RUN_HOURS_VAL") "RUN_HOURS_VAL_COUNT",SUM("A1"."IDLE_HOURS") "IDLE_HOURS",COUNT("A1"."IDLE_HOURS") "IDLE_HOURS_COUNT",SUM("A1"."UP_HOURS") "UP_HOURS",COUNT("A1"."UP_HOURS") "UP_HOURS_COUNT",SUM("A1"."MAC_EFF_SUM") "MAC_EFF_SUM",COUNT("A1"."MAC_EFF_SUM") "MAC_EFF_COUNT",SUM("A1"."WO_ITEM_SUM") "WO_ITEM_SUM",COUNT("A1"."WO_ITEM_SUM") "WO_ITEM_COUNT",SUM("A1"."LOSS_INEFF") "LOSS_INEFF",COUNT("A1"."LOSS_INEFF") "LOSS_INEFF_COUNT",COUNT(*) "TOTAL_COUNT",GROUPING_ID("A1"."DAY_ID","A1"."CALENDAR_MONTH_ID","A1"."DEPT_KEY","A1"."DEPT_EFF_DATE","A1"."CUST_LEVEL9_KEY","A1"."CUST_LEVEL9_EFF_DATE") "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"."DEPT_KEY","A1"."CUST_LEVEL9_KEY"),1,(-2),2,(-3)) "EQUIP_HIER",DECODE(GROUPING_ID("A1"."DEPT_KEY","A1"."CUST_LEVEL9_KEY"),1,"A1"."DEPT_KEY",2,"A1"."CUST_LEVEL9_KEY") "EQUIP_HIER_KEY",DECODE(GROUPING_ID("A1"."DEPT_EFF_DATE","A1"."CUST_LEVEL9_EFF_DATE"),1,"A1"."DEPT_EFF_DATE",2,"A1"."CUST_LEVEL9_EFF_DATE") "EQUIP_HIER_EFF_DATE" FROM "APPS"."MTH_EQUIP_ST_SUM_DD_MV" "A1" GROUP BY  GROUPING SETS (("A1"."DEPT_KEY", "A1"."CALENDAR_MONTH_ID", "A1"."DEPT_EFF_DATE"), ("A1"."CUST_LEVEL9_KEY", "A1"."DAY_ID", "A1"."CUST_LEVEL9_EFF_DATE"), ("A1"."CUST_LEVEL9_KEY", "A1"."CALENDAR_MONTH_ID", "A1"."CUST_LEVEL9_EFF_DATE"))