DBA Data[Home] [Help]

APPS.WIP_SCHEDULING dependencies on WIP_DISCRETE_JOBS

Line 465: FROM WIP_DISCRETE_JOBS WDJ

461: 'WIP_SCHEDULING_INTERFACE WSI',
462: WIP_CONSTANTS.ERROR,
463: ' NOT EXISTS
464: (SELECT 1
465: FROM WIP_DISCRETE_JOBS WDJ
466: WHERE WDJ.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
467: AND WDJ.ORGANIZATION_ID = WSI.ORGANIZATION_ID
468: AND WDJ.STATUS_TYPE IN (1,3,4,6)) ',
469: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

Line 661: UPDATE WIP_DISCRETE_JOBS WDJ

657:
658: PROCEDURE UPDATE_JOB_DATES(P_WIP_ENTITY_ID NUMBER,
659: P_ORGANIZATION_ID NUMBER) IS
660: BEGIN
661: UPDATE WIP_DISCRETE_JOBS WDJ
662: SET SCHEDULED_START_DATE =
663: (SELECT MIN(FIRST_UNIT_START_DATE)
664: FROM WIP_OPERATIONS WO
665: WHERE WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID