539: SELECT operation_seq_num
540: FROM bom_operation_sequences bos
541: WHERE routing_sequence_id =
542: (SELECT common_routing_sequence_id
543: FROM bom_operational_routings bor
544: WHERE assembly_item_id = p_bom_comp_ops_unexp_rec.assembly_item_id
545: and organization_id = p_bom_comp_ops_unexp_rec.organization_id
546: and nvl(alternate_routing_designator,'NONE') =
547: nvl(p_bom_comp_ops_rec.alternate_bom_code, 'NONE')
552: SELECT operation_seq_num
553: FROM bom_operation_sequences bos
554: WHERE routing_sequence_id =
555: (SELECT common_routing_sequence_id
556: FROM bom_operational_routings bor
557: WHERE assembly_item_id = p_bom_comp_ops_unexp_rec.assembly_item_id
558: and organization_id = p_bom_comp_ops_unexp_rec.organization_id
559: and alternate_routing_designator IS NULL
560: )