APPS.WIP_SCHEDULING dependencies on WIP_OPERATIONS

Line 63: FROM WIP_OPERATIONS

59: FND_GLOBAL.CONC_REQUEST_ID,
60: FND_GLOBAL.PROG_APPL_ID,
61: FND_GLOBAL.CONC_PROGRAM_ID,
62: SYSDATE
63: FROM WIP_OPERATIONS
64: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
65: AND ORGANIZATION_ID = P_ORGANIZATION_ID);
66:
67: ELSIF P_SCHEDULING_LEVEL = 2 THEN

Line 172: FROM WIP_OPERATIONS

168: FND_GLOBAL.CONC_REQUEST_ID,
169: FND_GLOBAL.PROG_APPL_ID,
170: FND_GLOBAL.CONC_PROGRAM_ID,
171: SYSDATE
172: FROM WIP_OPERATIONS
173: WHERE (WIP_ENTITY_ID, ORGANIZATION_ID) IN
174: (SELECT WIP_ENTITY_ID,
175: ORGANIZATION_ID
176: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI

Line 258: FROM WIP_OPERATIONS

254: AND PROCESS_STATUS = WIP_CONSTANTS.RUNNING;
255:
256: CURSOR COP(we_id number, org_id number) IS
257: SELECT OPERATION_SEQ_NUM
258: FROM WIP_OPERATIONS
259: WHERE WIP_ENTITY_ID = we_id
260: AND ORGANIZATION_ID = org_id;
261:
262: BEGIN

Line 283: UPDATE WIP_OPERATIONS WO

279: FOR C IN CJOB LOOP
280:
281: IF C.SCHEDULING_LEVEL = 1 THEN
282:
283: UPDATE WIP_OPERATIONS WO
284: SET (WO.FIRST_UNIT_START_DATE,
285: WO.FIRST_UNIT_COMPLETION_DATE,
286: WO.LAST_UNIT_START_DATE,
287: WO.LAST_UNIT_COMPLETION_DATE,

Line 311: FROM WIP_OPERATIONS WO

307: (SELECT FIRST_UNIT_START_DATE,
308: LAST_UNIT_COMPLETION_DATE,
309: LAST_UPDATE_DATE,
310: LAST_UPDATED_BY
311: FROM WIP_OPERATIONS WO
312: WHERE WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
313: AND WO.ORGANIZATION_ID = WOR.ORGANIZATION_ID
314: AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM)
315: WHERE WOR.WIP_ENTITY_ID = C.WIP_ENTITY_ID

Line 347: UPDATE WIP_OPERATIONS WO

343: WHERE WOR.WIP_ENTITY_ID = C.WIP_ENTITY_ID
344: AND WOR.OPERATION_SEQ_NUM = D.OPERATION_SEQ_NUM
345: AND WOR.ORGANIZATION_ID = C.ORGANIZATION_ID;
346:
347: UPDATE WIP_OPERATIONS WO
348: SET FIRST_UNIT_START_DATE = x_min_date,
349: LAST_UNIT_START_DATE = x_min_date,
350: FIRST_UNIT_COMPLETION_DATE = x_max_date,
351: LAST_UNIT_COMPLETION_DATE = x_max_date,

Line 548: FROM WIP_OPERATIONS WO

544: AND SI2.PROCESS_PHASE = 2
545: AND SI2.PROCESS_STATUS = 2
546: MINUS
547: SELECT OPERATION_SEQ_NUM
548: FROM WIP_OPERATIONS WO
549: WHERE WO.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
550: AND WO.ORGANIZATION_ID = WSI.ORGANIZATION_ID) ',
551: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
552: 'WIP_SI_INVALID_OPS');

Line 561: FROM WIP_OPERATIONS WO

557: WIP_CONSTANTS.ERROR,
558: ' WSI.SCHEDULING_LEVEL = 1
559: AND EXISTS (
560: SELECT OPERATION_SEQ_NUM
561: FROM WIP_OPERATIONS WO
562: WHERE WO.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
563: AND WO.ORGANIZATION_ID = WSI.ORGANIZATION_ID
564: MINUS
565: SELECT OPERATION_SEQ_NUM

Line 649: FROM WIP_OPERATIONS WO

645: LAST_UPDATED_BY) =
646: (SELECT FIRST_UNIT_START_DATE,
647: LAST_UPDATE_DATE,
648: LAST_UPDATED_BY
649: FROM WIP_OPERATIONS WO
650: WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID
651: AND WO.ORGANIZATION_ID = WRO.ORGANIZATION_ID
652: AND WO.OPERATION_SEQ_NUM = ABS(WRO.OPERATION_SEQ_NUM))
653: WHERE WRO.WIP_ENTITY_ID = P_WIP_ENTITY_ID

Line 664: FROM WIP_OPERATIONS WO

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
666: AND WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID),
667: SCHEDULED_COMPLETION_DATE =
668: (SELECT MAX(LAST_UNIT_COMPLETION_DATE)

Line 669: FROM WIP_OPERATIONS WO

665: WHERE WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
666: AND WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID),
667: SCHEDULED_COMPLETION_DATE =
668: (SELECT MAX(LAST_UNIT_COMPLETION_DATE)
669: FROM WIP_OPERATIONS WO
670: WHERE WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
671: AND WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID),
672: (LAST_UPDATE_DATE,
673: LAST_UPDATED_BY) =

Line 676: FROM WIP_OPERATIONS WO

672: (LAST_UPDATE_DATE,
673: LAST_UPDATED_BY) =
674: (SELECT LAST_UPDATE_DATE,
675: LAST_UPDATED_BY
676: FROM WIP_OPERATIONS WO
677: WHERE WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
678: AND WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
679: AND WO.PREVIOUS_OPERATION_SEQ_NUM IS NULL)
680: WHERE WDJ.WIP_ENTITY_ID = P_WIP_ENTITY_ID