APPS.WMS_WIP_INTEGRATION dependencies on WIP_OPERATIONS

Line 2852: , wip_operations wo

2848: , bd.department_code
2849: INTO l_department_id
2850: , l_department_code
2851: FROM bom_departments bd
2852: , wip_operations wo
2853: WHERE bd.department_id = wo.department_id
2854: AND wo.wip_entity_id = p_wip_entity_id
2855: AND wo.organization_id = l_organization_id
2856: AND wo.operation_seq_num = p_operation_seq_num;

Line 2863: , wip_operations wo

2859: , bd.department_code
2860: INTO l_department_id
2861: , l_department_code
2862: FROM bom_departments bd
2863: , wip_operations wo
2864: WHERE bd.department_id = wo.department_id
2865: AND wo.wip_entity_id = p_wip_entity_id
2866: AND wo.organization_id = l_organization_id
2867: AND wo.operation_seq_num = p_operation_seq_num

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

2895: END IF;
2896: EXCEPTION
2897: WHEN NO_DATA_FOUND THEN
2898: -- Bug 2023916:
2899: -- No entry in wip operations for discrete/rep job (routing does not exist)
2900: IF (l_debug = 1) THEN
2901: mydebug ('update_mmtt_for_wip:'||'No data for dept ID/code (entity type ' || l_entity_type || ')');
2902: END IF;
2903: l_department_id := NULL;