APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_ITEM_SUB_DEFAULTS

Line 2712: insert into mtl_item_sub_defaults

2708: +--------------------------------------*/
2709:
2710: lStmtNumber := 180;
2711:
2712: insert into mtl_item_sub_defaults
2713: (
2714: inventory_item_id,
2715: organization_id,
2716: subinventory_code,

Line 2744: mtl_item_sub_defaults sd,

2740: NULL, -- program_application_id
2741: NULL, -- program_id
2742: SYSDATE -- program_update_date
2743: from
2744: mtl_item_sub_defaults sd,
2745: bom_cto_src_orgs bcso,
2746: bom_cto_order_lines_upg bcolu
2747: where bcolu.config_item_id is not null
2748: and bcolu.status = 'BCSO'

Line 2755: from mtl_item_sub_defaults

2751: and bcso.model_item_id = bcolu.inventory_item_id
2752: and bcso.line_id = bcolu.line_id
2753: and NOT EXISTS
2754: (select NULL
2755: from mtl_item_sub_defaults
2756: where inventory_item_id = bcolu.config_item_id
2757: and organization_id = bcso.organization_id);
2758:
2759: WriteToLog('Inserted rows into mtl_item_sub_defaults:: '||sql%rowcount,2);

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

2755: from mtl_item_sub_defaults
2756: where inventory_item_id = bcolu.config_item_id
2757: and organization_id = bcso.organization_id);
2758:
2759: WriteToLog('Inserted rows into mtl_item_sub_defaults:: '||sql%rowcount,2);
2760:
2761:
2762: /*--------------------------------------+
2763: Copy Locator Defaults