APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_SUB_OPERATION_RESOURCES

Line 2656: xTableName := 'BOM_SUB_OPERATION_RESOURCES';

2652: /*------------------------------------------------+
2653: ** Load sub operation resources table
2654: ** new table for WIP Simultaneous Resources
2655: +-------------------------------------------------*/
2656: xTableName := 'BOM_SUB_OPERATION_RESOURCES';
2657: lStmtNum := 155;
2658:
2659: IF PG_DEBUG <> 0 THEN
2660: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);

Line 2660: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);

2656: xTableName := 'BOM_SUB_OPERATION_RESOURCES';
2657: lStmtNum := 155;
2658:
2659: IF PG_DEBUG <> 0 THEN
2660: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);
2661: END IF;
2662:
2663: insert into BOM_SUB_OPERATION_RESOURCES
2664: (operation_sequence_id,

Line 2663: insert into BOM_SUB_OPERATION_RESOURCES

2659: IF PG_DEBUG <> 0 THEN
2660: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);
2661: END IF;
2662:
2663: insert into BOM_SUB_OPERATION_RESOURCES
2664: (operation_sequence_id,
2665: substitute_group_num,
2666: --resource_seq_num,
2667: resource_id,

Line 2754: bom_sub_operation_resources bsor

2750: NULL, /*program_id*/
2751: NULL /*program_update_date*/
2752: from
2753: bom_operation_sequences osi,
2754: bom_sub_operation_resources bsor
2755: where osi.routing_sequence_id = lCfgRtgId
2756: and osi.request_id = bsor.operation_sequence_id;
2757: /* request_id contains model op seq_id now */
2758: