APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_OPERATION_RESOURCES

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

5218: +-------------------------------------------------*/
5219:
5220: lStmtNum := 150;
5221:
5222: WriteToLog('Inserting into bom_operation_resources..',5);
5223: insert into BOM_OPERATION_RESOURCES
5224: (
5225: operation_sequence_id,
5226: resource_seq_num,

Line 5223: insert into BOM_OPERATION_RESOURCES

5219:
5220: lStmtNum := 150;
5221:
5222: WriteToLog('Inserting into bom_operation_resources..',5);
5223: insert into BOM_OPERATION_RESOURCES
5224: (
5225: operation_sequence_id,
5226: resource_seq_num,
5227: resource_id ,

Line 5311: bom_operation_resources bor,

5307: bor.setup_id, /* Bugfix2950774 */
5308: bor.principle_flag
5309: from
5310: bom_operation_sequences osi,
5311: bom_operation_resources bor,
5312: bom_cto_order_lines_upg bcolu,
5313: bom_operational_routings bor1
5314: where bcolu.sequence = p_seq
5315: and bcolu.status = 'BOM_LOOP'

Line 5322: from bom_operation_resources bor2

5318: -- and osi.routing_sequence_id = lCfgRtgId
5319: and osi.request_id = bor.operation_sequence_id
5320: and not exists (
5321: select 'exists'
5322: from bom_operation_resources bor2
5323: where bor2.operation_sequence_id = osi.operation_sequence_id
5324: and bor2.resource_seq_num = bor.resource_seq_num);
5325:
5326: /* request_id contains model op seq_id now */

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

5324: and bor2.resource_seq_num = bor.resource_seq_num);
5325:
5326: /* request_id contains model op seq_id now */
5327:
5328: WriteToLog('Inserted rows into bom_operation_resources::'||sql%rowcount, 3);
5329:
5330:
5331: /*------------------------------------------------+
5332: ** Load sub operation resources table