MATERIALIZED VIEW: APPS.MTH_EQUIP_OP_SUM_PM_MV

Source

SELECT "A1"."DAY_ID" "DAY_ID","A1"."CALENDAR_MONTH_ID" "CALENDAR_MONTH_ID","A1"."STATUS_CODE" "STATUS_CODE","A1"."PRODUCT_LEVEL9_KEY" "PRODUCT_LEVEL9_KEY","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"."REJECTED_QTY") "REJECTED_QTY",COUNT("A1"."REJECTED_QTY") "REJECTED_QTY_COUNT",SUM("A1"."QTY_REWORK") "QTY_REWORK",COUNT("A1"."QTY_REWORK") "QTY_REWORK_COUNT",SUM("A1"."QTY_SCRAP") "QTY_SCRAP",COUNT("A1"."QTY_SCRAP") "QTY_SCRAP_COUNT",SUM("A1"."QTY_GOOD") "QTY_GOOD",COUNT("A1"."QTY_GOOD") "QTY_GOOD_COUNT",SUM("A1"."OUTPUT_QTY") "OUTPUT_QTY",COUNT("A1"."OUTPUT_QTY") "OUTPUT_QTY_COUNT",SUM("A1"."COMPLETED_QTY") "COMPLETED_QTY",COUNT("A1"."COMPLETED_QTY") "COMPLETED_QTY_COUNT",SUM("A1"."HRS_ACT_COMP_QTY") "HRS_ACT_COMP_QTY",COUNT("A1"."HRS_ACT_COMP_QTY") "HRS_ACT_COMP_QTY_COUNT",SUM("A1"."SHIFT_ACT_PROD") "SHIFT_ACT_PROD",COUNT("A1"."SHIFT_ACT_PROD") "SHIFT_ACT_PROD_COUNT",SUM("A1"."LOSS_BAD_QUALITY") "LOSS_BAD_QUALITY",COUNT("A1"."LOSS_BAD_QUALITY") "LOSS_BAD_QUALITY_COUNT",SUM("A1"."LOSS_BAD_QUALTY_VAL") "LOSS_BAD_QUALTY_VAL",COUNT("A1"."LOSS_BAD_QUALTY_VAL") "LOSS_BAD_QUALTY_VAL_COUNT",COUNT(*) "TOTAL_COUNT",GROUPING_ID("A1"."DAY_ID","A1"."CALENDAR_MONTH_ID","A1"."STATUS_CODE","A1"."PRODUCT_LEVEL9_KEY","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_OP_SUM_DD_MV" "A1" GROUP BY  GROUPING SETS (("A1"."DEPT_KEY", "A1"."CALENDAR_MONTH_ID", "A1"."PRODUCT_LEVEL9_KEY", "A1"."DEPT_EFF_DATE", "A1"."STATUS_CODE"), ("A1"."CUST_LEVEL9_KEY", "A1"."DAY_ID", "A1"."PRODUCT_LEVEL9_KEY", "A1"."CUST_LEVEL9_EFF_DATE", "A1"."STATUS_CODE"), ("A1"."CUST_LEVEL9_KEY", "A1"."CALENDAR_MONTH_ID", "A1"."PRODUCT_LEVEL9_KEY", "A1"."CUST_LEVEL9_EFF_DATE", "A1"."STATUS_CODE"))