View: WIP_CUMULATIVE_SCRAP_V

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIP_CUMULATIVE_SCRAP_V

View Text

SELECT ROWID ROW_ID
, WIP_ENTITY_ID
, CUMULATIVE_SCRAP_QUANTITY
, SUM(QUANTITY_SCRAPPED) OVER (PARTITION BY WIP_ENTITY_ID
, ORGANIZATION_ID
, NVL(REPETITIVE_SCHEDULE_ID
, -9999) ORDER BY OPERATION_SEQ_NUM ROWS BETWEEN UNBOUNDED PRECEDING
AND 1 PRECEDING) SUM_OF_QTY_SCRAPPED
FROM WIP_OPERATIONS WO
WHERE WO.CUMULATIVE_SCRAP_QUANTITY IS NULL
AND EXISTS (SELECT 1
FROM WIP_DISCRETE_JOBS WDJ
WHERE WDJ.STATUS_TYPE NOT IN (12
, 5
, 7)
AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID UNION ALL SELECT 1
FROM WIP_REPETITIVE_SCHEDULES WRS
WHERE WRS.STATUS_TYPE NOT IN (12
, 5
, 7)
AND WRS.WIP_ENTITY_ID = WO.WIP_ENTITY_ID )

Columns