[Home] [Help]
45: and (i_planner_code is null or
46: msik.planner_code = i_planner_code)
47: and not exists (
48: select bor.routing_sequence_id
49: from bom_operational_routings bor
50: where bor.assembly_item_id = msik.inventory_item_id
51: and bor.organization_id = i_org_id
52: -- Added for enhancement #2647023
53: and nvl(bor.alternate_routing_designator, '~$~') = nvl(i_alternate_routing_designator, '~$~') )
113: and mic.category_id = i_category_id))
114: and (i_planner_code is null or msik.planner_code = i_planner_code)
115: and not exists
116: (select bor.routing_sequence_id
117: from bom_operational_routings bor
118: where bor.assembly_item_id = msik.inventory_item_id
119: and bor.organization_id = i_org_id
120: -- added for enhancement #2647023
121: and nvl(bor.alternate_routing_designator, '~$~') =
161: and (i_planner_code is null or
162: msik.planner_code = i_planner_code)
163: and not exists (
164: select bor.routing_sequence_id
165: from bom_operational_routings bor
166: where bor.assembly_item_id = msik.inventory_item_id
167: and bor.organization_id = i_org_id
168: -- Added for enhancement #2647023
169: and nvl(bor.alternate_routing_designator, '~$~') = nvl(i_alternate_routing_designator, '~$~') )
296: o_return_code OUT NOCOPY NUMBER) IS
297:
298: CURSOR all_items IS
299: select msik.inventory_item_id id, bor1.alternate_routing_designator alt
300: from mtl_system_items_kfv msik, bom_operational_routings bor1
301: where msik.organization_id = i_org_id
302: and msik.organization_id = bor1.organization_id
303: and msik.inventory_item_id = bor1.assembly_item_id
304: and msik.bom_enabled_flag = 'Y'
353: l_routing_found := 0;
354:
355: select count(routing_sequence_id)
356: into l_routing_found
357: from bom_operational_routings
358: where organization_id = i_org_id and
359: line_id = i_line_id and
360: assembly_item_id = item.id and
361: nvl(alternate_routing_designator,'$$$') =