[Home] [Help]
5542: ** new table for WIP Simultaneous Resources
5543: +-------------------------------------------------*/
5544: lStmtNum := 155;
5545:
5546: WriteToLog('Inserting into bom_sub_operation_resources ..',5);
5547: insert into BOM_SUB_OPERATION_RESOURCES
5548: (operation_sequence_id,
5549: substitute_group_num,
5550: --resource_seq_num,
5543: +-------------------------------------------------*/
5544: lStmtNum := 155;
5545:
5546: WriteToLog('Inserting into bom_sub_operation_resources ..',5);
5547: insert into BOM_SUB_OPERATION_RESOURCES
5548: (operation_sequence_id,
5549: substitute_group_num,
5550: --resource_seq_num,
5551: resource_id,
5634: NULL, /*program_id*/
5635: NULL /*program_update_date*/
5636: from
5637: bom_operation_sequences osi,
5638: bom_sub_operation_resources bsor,
5639: bom_cto_order_lines_upg bcolu,
5640: bom_operational_routings bor
5641: where bcolu.sequence = p_seq
5642: and bcolu.status = 'BOM_LOOP'
5645: -- and osi.routing_sequence_id = lCfgRtgId
5646: and osi.request_id = bsor.operation_sequence_id
5647: and not exists (
5648: select 'exists'
5649: from bom_sub_operation_resources bsor1
5650: where bsor1.operation_sequence_id = osi.operation_sequence_id
5651: and bsor1.resource_id = bsor.resource_id
5652: and bsor1.substitute_group_num = bsor.substitute_group_num
5653: and bsor1.replacement_group_num = bsor.replacement_group_num);
5653: and bsor1.replacement_group_num = bsor.replacement_group_num);
5654:
5655: /* request_id contains model op seq_id now */
5656:
5657: WriteToLog('Inserted rows into bom_sub_operation_resources::'||sql%rowcount, 3);
5658:
5659: /*---------------------------------------------------+
5660: ** Process operation Networks table
5661: +---------------------------------------------------*/