APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_SECONDARY_LOCATORS

Line 2656: insert into mtl_secondary_locators

2652: +--------------------------------------*/
2653:
2654: lStmtNumber := 160;
2655:
2656: insert into mtl_secondary_locators
2657: (
2658: inventory_item_id,
2659: organization_id,
2660: secondary_locator,

Line 2692: mtl_secondary_locators sl,

2688: NULL, -- program_application_id
2689: NULL, -- program_id
2690: SYSDATE -- program_update_date
2691: from
2692: mtl_secondary_locators sl,
2693: bom_cto_src_orgs bcso,
2694: bom_cto_order_lines_upg bcolu
2695: where bcolu.config_item_id is not null
2696: and bcolu.status = 'BCSO'

Line 2703: from mtl_secondary_locators

2699: and bcso.model_item_id = bcolu.inventory_item_id
2700: and bcso.line_id = bcolu.line_id
2701: and NOT EXISTS
2702: (select NULL
2703: from mtl_secondary_locators
2704: where inventory_item_id = bcolu.config_item_id
2705: and organization_id = bcso.organization_id);
2706:
2707: WriteToLog('Inserted rows into mtl_secondary_locators:: '||sql%rowcount,2);

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

2703: from mtl_secondary_locators
2704: where inventory_item_id = bcolu.config_item_id
2705: and organization_id = bcso.organization_id);
2706:
2707: WriteToLog('Inserted rows into mtl_secondary_locators:: '||sql%rowcount,2);
2708:
2709: /*----------------------------------------+
2710: Copy cross references
2711: +----------------------------------------*/