DBA Data[Home] [Help]

APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_OPERATION_RESOURCES

Line 2560: xTableName := 'BOM_OPERATION_RESOURCES';

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);

Line 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,

Line 2566: insert into BOM_OPERATION_RESOURCES

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 ,

Line 2655: bom_operation_resources bor

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: