2556: ** Load operation resources table
2557: ** 3 new columns added for WIP Simultaneous Resources
2558: +-------------------------------------------------*/
2559:
2560: xTableName := 'BOM_OPERATION_RESOURCES';
2561: lStmtNum := 150;
2562:
2563: IF PG_DEBUG <> 0 THEN
2564: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);
2560: xTableName := 'BOM_OPERATION_RESOURCES';
2561: lStmtNum := 150;
2562:
2563: IF PG_DEBUG <> 0 THEN
2564: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);
2565: END IF;
2566: insert into BOM_OPERATION_RESOURCES
2567: (
2568: operation_sequence_id,
2562:
2563: IF PG_DEBUG <> 0 THEN
2564: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);
2565: END IF;
2566: insert into BOM_OPERATION_RESOURCES
2567: (
2568: operation_sequence_id,
2569: resource_seq_num,
2570: resource_id ,
2651: bor.setup_id, /* Bugfix2950774 */
2652: bor.principle_flag
2653: from
2654: bom_operation_sequences osi,
2655: bom_operation_resources bor
2656: where osi.routing_sequence_id = lCfgRtgId
2657: and osi.request_id = bor.operation_sequence_id;
2658: /* request_id contains model op seq_id now */
2659: