APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2546: insert into mtl_item_sub_inventories

2542: +--------------------------------------------------*/
2543:
2544: lStmtNumber := 150;
2545:
2546: insert into mtl_item_sub_inventories
2547: (
2548: inventory_item_id,
2549: organization_id,
2550: secondary_inventory,

Line 2632: mtl_item_sub_inventories isi,

2628: NULL, -- program_id
2629: SYSDATE, -- program_update_date
2630: isi.ENCUMBRANCE_ACCOUNT
2631: from
2632: mtl_item_sub_inventories isi,
2633: bom_cto_src_orgs bcso,
2634: bom_cto_order_lines_upg bcolu
2635: where bcolu.config_item_id is not null
2636: and bcolu.status = 'BCSO'

Line 2643: from mtl_item_sub_inventories

2639: and bcso.model_item_id = bcolu.inventory_item_id
2640: and bcso.line_id = bcolu.line_id
2641: and NOT EXISTS
2642: (select NULL
2643: from mtl_item_sub_inventories
2644: where inventory_item_id = bcolu.config_item_id
2645: and organization_id = bcso.organization_id);
2646:
2647: WriteToLog('Inserted rows into mtl_item_sub_inventories:: '||sql%rowcount,2);

Line 2647: WriteToLog('Inserted rows into mtl_item_sub_inventories:: '||sql%rowcount,2);

2643: from mtl_item_sub_inventories
2644: where inventory_item_id = bcolu.config_item_id
2645: and organization_id = bcso.organization_id);
2646:
2647: WriteToLog('Inserted rows into mtl_item_sub_inventories:: '||sql%rowcount,2);
2648:
2649:
2650: /*--------------------------------------+
2651: Copy secondary locators