DBA Data[Home] [Help]

VIEW: APPS.WIP_REP_QUANTITY_SCRAPPED_V

Source

View Text - Preformatted

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