APPS.WIP_DISCRETE_JOB_PROCESSOR dependencies on WIP_OPERATIONS

Line 59: FROM wip_operations

55:
56: if(l_wlcRec.operation_seq_num > 0) then
57: SELECT quantity_waiting_to_move
58: INTO l_op_qty
59: FROM wip_operations
60: WHERE organization_id = l_wlcRec.organization_id
61: AND wip_entity_id = l_wlcRec.wip_entity_id
62: AND operation_seq_num = l_wlcRec.operation_seq_num
63: FOR UPDATE OF quantity_waiting_to_move;

Line 71: UPDATE wip_operations

67: raise FND_API.G_EXC_UNEXPECTED_ERROR;
68: end if;
69:
70:
71: UPDATE wip_operations
72: SET quantity_waiting_to_move = quantity_waiting_to_move -
73: ROUND(l_wlcRec.primary_quantity,6),
74: date_last_moved = l_wlcRec.transaction_date,
75: last_updated_by = l_wlcRec.last_updated_by,