2902: FROM BOM_SUBSTITUTE_COMPONENTS sub_comp
2903: WHERE sub_comp.component_sequence_id = p_comp_seq_id;
2904:
2905:
2906: INSERT INTO bom_component_operations
2907: (
2908: COMP_OPERATION_SEQ_ID ,
2909: OPERATION_SEQ_NUM ,
2910: OPERATION_SEQUENCE_ID ,
2937: ATTRIBUTE14 ,
2938: ATTRIBUTE15 ,
2939: COMMON_COMPONENT_SEQUENCE_ID)
2940: SELECT
2941: bom_component_operations_s.NEXTVAL ,
2942: comp_ops.OPERATION_SEQ_NUM ,
2943: comp_ops.OPERATION_SEQUENCE_ID ,
2944: comp_ops.LAST_UPDATE_DATE ,
2945: comp_ops.LAST_UPDATED_BY ,
2969: comp_ops.ATTRIBUTE13 ,
2970: comp_ops.ATTRIBUTE14 ,
2971: comp_ops.ATTRIBUTE15 ,
2972: comp_ops.COMMON_COMPONENT_SEQUENCE_ID
2973: FROM BOM_COMPONENT_OPERATIONS comp_ops
2974: WHERE comp_ops.component_sequence_id = p_comp_seq_id;
2975:
2976:
2977: RETURN l_component_seqeunce_id;