APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_OPERATION_RESOURCES

Line 2551: xTableName := 'BOM_OPERATION_RESOURCES';

2547: ** Load operation resources table
2548: ** 3 new columns added for WIP Simultaneous Resources
2549: +-------------------------------------------------*/
2550:
2551: xTableName := 'BOM_OPERATION_RESOURCES';
2552: lStmtNum := 150;
2553:
2554: IF PG_DEBUG <> 0 THEN
2555: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);

Line 2555: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);

2551: xTableName := 'BOM_OPERATION_RESOURCES';
2552: lStmtNum := 150;
2553:
2554: IF PG_DEBUG <> 0 THEN
2555: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);
2556: END IF;
2557:
2558: insert into BOM_OPERATION_RESOURCES
2559: (

Line 2558: insert into BOM_OPERATION_RESOURCES

2554: IF PG_DEBUG <> 0 THEN
2555: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_resources..',5);
2556: END IF;
2557:
2558: insert into BOM_OPERATION_RESOURCES
2559: (
2560: operation_sequence_id,
2561: resource_seq_num,
2562: resource_id ,

Line 2647: bom_operation_resources bor

2643: bor.setup_id, /* Bugfix2950774 */
2644: bor.principle_flag
2645: from
2646: bom_operation_sequences osi,
2647: bom_operation_resources bor
2648: where osi.routing_sequence_id = lCfgRtgId
2649: and osi.request_id = bor.operation_sequence_id;
2650: /* request_id contains model op seq_id now */
2651: