APPS.WIP_SCHEDULER dependencies on WIP_OPERATIONS

Line 29: FROM wip_operations ops

25:
26: CURSOR wip_op_inst IS
27: SELECT ops.operation_seq_num,
28: ops.operation_sequence_id
29: FROM wip_operations ops
30: WHERE NVL(ops.repetitive_schedule_id, -1) =
31: NVL(X_Repetitive_Schedule_Id, -1)
32: AND ops.organization_id = X_Organization_Id
33: AND ops.wip_entity_id = X_Wip_Entity_Id

Line 62: INSERT INTO WIP_OPERATIONS

58: end if;
59:
60: /* This is all extracted froom wiloer.ppc */
61:
62: INSERT INTO WIP_OPERATIONS
63: (WIP_ENTITY_ID,
64: OPERATION_SEQ_NUM,
65: ORGANIZATION_ID,
66: REPETITIVE_SCHEDULE_ID,

Line 175: UPDATE WIP_OPERATIONS WO

171: TO_DATE(X_Routing_Rev_Date,WIP_CONSTANTS.DATETIME_FMT) + 2) >=
172: TO_DATE(X_Routing_Rev_Date,WIP_CONSTANTS.DATETIME_FMT)
173: AND SEQ.IMPLEMENTATION_DATE IS NOT NULL;
174:
175: UPDATE WIP_OPERATIONS WO
176: SET WO.PREVIOUS_OPERATION_SEQ_NUM =
177: (SELECT MAX(OPERATION_SEQ_NUM)
178: FROM WIP_OPERATIONS
179: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id

Line 178: FROM WIP_OPERATIONS

174:
175: UPDATE WIP_OPERATIONS WO
176: SET WO.PREVIOUS_OPERATION_SEQ_NUM =
177: (SELECT MAX(OPERATION_SEQ_NUM)
178: FROM WIP_OPERATIONS
179: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id
180: AND ORGANIZATION_ID = X_Organization_Id
181: AND NVL(REPETITIVE_SCHEDULE_ID, -1) =
182: NVL(X_Repetitive_Schedule_Id, -1)

Line 186: FROM WIP_OPERATIONS

182: NVL(X_Repetitive_Schedule_Id, -1)
183: AND OPERATION_SEQ_NUM < WO.OPERATION_SEQ_NUM),
184: WO.NEXT_OPERATION_SEQ_NUM =
185: (SELECT MIN(OPERATION_SEQ_NUM)
186: FROM WIP_OPERATIONS
187: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id
188: AND ORGANIZATION_ID = X_Organization_Id
189: AND NVL(REPETITIVE_SCHEDULE_ID, -1) =
190: NVL(X_Repetitive_Schedule_Id, -1)

Line 234: WIP_OPERATIONS OPS

230: ORS.ATTRIBUTE15, ORS.SCHEDULE_SEQ_NUM,
231: ORS.SUBSTITUTE_GROUP_NUM, 0, ORS.PRINCIPLE_FLAG, ORS.SETUP_ID
232: FROM BOM_RESOURCES RSC,
233: BOM_OPERATION_RESOURCES ORS,
234: WIP_OPERATIONS OPS
235: WHERE OPS.ORGANIZATION_ID = X_Organization_Id
236: AND OPS.WIP_ENTITY_ID = X_Wip_Entity_Id
237: AND NVL(OPS.REPETITIVE_SCHEDULE_ID, -1) =
238: NVL(X_Repetitive_Schedule_Id, -1)

Line 289: WIP_OPERATIONS OPS

285: SORS.SUBSTITUTE_GROUP_NUM, SORS.REPLACEMENT_GROUP_NUM,
286: SORS.PRINCIPLE_FLAG
287: FROM BOM_RESOURCES RSC,
288: BOM_SUB_OPERATION_RESOURCES SORS,
289: WIP_OPERATIONS OPS
290: WHERE OPS.ORGANIZATION_ID = X_Organization_Id
291: AND OPS.WIP_ENTITY_ID = X_Wip_Entity_Id
292: AND NVL(OPS.REPETITIVE_SCHEDULE_ID, -1) =
293: NVL(X_Repetitive_Schedule_Id, -1)

Line 375: FROM WIP_OPERATIONS

371: IF X_Old_Status_Type <> 1 AND X_Status_Type <> 1
372: AND X_Old_Quantity <> X_Quantity THEN
373: SELECT NVL(MIN(OPERATION_SEQ_NUM), -1)
374: INTO x_first_op
375: FROM WIP_OPERATIONS
376: WHERE ORGANIZATION_ID = X_Organization_Id
377: AND WIP_ENTITY_ID = X_Wip_Entity_Id
378: AND NVL(REPETITIVE_SCHEDULE_ID, -1) =
379: NVL(X_Repetitive_Schedule_Id, -1);

Line 387: UPDATE WIP_OPERATIONS

383: IF x_first_op <> -1 THEN
384:
385: /* Reset the quantity in queue for the first op */
386:
387: UPDATE WIP_OPERATIONS
388: SET QUANTITY_IN_QUEUE = QUANTITY_IN_QUEUE -
389: (SCHEDULED_QUANTITY - X_Quantity)
390: WHERE ORGANIZATION_ID = X_Organization_id
391: AND WIP_ENTITY_ID = X_Wip_Entity_id

Line 440: UPDATE WIP_OPERATIONS

436: END IF; /* End of Quantity validation */
437:
438: -- Update operation quantities and dates
439:
440: UPDATE WIP_OPERATIONS
441: SET FIRST_UNIT_START_DATE = x_start,
442: FIRST_UNIT_COMPLETION_DATE = decode(X_load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, x_comp, x_start),
443: LAST_UNIT_START_DATE = x_start,
444: LAST_UNIT_COMPLETION_DATE = decode(X_load_type, WIP_CONSTANTS.RESCHED_EAM_JOB, x_comp, x_start),

Line 463: FROM WIP_OPERATIONS

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
465: AND WIP_ENTITY_ID = X_Wip_Entity_Id
466: AND NVL(REPETITIVE_SCHEDULE_ID, -1) =
467: NVL(X_Repetitive_Schedule_ID, -1)