SELECT RECOM.INVENTORY_ITEM_ID , RECOM.COMPILE_DESIGNATOR , RECOM.ORGANIZATION_ID , CAL.PERIOD_START_DATE , SUM(DECODE(LAST_UNIT_COMPLETION_DATE , NULL , NEW_ORDER_QUANTITY , DAILY_RATE)) SUPPLY_QUANTITY FROM BOM_PERIOD_START_DATES CAL , BOM_CALENDAR_DATES DATES , MTL_PARAMETERS PARAM , MRP_PLANS PLANS , MRP_RECOMMENDATIONS RECOM WHERE CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID AND CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE AND CAL.PERIOD_START_DATE <= PLANS.CUTOFF_DATE AND DATES.CALENDAR_DATE >= CAL.PERIOD_START_DATE AND DATES.CALENDAR_DATE < CAL.NEXT_DATE AND DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE AND DATES.SEQ_NUM IS NOT NULL AND DATES.CALENDAR_DATE BETWEEN RECOM.NEW_SCHEDULE_DATE AND DECODE(LAST_UNIT_COMPLETION_DATE , NULL , RECOM.NEW_SCHEDULE_DATE , RECOM.LAST_UNIT_COMPLETION_DATE) AND PARAM.ORGANIZATION_ID = RECOM.ORGANIZATION_ID AND PLANS.ORGANIZATION_ID = RECOM.ORGANIZATION_ID AND PLANS.COMPILE_DESIGNATOR = RECOM.COMPILE_DESIGNATOR AND RECOM.DISPOSITION_STATUS_TYPE = 1 GROUP BY RECOM.COMPILE_DESIGNATOR , RECOM.ORGANIZATION_ID , RECOM.INVENTORY_ITEM_ID , CAL.PERIOD_START_DATE