APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_OPERATION_RESOURCES

Line 5431: WriteToLog('Inserting into bom_operation_resources..',5);

5427: +-------------------------------------------------*/
5428:
5429: lStmtNum := 150;
5430:
5431: WriteToLog('Inserting into bom_operation_resources..',5);
5432: insert into BOM_OPERATION_RESOURCES
5433: (
5434: operation_sequence_id,
5435: resource_seq_num,

Line 5432: insert into BOM_OPERATION_RESOURCES

5428:
5429: lStmtNum := 150;
5430:
5431: WriteToLog('Inserting into bom_operation_resources..',5);
5432: insert into BOM_OPERATION_RESOURCES
5433: (
5434: operation_sequence_id,
5435: resource_seq_num,
5436: resource_id ,

Line 5520: bom_operation_resources bor,

5516: bor.setup_id, /* Bugfix2950774 */
5517: bor.principle_flag
5518: from
5519: bom_operation_sequences osi,
5520: bom_operation_resources bor,
5521: bom_cto_order_lines_upg bcolu,
5522: bom_operational_routings bor1
5523: where bcolu.sequence = p_seq
5524: and bcolu.status = 'BOM_LOOP'

Line 5531: from bom_operation_resources bor2

5527: -- and osi.routing_sequence_id = lCfgRtgId
5528: and osi.request_id = bor.operation_sequence_id
5529: and not exists (
5530: select 'exists'
5531: from bom_operation_resources bor2
5532: where bor2.operation_sequence_id = osi.operation_sequence_id
5533: and bor2.resource_seq_num = bor.resource_seq_num);
5534:
5535: /* request_id contains model op seq_id now */

Line 5537: WriteToLog('Inserted rows into bom_operation_resources::'||sql%rowcount, 3);

5533: and bor2.resource_seq_num = bor.resource_seq_num);
5534:
5535: /* request_id contains model op seq_id now */
5536:
5537: WriteToLog('Inserted rows into bom_operation_resources::'||sql%rowcount, 3);
5538:
5539:
5540: /*------------------------------------------------+
5541: ** Load sub operation resources table