271: -- Get the common routing sequence id
272: BEGIN
273: SELECT common_routing_sequence_id
274: INTO l_cmn_rtg_seq_id
275: FROM bom_operational_routings
276: WHERE organization_id = p_org_id
277: AND assembly_item_id = l_rtg_item_id
278: AND nvl(alternate_routing_designator, '-1') =
279: nvl(l_alt_rtg_designator, '-1');