APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_ITEM_LOC_DEFAULTS

Line 2936: insert into mtl_item_loc_defaults

2932: Copy Locator Defaults
2933: +--------------------------------------*/
2934:
2935: lStmtNumber := 190;
2936: insert into mtl_item_loc_defaults
2937: (
2938: inventory_item_id,
2939: organization_id,
2940: locator_id,

Line 2970: mtl_item_loc_defaults ld,

2966: NULL, -- program_application_id
2967: NULL, -- program_id
2968: SYSDATE -- program_update_date
2969: from
2970: mtl_item_loc_defaults ld,
2971: bom_cto_src_orgs bcso,
2972: bom_cto_order_lines_upg bcolu
2973: where bcolu.config_item_id is not null
2974: and bcolu.status = 'BCSO'

Line 2981: from mtl_item_loc_defaults

2977: and bcso.model_item_id = bcolu.inventory_item_id
2978: and bcso.line_id = bcolu.line_id
2979: and NOT EXISTS
2980: (select NULL
2981: from mtl_item_loc_defaults
2982: where inventory_item_id = bcolu.config_item_id
2983: and organization_id = ld.organization_id);
2984:
2985:

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

2982: where inventory_item_id = bcolu.config_item_id
2983: and organization_id = ld.organization_id);
2984:
2985:
2986: WriteToLog('Inserted rows into mtl_item_loc_defaults:: '||sql%rowcount,2);
2987: --
2988: -- create item attachments in loop
2989: --
2990: lStmtNumber := 200;