SELECT REPETITIVE_SCHEDULE_ID , ORGANIZATION_ID , SUM(QUANTITY_SCRAPPED) QUANTITY_SCRAPPED FROM WIP_OPERATIONS WHERE REPETITIVE_SCHEDULE_ID IS NOT NULL GROUP BY REPETITIVE_SCHEDULE_ID , ORGANIZATION_ID
View Text - HTML Formatted
SELECT REPETITIVE_SCHEDULE_ID , ORGANIZATION_ID , SUM(QUANTITY_SCRAPPED) QUANTITY_SCRAPPED FROM WIP_OPERATIONS WHERE REPETITIVE_SCHEDULE_ID IS NOT NULL GROUP BY REPETITIVE_SCHEDULE_ID , ORGANIZATION_ID