MATERIALIZED VIEW: APPS.MTH_MTL_CONS_IT_MV

Source

SELECT "A3"."DAY_ID" "DAY_ID","A3"."CALENDAR_MONTH_ID" "CALENDAR_MONTH_ID","A4"."PRODUCT_FK_KEY" "PRODUCT_FK_KEY","A1"."LEVEL9_FK_KEY" "PRODUCT_LEVEL9_KEY","A2"."LEVEL9_FK_KEY" "ITEM_LEVEL9_KEY",SUM("A4"."REQUIRED_QTY_G") "PLANNED_USAGE_QTY_G",COUNT("A4"."REQUIRED_QTY_G") "PLANNED_USAGE_QTY_G_COUNT",SUM("A4"."REQUIRED_QTY_SG") "PLANNED_USAGE_QTY_SG",COUNT("A4"."REQUIRED_QTY_SG") "PLANNED_USAGE_QTY_SG_COUNT",SUM("A4"."REQUIRED_QTY_G"*"A4"."ITEM_COST") "PLANNED_USAGE_VAL",COUNT("A4"."REQUIRED_QTY_G"*"A4"."ITEM_COST") "PLANNED_USAGE_VAL_COUNT",SUM("A4"."ACTUAL_QTY_G") "ACTUAL_USAGE_QTY_G",COUNT("A4"."ACTUAL_QTY_G") "ACTUAL_USAGE_QTY_G_COUNT",SUM("A4"."ACTUAL_QTY_SG") "ACTUAL_USAGE_QTY_SG",COUNT("A4"."ACTUAL_QTY_SG") "ACTUAL_USAGE_QTY_SG_COUNT",SUM("A4"."ACTUAL_QTY_G"*"A4"."ITEM_COST") "ACTUAL_USAGE_VAL",COUNT("A4"."ACTUAL_QTY_G"*"A4"."ITEM_COST") "ACTUAL_USAGE_VAL_COUNT",SUM("A4"."UNIT_STANDARD_QTY_G") "UNIT_STANDARD_QTY_G",COUNT("A4"."UNIT_STANDARD_QTY_G") "UNIT_STANDARD_QTY_G_COUNT",SUM("A4"."UNIT_STANDARD_QTY_SG") "UNIT_STANDARD_QTY_SG",COUNT("A4"."UNIT_STANDARD_QTY_SG") "UNIT_STANDARD_QTY_SG_COUNT",COUNT(*) "TOTAL_COUNT" FROM "MTH"."MTH_PROD_MTL_CONSUMED_F" "A4","MTH"."MTH_GREGORIAN_CALENDAR" "A3","MTH"."MTH_ITEM_DENORM_D" "A2","MTH"."MTH_ITEM_DENORM_D" "A1" WHERE TRUNC("A4"."PLANNED_COMPLETION_DATE")="A3"."DAY" AND "A2"."HIERARCHY_ID"=(-6) AND "A4"."MATERIAL_FK_KEY"="A2"."ITEM_FK_KEY" AND "A1"."HIERARCHY_ID"=(-5) AND "A4"."PRODUCT_FK_KEY"="A1"."ITEM_FK_KEY" GROUP BY "A1"."LEVEL9_FK_KEY","A4"."PRODUCT_FK_KEY","A2"."LEVEL9_FK_KEY","A3"."CALENDAR_MONTH_ID","A3"."DAY_ID"