APPS.WIP_CPLPROC_PRIV dependencies on WIP_OPERATIONS

Line 317: from wip_operations

313: + sum(quantity_running)
314: + sum(quantity_waiting_to_move)
315: + sum(quantity_rejected)
316: into l_remain_qty
317: from wip_operations
318: where wip_entity_id = p_cplRec.wipEntityID
319: and organization_id = p_cplRec.orgID;
320:
321: -- handle the no routing case

Line 437: from wip_operations

433: --if there exists a routing, lock the last operation
434: if(p_cplRec.lastOpSeq > 0) then
435: select quantity_waiting_to_move, rowid
436: into l_toMoveQty, l_rowid
437: from wip_operations
438: where wip_entity_id = p_cplRec.wipEntityID
439: and operation_seq_num = p_cplRec.lastOpSeq
440: for update of quantity_waiting_to_move nowait;
441:

Line 448: update wip_operations --lower the quantity available to complete

444: fnd_msg_pub.add;
445: l_errMsg := 'not enough qty in to move of last op';
446: raise fnd_api.g_exc_unexpected_error;
447: end if;
448: update wip_operations --lower the quantity available to complete
449: set quantity_waiting_to_move = quantity_waiting_to_move - p_cplRec.priQty,
450: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
451: last_updated_by = fnd_global.user_id,
452: last_update_date = sysdate,

Line 558: from wip_operations wo,

554: wo.quantity_waiting_to_move,
555: wmat.primary_quantity,
556: rowidtochar(wrs.rowid),
557: rowidtochar(wo.rowid)
558: from wip_operations wo,
559: wip_repetitive_schedules wrs,
560: wip_mtl_allocations_temp wmat
561: where wrs.wip_entity_id = p_cplRec.wipEntityID
562: and wrs.line_id = p_cplRec.repLineID

Line 633: from wip_operations

629:
630: for i in 1..l_schedRecTbl.schedID.count loop
631: select nvl(sum(quantity_scrapped), 0)
632: into l_scrapQty
633: from wip_operations
634: where repetitive_schedule_id = l_schedRecTbl.schedID(i);
635:
636: if(l_schedRecTbl.woRowID(i) is not null) then
637: update wip_operations

Line 637: update wip_operations

633: from wip_operations
634: where repetitive_schedule_id = l_schedRecTbl.schedID(i);
635:
636: if(l_schedRecTbl.woRowID(i) is not null) then
637: update wip_operations
638: set quantity_waiting_to_move = quantity_waiting_to_move - l_schedRecTbl.preAlcQty(i),
639: date_last_moved = sysdate,
640: last_updated_by = fnd_global.user_id,
641: last_update_date = sysdate,

Line 956: from wip_operations wo,

952: wrs.bom_revision bomRev,
953: nvl(wo.quantity_waiting_to_move,
954: ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed)) availQty,
955: nvl(sum(wmat.primary_quantity), 0) tempQty
956: from wip_operations wo,
957: wip_repetitive_schedules wrs,
958: wip_mtl_allocations_temp wmat
959: where wrs.wip_entity_id = v_wipEntityID
960: and wrs.line_id = v_repLineID

Line 1172: wip_operations wo

1168: if(l_schedRecTbl.availQty(j) is null) then
1169: select ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed) - nvl(sum(wo.quantity_scrapped), 0)
1170: into l_schedRecTbl.availQty(j)
1171: from wip_repetitive_schedules wrs,
1172: wip_operations wo
1173: where wrs.wip_entity_id = p_wipEntityID
1174: and wrs.repetitive_schedule_id = l_schedRecTbl.repSchedID(j)
1175: and wrs.repetitive_schedule_id = wo.repetitive_schedule_id (+)
1176: and wrs.wip_entity_id = wo.wip_entity_id (+)