DBA Data[Home] [Help]

APPS.WIP_SCHEDULER dependencies on WIP_REQUIREMENT_OPERATIONS

Line 460: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

456: AND NVL(REPETITIVE_SCHEDULE_ID, -1) = NVL(X_Repetitive_Schedule_ID, -1);
457:
458: /* Note that WRO quantities are NOT updated here */
459:
460: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
461: SET WRO.DATE_REQUIRED =
462: (SELECT NVL(MIN(FIRST_UNIT_START_DATE), X_Start)
463: FROM WIP_OPERATIONS
464: WHERE ORGANIZATION_ID = X_Organization_Id