[Home] [Help]
298: -- Find the routing for the arg_top_assy_id
299: select --routing_sequence_id
300: common_routing_sequence_id --3701766 3891345.999
301: into var_routing_sequence_id
302: from bom_operational_routings
303: where organization_id = arg_org_id
304: and assembly_item_id = arg_top_assy_id
305: and NVL(alternate_routing_designator, 'ABD756fhh456') =
306: NVL(arg_alt_rtg_desig, 'ABD756fhh456');
396: /* Changed the where clause of the query for bug #2508196 to
397: pick up the line on which primary routing of the item exists. */
398: select line_id
399: into var_line_id
400: from bom_operational_routings flow_rtg
401: where flow_rtg.assembly_item_id = var_comp_id
402: and flow_rtg.organization_id = arg_org_id
403: and flow_rtg.cfm_routing_flag = 1
404: and flow_rtg.alternate_routing_designator is null;
404: and flow_rtg.alternate_routing_designator is null;
405:
406: /* where flow_rtg.routing_sequence_id =
407: (select min(routing_sequence_id)
408: from bom_operational_routings rtg1
409: where rtg1.assembly_item_id = var_comp_id
410: and rtg1.organization_id = arg_org_id
411: and rtg1.cfm_routing_flag = 1
412: and NVL(rtg1.priority, 1) =
410: and rtg1.organization_id = arg_org_id
411: and rtg1.cfm_routing_flag = 1
412: and NVL(rtg1.priority, 1) =
413: (select NVL(min(priority), 1)
414: from bom_operational_routings rtg
415: where rtg.assembly_item_id = var_comp_id
416: and rtg.organization_id = arg_org_id));
417: */
418: exception
641: to_char(var_comp_tbl(var_current_row).usage));
642: end if;
643: select count(*)
644: INTO var_rtg_exists
645: from bom_operational_routings rtg
646: where rtg.organization_id = arg_org_id
647: and rtg.assembly_item_id =
648: var_comp_tbl(var_current_row).item_id
649: and NVL(rtg.alternate_routing_designator, 'ABD756fhh456') =