APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MTL_RTG_ITEM_REVISIONS

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

5340: Process routing revision table
5341: +-----------------------------------------------------*/
5342: lStmtNum := 70;
5343:
5344: WriteToLog('Inserting into mtl_rtg_item_revisions..',5);
5345: insert into MTL_RTG_ITEM_REVISIONS
5346: (
5347: inventory_item_id,
5348: organization_id,

Line 5345: insert into MTL_RTG_ITEM_REVISIONS

5341: +-----------------------------------------------------*/
5342: lStmtNum := 70;
5343:
5344: WriteToLog('Inserting into mtl_rtg_item_revisions..',5);
5345: insert into MTL_RTG_ITEM_REVISIONS
5346: (
5347: inventory_item_id,
5348: organization_id,
5349: process_revision,

Line 5418: from mtl_rtg_item_revisions mrir

5414: -- and bor.routing_sequence_id = lCfgRtgId
5415: and bor.organization_id = mp.organization_id
5416: and not exists (
5417: select 'exists'
5418: from mtl_rtg_item_revisions mrir
5419: where mrir.inventory_item_id = bcolu.config_item_id
5420: and mrir.organization_id = mp.organization_id
5421: and mrir.process_revision = mp.starting_revision);
5422:

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

5419: where mrir.inventory_item_id = bcolu.config_item_id
5420: and mrir.organization_id = mp.organization_id
5421: and mrir.process_revision = mp.starting_revision);
5422:
5423: WriteToLog('Inserted rows into mtl_rtg_item_revisions::'||sql%rowcount, 3);
5424: /*------------------------------------------------+
5425: ** Load operation resources table
5426: ** 3 new columns added for WIP Simultaneous Resources
5427: +-------------------------------------------------*/