APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_ITEM_LOC_DEFAULTS

Line 2767: insert into mtl_item_loc_defaults

2763: Copy Locator Defaults
2764: +--------------------------------------*/
2765:
2766: lStmtNumber := 190;
2767: insert into mtl_item_loc_defaults
2768: (
2769: inventory_item_id,
2770: organization_id,
2771: locator_id,

Line 2801: mtl_item_loc_defaults ld,

2797: NULL, -- program_application_id
2798: NULL, -- program_id
2799: SYSDATE -- program_update_date
2800: from
2801: mtl_item_loc_defaults ld,
2802: bom_cto_src_orgs bcso,
2803: bom_cto_order_lines_upg bcolu
2804: where bcolu.config_item_id is not null
2805: and bcolu.status = 'BCSO'

Line 2812: from mtl_item_loc_defaults

2808: and bcso.model_item_id = bcolu.inventory_item_id
2809: and bcso.line_id = bcolu.line_id
2810: and NOT EXISTS
2811: (select NULL
2812: from mtl_item_loc_defaults
2813: where inventory_item_id = bcolu.config_item_id
2814: and organization_id = ld.organization_id);
2815:
2816:

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

2813: where inventory_item_id = bcolu.config_item_id
2814: and organization_id = ld.organization_id);
2815:
2816:
2817: WriteToLog('Inserted rows into mtl_item_loc_defaults:: '||sql%rowcount,2);
2818: --
2819: -- create item attachments in loop
2820: --
2821: lStmtNumber := 200;