595: /*
596: ** Process operation sequences interface table
597: */
598: stmt_num := 80;
599: table_name := 'BOM_OPERATION_SEQUENCES';
600: insert into BOM_OPERATION_SEQUENCES
601: (
602: OPERATION_SEQUENCE_ID,
603: ROUTING_SEQUENCE_ID,
596: ** Process operation sequences interface table
597: */
598: stmt_num := 80;
599: table_name := 'BOM_OPERATION_SEQUENCES';
600: insert into BOM_OPERATION_SEQUENCES
601: (
602: OPERATION_SEQUENCE_ID,
603: ROUTING_SEQUENCE_ID,
604: OPERATION_SEQ_NUM,
863: bon.ATTRIBUTE13,
864: bon.ATTRIBUTE14,
865: bon.ATTRIBUTE15
866: FROM bom_operation_networks bon,
867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif
864: bon.ATTRIBUTE14,
865: bon.ATTRIBUTE15
866: FROM bom_operation_networks bon,
867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif
872: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
865: bon.ATTRIBUTE15
866: FROM bom_operation_networks bon,
867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif
872: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
873: AND bon.to_op_seq_id = bos2.operation_sequence_id
866: FROM bom_operation_networks bon,
867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif
872: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
873: AND bon.to_op_seq_id = bos2.operation_sequence_id
874: AND bos1.routing_sequence_id = bos2.routing_sequence_id
911:
912: for nextop in allops loop
913:
914: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
915: X_from_entity_name =>'BOM_OPERATION_SEQUENCES',
916: X_from_pk1_value =>nextop.model_op_seq_id,
917: X_from_pk2_value =>'',
918: X_from_pk3_value =>'',
919: X_from_pk4_value =>'',
917: X_from_pk2_value =>'',
918: X_from_pk3_value =>'',
919: X_from_pk4_value =>'',
920: X_from_pk5_value =>'',
921: X_to_entity_name =>'BOM_OPERATION_SEQUENCES',
922: X_to_pk1_value =>nextop.operation_sequence_id,
923: X_to_pk2_value =>'',
924: X_to_pk3_value =>'',
925: X_to_pk4_value =>'',
2078: ** Process operation sequences interface tables
2079: */
2080:
2081: stmt_num := 20;
2082: table_name := 'BOM_OPERATION_SEQUENCES';
2083: loop
2084: insert into BOM_OPERATION_SEQUENCES
2085: (
2086: OPERATION_SEQUENCE_ID,
2080:
2081: stmt_num := 20;
2082: table_name := 'BOM_OPERATION_SEQUENCES';
2083: loop
2084: insert into BOM_OPERATION_SEQUENCES
2085: (
2086: OPERATION_SEQUENCE_ID,
2087: ROUTING_SEQUENCE_ID,
2088: OPERATION_SEQ_NUM,
2171:
2172: update bom_op_sequences_interface bsi
2173: set process_flag = 7
2174: where process_flag = 4
2175: and exists (select NULL from bom_operation_sequences bos
2176: where bos.operation_sequence_id =
2177: bsi.operation_sequence_id);
2178: commit;
2179: end loop;