5451: ** Process operation Networks table
5452: +---------------------------------------------------*/
5453: lStmtNum := 380;
5454:
5455: WriteToLog('Inserting into bom_operation_networks ..',5);
5456: INSERT INTO bom_operation_networks
5457: ( FROM_OP_SEQ_ID,
5458: TO_OP_SEQ_ID,
5459: TRANSITION_TYPE,
5452: +---------------------------------------------------*/
5453: lStmtNum := 380;
5454:
5455: WriteToLog('Inserting into bom_operation_networks ..',5);
5456: INSERT INTO bom_operation_networks
5457: ( FROM_OP_SEQ_ID,
5458: TO_OP_SEQ_ID,
5459: TRANSITION_TYPE,
5460: PLANNING_PCT,
5509: bon.ATTRIBUTE12,
5510: bon.ATTRIBUTE13,
5511: bon.ATTRIBUTE14,
5512: bon.ATTRIBUTE15
5513: FROM bom_operation_networks bon,
5514: bom_operation_sequences bos1, /* 'from' Ops of model */
5515: bom_operation_sequences bos2, /* 'to' Ops of model */
5516: bom_operation_sequences bos3, /* 'from' Ops of config */
5517: bom_operation_sequences bos4, /* 'to' Ops of config */
5543: and bor.cfm_routing_flag = 1
5544: and bor.alternate_routing_designator is null )
5545: and not exists (
5546: select 'exists'
5547: from bom_operation_networks bon2
5548: where bon2.from_op_seq_id = bos3.operation_sequence_id
5549: and bon2.to_op_seq_id = bos4.operation_sequence_id);
5550:
5551: WriteToLog('Inserted rows into bom_operation_networks::'||sql%rowcount, 3);
5547: from bom_operation_networks bon2
5548: where bon2.from_op_seq_id = bos3.operation_sequence_id
5549: and bon2.to_op_seq_id = bos4.operation_sequence_id);
5550:
5551: WriteToLog('Inserted rows into bom_operation_networks::'||sql%rowcount, 3);
5552:
5553:
5554: /* -------------------------------------------------------------------------+
5555: Insert into BOM_REFERENCE_DESIGNATORS table