APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_SECONDARY_LOCATORS

Line 2487: insert into mtl_secondary_locators

2483: +--------------------------------------*/
2484:
2485: lStmtNumber := 160;
2486:
2487: insert into mtl_secondary_locators
2488: (
2489: inventory_item_id,
2490: organization_id,
2491: secondary_locator,

Line 2523: mtl_secondary_locators sl,

2519: NULL, -- program_application_id
2520: NULL, -- program_id
2521: SYSDATE -- program_update_date
2522: from
2523: mtl_secondary_locators sl,
2524: bom_cto_src_orgs bcso,
2525: bom_cto_order_lines_upg bcolu
2526: where bcolu.config_item_id is not null
2527: and bcolu.status = 'BCSO'

Line 2534: from mtl_secondary_locators

2530: and bcso.model_item_id = bcolu.inventory_item_id
2531: and bcso.line_id = bcolu.line_id
2532: and NOT EXISTS
2533: (select NULL
2534: from mtl_secondary_locators
2535: where inventory_item_id = bcolu.config_item_id
2536: and organization_id = bcso.organization_id);
2537:
2538: WriteToLog('Inserted rows into mtl_secondary_locators:: '||sql%rowcount,2);

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

2534: from mtl_secondary_locators
2535: where inventory_item_id = bcolu.config_item_id
2536: and organization_id = bcso.organization_id);
2537:
2538: WriteToLog('Inserted rows into mtl_secondary_locators:: '||sql%rowcount,2);
2539:
2540: /*----------------------------------------+
2541: Copy cross references
2542: +----------------------------------------*/