APPS.EAM_OP_UTILITY_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 286: FROM wip_requirement_operations

282:
283: END IF;
284:
285: SELECT count(*) INTO l_count
286: FROM wip_requirement_operations
287: WHERE organization_id = p_eam_op_rec.organization_id
288: AND wip_entity_id = p_eam_op_rec.wip_entity_id
289: AND operation_seq_num = 1
290: AND rownum <=1;

Line 307: update wip_requirement_operations

303: and operation_seq_num = l_min_op_seq_num;
304: END IF;
305:
306:
307: update wip_requirement_operations
308: set operation_seq_num = l_min_op_seq_num,
309: department_id = l_department_id
310: where operation_seq_num = 1
311: and organization_id = p_eam_op_rec.organization_id

Line 445: UPDATE WIP_REQUIREMENT_OPERATIONS

441: AND operation_seq_num = p_eam_op_rec.operation_seq_num;
442:
443: -- If Department of operation is updated then correponding departemnt of materials should also get updated
444: IF l_old_dept_id <> p_eam_op_rec.department_id THEN
445: UPDATE WIP_REQUIREMENT_OPERATIONS
446: set department_id = p_eam_op_rec.department_id
447: WHERE organization_id = p_eam_op_rec.organization_id
448: AND wip_entity_id = p_eam_op_rec.wip_entity_id
449: AND operation_seq_num = p_eam_op_rec.operation_seq_num ;