SELECT "A4"."DAY_ID" "DAY_ID","A4"."CALENDAR_MONTH_ID" "CALENDAR_MONTH_ID",SUM("A5"."PLANNED_QTY_G") "PLANNED_QTY_G",COUNT("A5"."PLANNED_QTY_G") "PLANNED_QTY_G_COUNT",SUM("A5"."PLANNED_QTY_SG") "PLANNED_QTY_SG",COUNT("A5"."PLANNED_QTY_SG") "PLANNED_QTY_SG_COUNT",SUM("A5"."ITEM_COST"*"A5"."PLANNED_QTY_G") "SHIFT_SCH_PROD",COUNT("A5"."ITEM_COST"*"A5"."PLANNED_QTY_G") "SHIFT_SCH_PROD_COUNT",SUM(NVL("A5"."PLANNED_QTY_G"/"A5"."STANDARD_RATE_1",0)) "HRS_SCH_QTY",COUNT(NVL("A5"."PLANNED_QTY_G"/"A5"."STANDARD_RATE_1",0)) "HRS_SCH_QTY_COUNT",COUNT(*) "TOTAL_COUNT","A5"."STATUS_CODE" "STATUS_CODE","A3"."LEVEL9_FK_KEY" "PRODUCT_LEVEL9_KEY","A2"."LEVEL8_LEVEL_KEY" "DEPT_KEY","A2"."LEVEL8_EFFECTIVE_DATE" "DEPT_EFF_DATE","A1"."LEVEL9_LEVEL_KEY" "CUST_LEVEL9_KEY","A1"."LEVEL9_EFFECTIVE_DATE" "CUST_LEVEL9_EFF_DATE" FROM "MTH"."MTH_EQUIP_PROD_SCHEDULE_F" "A5","APPS"."MTH_SHIFT_GREGORIAN_DENORM_MV" "A4","MTH"."MTH_ITEM_DENORM_D" "A3","MTH"."MTH_EQUIPMENT_DENORM_D" "A2","MTH"."MTH_EQUIPMENT_DENORM_D" "A1" WHERE "A5"."SHIFT_WORKDAY_FK_KEY"="A4"."SHIFT_WORKDAY_PK_KEY" AND "A3"."HIERARCHY_ID"=(-5) AND "A3"."ITEM_FK_KEY"="A5"."ITEM_FK_KEY" AND "A2"."EQUIPMENT_HIERARCHY_KEY"=(-2) AND "A2"."EQUIPMENT_FK_KEY"="A5"."EQUIPMENT_FK_KEY" AND "A4"."FROM_DATE">="A2"."EQUIPMENT_EFFECTIVE_DATE" AND "A4"."FROM_DATE"<=NVL("A2"."EQUIPMENT_EXPIRATION_DATE",TO_DATE('01/01/2100','MM/DD/YYYY')) AND "A1"."EQUIPMENT_HIERARCHY_KEY"=(-3) AND "A1"."EQUIPMENT_FK_KEY"="A5"."EQUIPMENT_FK_KEY" AND "A4"."FROM_DATE">="A1"."EQUIPMENT_EFFECTIVE_DATE" AND "A4"."FROM_DATE"<=NVL("A1"."EQUIPMENT_EXPIRATION_DATE",TO_DATE('01/01/2100','MM/DD/YYYY')) GROUP BY "A2"."LEVEL8_LEVEL_KEY","A2"."LEVEL8_EFFECTIVE_DATE","A4"."DAY_ID","A4"."CALENDAR_MONTH_ID","A3"."LEVEL9_FK_KEY","A1"."LEVEL9_LEVEL_KEY","A1"."LEVEL9_EFFECTIVE_DATE","A5"."STATUS_CODE"
[Home] [Help]