MATERIALIZED VIEW: APPS.MTH_EQUIP_PROD_SCH_PM_MV

Source

SELECT "A1"."DAY_ID" "DAY_ID","A1"."CALENDAR_MONTH_ID" "CALENDAR_MONTH_ID",SUM("A1"."PLANNED_QTY_G") "PLANNED_QTY_G",COUNT("A1"."PLANNED_QTY_G") "PLANNED_QTY_G_COUNT",SUM("A1"."PLANNED_QTY_SG") "PLANNED_QTY_SG",COUNT("A1"."PLANNED_QTY_SG") "PLANNED_QTY_SG_COUNT",SUM("A1"."SHIFT_SCH_PROD") "SHIFT_SCH_PROD",COUNT("A1"."SHIFT_SCH_PROD") "SHIFT_SCH_PROD_COUNT",SUM("A1"."HRS_SCH_QTY") "HRS_SCH_QTY",COUNT("A1"."HRS_SCH_QTY") "HRS_SCH_QTY_COUNT",COUNT(*) "TOTAL_COUNT","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",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_PROD_SCH_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"))