[Home] [Help]
5333: ** new table for WIP Simultaneous Resources
5334: +-------------------------------------------------*/
5335: lStmtNum := 155;
5336:
5337: WriteToLog('Inserting into bom_sub_operation_resources ..',5);
5338: insert into BOM_SUB_OPERATION_RESOURCES
5339: (operation_sequence_id,
5340: substitute_group_num,
5341: --resource_seq_num,
5334: +-------------------------------------------------*/
5335: lStmtNum := 155;
5336:
5337: WriteToLog('Inserting into bom_sub_operation_resources ..',5);
5338: insert into BOM_SUB_OPERATION_RESOURCES
5339: (operation_sequence_id,
5340: substitute_group_num,
5341: --resource_seq_num,
5342: resource_id,
5425: NULL, /*program_id*/
5426: NULL /*program_update_date*/
5427: from
5428: bom_operation_sequences osi,
5429: bom_sub_operation_resources bsor,
5430: bom_cto_order_lines_upg bcolu,
5431: bom_operational_routings bor
5432: where bcolu.sequence = p_seq
5433: and bcolu.status = 'BOM_LOOP'
5436: -- and osi.routing_sequence_id = lCfgRtgId
5437: and osi.request_id = bsor.operation_sequence_id
5438: and not exists (
5439: select 'exists'
5440: from bom_sub_operation_resources bsor1
5441: where bsor1.operation_sequence_id = osi.operation_sequence_id
5442: and bsor1.resource_id = bsor.resource_id
5443: and bsor1.substitute_group_num = bsor.substitute_group_num
5444: and bsor1.replacement_group_num = bsor.replacement_group_num);
5444: and bsor1.replacement_group_num = bsor.replacement_group_num);
5445:
5446: /* request_id contains model op seq_id now */
5447:
5448: WriteToLog('Inserted rows into bom_sub_operation_resources::'||sql%rowcount, 3);
5449:
5450: /*---------------------------------------------------+
5451: ** Process operation Networks table
5452: +---------------------------------------------------*/