APPS.EAM_OP_VALIDATE_PVT dependencies on WIP_OPERATION_NETWORKS

Line 670: from wip_operation_networks

666: end if;
667:
668: select count(*)
669: into l_count_on
670: from wip_operation_networks
671: where wip_entity_id = p_eam_op_rec.wip_entity_id
672: and organization_id = p_eam_op_rec.organization_id
673: and ( prior_operation = p_eam_op_rec.operation_seq_num
674: or next_operation = p_eam_op_rec.operation_seq_num);

Line 950: FROM wip_operation_networks won,wip_operations wo,wip_operations wo1

946:
947: CURSOR l_op_network(l_wip_entity_id NUMBER) IS
948: SELECT
949: won.prior_operation,won.next_operation,wo.last_unit_completion_date,wo1.first_unit_start_date
950: FROM wip_operation_networks won,wip_operations wo,wip_operations wo1
951: WHERE won.wip_entity_id = wo.wip_entity_id AND
952: won.wip_entity_id = wo1.wip_entity_id AND
953: won.prior_operation = wo.operation_seq_num AND
954: won.next_operation = wo1.operation_seq_num AND