[Home] [Help]
5660: ** Process operation Networks table
5661: +---------------------------------------------------*/
5662: lStmtNum := 380;
5663:
5664: WriteToLog('Inserting into bom_operation_networks ..',5);
5665: INSERT INTO bom_operation_networks
5666: ( FROM_OP_SEQ_ID,
5667: TO_OP_SEQ_ID,
5668: TRANSITION_TYPE,
5661: +---------------------------------------------------*/
5662: lStmtNum := 380;
5663:
5664: WriteToLog('Inserting into bom_operation_networks ..',5);
5665: INSERT INTO bom_operation_networks
5666: ( FROM_OP_SEQ_ID,
5667: TO_OP_SEQ_ID,
5668: TRANSITION_TYPE,
5669: PLANNING_PCT,
5718: bon.ATTRIBUTE12,
5719: bon.ATTRIBUTE13,
5720: bon.ATTRIBUTE14,
5721: bon.ATTRIBUTE15
5722: FROM bom_operation_networks bon,
5723: bom_operation_sequences bos1, /* 'from' Ops of model */
5724: bom_operation_sequences bos2, /* 'to' Ops of model */
5725: bom_operation_sequences bos3, /* 'from' Ops of config */
5726: bom_operation_sequences bos4, /* 'to' Ops of config */
5752: and bor.cfm_routing_flag = 1
5753: and bor.alternate_routing_designator is null )
5754: and not exists (
5755: select 'exists'
5756: from bom_operation_networks bon2
5757: where bon2.from_op_seq_id = bos3.operation_sequence_id
5758: and bon2.to_op_seq_id = bos4.operation_sequence_id);
5759:
5760: WriteToLog('Inserted rows into bom_operation_networks::'||sql%rowcount, 3);
5756: from bom_operation_networks bon2
5757: where bon2.from_op_seq_id = bos3.operation_sequence_id
5758: and bon2.to_op_seq_id = bos4.operation_sequence_id);
5759:
5760: WriteToLog('Inserted rows into bom_operation_networks::'||sql%rowcount, 3);
5761:
5762:
5763: /* -------------------------------------------------------------------------+
5764: Insert into BOM_REFERENCE_DESIGNATORS table