APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MTL_RTG_ITEM_REVISIONS

Line 5135: WriteToLog('Inserting into mtl_rtg_item_revisions..',5);

5131: Process routing revision table
5132: +-----------------------------------------------------*/
5133: lStmtNum := 70;
5134:
5135: WriteToLog('Inserting into mtl_rtg_item_revisions..',5);
5136: insert into MTL_RTG_ITEM_REVISIONS
5137: (
5138: inventory_item_id,
5139: organization_id,

Line 5136: insert into MTL_RTG_ITEM_REVISIONS

5132: +-----------------------------------------------------*/
5133: lStmtNum := 70;
5134:
5135: WriteToLog('Inserting into mtl_rtg_item_revisions..',5);
5136: insert into MTL_RTG_ITEM_REVISIONS
5137: (
5138: inventory_item_id,
5139: organization_id,
5140: process_revision,

Line 5209: from mtl_rtg_item_revisions mrir

5205: -- and bor.routing_sequence_id = lCfgRtgId
5206: and bor.organization_id = mp.organization_id
5207: and not exists (
5208: select 'exists'
5209: from mtl_rtg_item_revisions mrir
5210: where mrir.inventory_item_id = bcolu.config_item_id
5211: and mrir.organization_id = mp.organization_id
5212: and mrir.process_revision = mp.starting_revision);
5213:

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

5210: where mrir.inventory_item_id = bcolu.config_item_id
5211: and mrir.organization_id = mp.organization_id
5212: and mrir.process_revision = mp.starting_revision);
5213:
5214: WriteToLog('Inserted rows into mtl_rtg_item_revisions::'||sql%rowcount, 3);
5215: /*------------------------------------------------+
5216: ** Load operation resources table
5217: ** 3 new columns added for WIP Simultaneous Resources
5218: +-------------------------------------------------*/