270:
271: --
272: -- Delete all assignments from CTO Default Assignment Set
273: --
274: delete from mrp_sr_assignments
275: where assignment_set_id = l_cto_aset_id;
276:
277: WriteToLog('Rows deleted from cto assignment set::'|| sql%rowcount, 1);
278:
311: -- Fixed for bug 5263027
312: -- Added a conidtion to check for open order with config items linked to the sales order
313:
314: l_stmt_num := 25;
315: delete from mrp_sr_assignments
316: where assignment_set_id = l_mrp_aset_id
317: and inventory_item_id in
318: (select config_item_id
319: from bom_ato_configurations bac
382: -- Modified by Renga Kannan on 06/06/06
383: -- Fixed for bug 5263027
384: -- Added a conidtion to check for open order with config items linked to the sales order
385: /* SQL Rewritten as part of performance fix 3641207 */
386: delete from mrp_sr_assignments
387: where assignment_set_id = l_mrp_aset_id
388: and inventory_item_id in
389: (
390: select /*+ leading(mcat bac) */ DISTINCT config_item_id -- bug 13876670 added hint
457: -- (config_creation = 1 or 2) and is not on open order lines.
458: -- Sourcing should not be deleted if it is a pre-configured item.
459: --
460:
461: delete from mrp_sr_assignments
462: where assignment_set_id = l_mrp_aset_id
463: and inventory_item_id = p_config_id
464: --Bugfix 14359805
465: --Exists in BAC
819: WriteToLog('New Msg: CTO Seeded Assignment Set Id::'||l_cto_aset_id, 2);
820: --
821: -- Delete rows from CTO assignment set
822: --
823: delete from mrp_sr_assignments
824: where assignment_set_id = l_cto_aset_id;
825:
826: WriteToLog('Rows deleted from CTO Seeded Assignment Set::' ||sql%rowcount, 2);
827: --Bugfix 6710393