APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_SUB_OPERATION_RESOURCES

Line 2666: xTableName := 'BOM_SUB_OPERATION_RESOURCES';

2662: /*------------------------------------------------+
2663: ** Load sub operation resources table
2664: ** new table for WIP Simultaneous Resources
2665: +-------------------------------------------------*/
2666: xTableName := 'BOM_SUB_OPERATION_RESOURCES';
2667: lStmtNum := 155;
2668:
2669: IF PG_DEBUG <> 0 THEN
2670: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);

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

2666: xTableName := 'BOM_SUB_OPERATION_RESOURCES';
2667: lStmtNum := 155;
2668:
2669: IF PG_DEBUG <> 0 THEN
2670: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);
2671: END IF;
2672: insert into BOM_SUB_OPERATION_RESOURCES
2673: (operation_sequence_id,
2674: substitute_group_num,

Line 2672: insert into BOM_SUB_OPERATION_RESOURCES

2668:
2669: IF PG_DEBUG <> 0 THEN
2670: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_sub_operation_resources ..',5);
2671: END IF;
2672: insert into BOM_SUB_OPERATION_RESOURCES
2673: (operation_sequence_id,
2674: substitute_group_num,
2675: --resource_seq_num,
2676: resource_id,

Line 2763: bom_sub_operation_resources bsor

2759: NULL, /*program_id*/
2760: NULL /*program_update_date*/
2761: from
2762: bom_operation_sequences osi,
2763: bom_sub_operation_resources bsor
2764: where osi.routing_sequence_id = lCfgRtgId
2765: and osi.request_id = bsor.operation_sequence_id;
2766: /* request_id contains model op seq_id now */
2767: