APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2377: insert into mtl_item_sub_inventories

2373: +--------------------------------------------------*/
2374:
2375: lStmtNumber := 150;
2376:
2377: insert into mtl_item_sub_inventories
2378: (
2379: inventory_item_id,
2380: organization_id,
2381: secondary_inventory,

Line 2463: mtl_item_sub_inventories isi,

2459: NULL, -- program_id
2460: SYSDATE, -- program_update_date
2461: isi.ENCUMBRANCE_ACCOUNT
2462: from
2463: mtl_item_sub_inventories isi,
2464: bom_cto_src_orgs bcso,
2465: bom_cto_order_lines_upg bcolu
2466: where bcolu.config_item_id is not null
2467: and bcolu.status = 'BCSO'

Line 2474: from mtl_item_sub_inventories

2470: and bcso.model_item_id = bcolu.inventory_item_id
2471: and bcso.line_id = bcolu.line_id
2472: and NOT EXISTS
2473: (select NULL
2474: from mtl_item_sub_inventories
2475: where inventory_item_id = bcolu.config_item_id
2476: and organization_id = bcso.organization_id);
2477:
2478: WriteToLog('Inserted rows into mtl_item_sub_inventories:: '||sql%rowcount,2);

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

2474: from mtl_item_sub_inventories
2475: where inventory_item_id = bcolu.config_item_id
2476: and organization_id = bcso.organization_id);
2477:
2478: WriteToLog('Inserted rows into mtl_item_sub_inventories:: '||sql%rowcount,2);
2479:
2480:
2481: /*--------------------------------------+
2482: Copy secondary locators