APPS.CSTPPWRO dependencies on WIP_OPERATIONS

Line 332: FROM wip_operations wo

328: /*Bug#3136153 - converted to cursor*/
329: CURSOR c_ops IS
330: SELECT wo.previous_operation_seq_num prev_op_seq,
331: wo.next_operation_seq_num next_op_seq
332: FROM wip_operations wo
333: WHERE wo.wip_entity_id = p_entity_id
334: AND NVL(wo.repetitive_schedule_id,-99)
335: = NVL(p_rep_sched_id,-99)
336: AND wo.operation_seq_num = p_op_seq;

Line 353: FROM wip_operations wo

349: IF c_ops%NOTFOUND THEN /*current op has been deleted.*/
350: /*Next op. is the min(op_seq). with op_seq > current op.*/
351: SELECT MIN(wo.operation_seq_num) next_op_seq
352: INTO x_next_op
353: FROM wip_operations wo
354: WHERE wo.wip_entity_id = p_entity_id
355: AND NVL(wo.repetitive_schedule_id,-99)
356: = NVL(p_rep_sched_id,-99)
357: AND wo.operation_seq_num > p_op_seq;

Line 362: FROM wip_operations wo

358: /*Prev op. is that op. with next_op_seq as the next op. of current op.*/
359: BEGIN
360: SELECT wo.operation_seq_num prev_op_seq
361: INTO x_prev_op
362: FROM wip_operations wo
363: WHERE wo.wip_entity_id = p_entity_id
364: AND NVL(wo.repetitive_schedule_id,-99)
365: = NVL(p_rep_sched_id,-99)
366: AND nvl(wo.next_operation_seq_num,-99) = nvl(x_next_op,-99);

Line 404: FROM wip_operations wo

400: l_count NUMBER;
401: BEGIN
402: SELECT count(*)
403: INTO l_count
404: FROM wip_operations wo
405: WHERE wo.wip_entity_id = p_entity_id
406: AND NVL(wo.repetitive_schedule_id,-99)
407: = NVL(p_rep_sched_id,-99)
408: AND wo.operation_seq_num = p_op_seq;