[Home] [Help]
410: --if there exists a routing, lock the last operation
411: if(p_cplRec.lastOpSeq > 0) then
412: select quantity_waiting_to_move, rowid
413: into l_toMoveQty, l_rowid
414: from wip_operations
415: where wip_entity_id = p_cplRec.wipEntityID
416: and operation_seq_num = p_cplRec.lastOpSeq
417: for update of quantity_waiting_to_move nowait;
418:
421: fnd_msg_pub.add;
422: l_errMsg := 'not enough qty in to move of last op';
423: raise fnd_api.g_exc_unexpected_error;
424: end if;
425: update wip_operations --lower the quantity available to complete
426: set quantity_waiting_to_move = quantity_waiting_to_move - p_cplRec.priQty,
427: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
428: last_updated_by = fnd_global.user_id,
429: last_update_date = sysdate,
529: wo.quantity_waiting_to_move,
530: wmat.primary_quantity,
531: rowidtochar(wrs.rowid),
532: rowidtochar(wo.rowid)
533: from wip_operations wo,
534: wip_repetitive_schedules wrs,
535: wip_mtl_allocations_temp wmat
536: where wrs.wip_entity_id = p_cplRec.wipEntityID
537: and wrs.line_id = p_cplRec.repLineID
604:
605: for i in 1..l_schedRecTbl.schedID.count loop
606: select nvl(sum(quantity_scrapped), 0)
607: into l_scrapQty
608: from wip_operations
609: where repetitive_schedule_id = l_schedRecTbl.schedID(i);
610:
611: if(l_schedRecTbl.woRowID(i) is not null) then
612: update wip_operations
608: from wip_operations
609: where repetitive_schedule_id = l_schedRecTbl.schedID(i);
610:
611: if(l_schedRecTbl.woRowID(i) is not null) then
612: update wip_operations
613: set quantity_waiting_to_move = quantity_waiting_to_move - l_schedRecTbl.preAlcQty(i),
614: date_last_moved = sysdate,
615: last_updated_by = fnd_global.user_id,
616: last_update_date = sysdate,
926: wrs.bom_revision bomRev,
927: nvl(wo.quantity_waiting_to_move,
928: ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed)) availQty,
929: nvl(sum(wmat.primary_quantity), 0) tempQty
930: from wip_operations wo,
931: wip_repetitive_schedules wrs,
932: wip_mtl_allocations_temp wmat
933: where wrs.wip_entity_id = v_wipEntityID
934: and wrs.line_id = v_repLineID
1142: if(l_schedRecTbl.availQty(j) is null) then
1143: select ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed) - nvl(sum(wo.quantity_scrapped), 0)
1144: into l_schedRecTbl.availQty(j)
1145: from wip_repetitive_schedules wrs,
1146: wip_operations wo
1147: where wrs.wip_entity_id = p_wipEntityID
1148: and wrs.repetitive_schedule_id = l_schedRecTbl.repSchedID(j)
1149: and wrs.repetitive_schedule_id = wo.repetitive_schedule_id (+)
1150: and wrs.wip_entity_id = wo.wip_entity_id (+)