APPS.WMS_WIP_INTEGRATION dependencies on WIP_OPERATIONS

Line 2822: , wip_operations wo

2818: , bd.department_code
2819: INTO l_department_id
2820: , l_department_code
2821: FROM bom_departments bd
2822: , wip_operations wo
2823: WHERE bd.department_id = wo.department_id
2824: AND wo.wip_entity_id = p_wip_entity_id
2825: AND wo.organization_id = l_organization_id
2826: AND wo.operation_seq_num = p_operation_seq_num;

Line 2833: , wip_operations wo

2829: , bd.department_code
2830: INTO l_department_id
2831: , l_department_code
2832: FROM bom_departments bd
2833: , wip_operations wo
2834: WHERE bd.department_id = wo.department_id
2835: AND wo.wip_entity_id = p_wip_entity_id
2836: AND wo.organization_id = l_organization_id
2837: AND wo.operation_seq_num = p_operation_seq_num

Line 2869: -- No entry in wip operations for discrete/rep job (routing does not exist)

2865: END IF;
2866: EXCEPTION
2867: WHEN NO_DATA_FOUND THEN
2868: -- Bug 2023916:
2869: -- No entry in wip operations for discrete/rep job (routing does not exist)
2870: IF (l_debug = 1) THEN
2871: mydebug ('update_mmtt_for_wip:'||'No data for dept ID/code (entity type ' || l_entity_type || ')');
2872: END IF;
2873: l_department_id := NULL;