APPS.CTO_UPDATE_CONFIGS_PK dependencies on MRP_SR_ASSIGNMENTS

Line 250: delete from mrp_sr_assignments

246:
247: --
248: -- Delete all assignments from CTO Default Assignment Set
249: --
250: delete from mrp_sr_assignments
251: where assignment_set_id = l_cto_aset_id;
252:
253: WriteToLog('Rows deleted from cto assignment set::'|| sql%rowcount, 1);
254:

Line 291: delete from mrp_sr_assignments

287: -- Fixed for bug 5263027
288: -- Added a conidtion to check for open order with config items linked to the sales order
289:
290: l_stmt_num := 25;
291: delete from mrp_sr_assignments
292: where assignment_set_id = l_mrp_aset_id
293: and inventory_item_id in
294: (select config_item_id
295: from bom_ato_configurations bac

Line 354: delete from mrp_sr_assignments

350: -- Modified by Renga Kannan on 06/06/06
351: -- Fixed for bug 5263027
352: -- Added a conidtion to check for open order with config items linked to the sales order
353: /* SQL Rewritten as part of performance fix 3641207 */
354: delete from mrp_sr_assignments
355: where assignment_set_id = l_mrp_aset_id
356: and inventory_item_id in
357: (
358: select config_item_id

Line 420: delete from mrp_sr_assignments

416: -- (config_creation = 1 or 2) and is not on open order lines.
417: -- Sourcing should not be deleted if it is a pre-configured item.
418: --
419:
420: delete from mrp_sr_assignments
421: where assignment_set_id = l_mrp_aset_id
422: and inventory_item_id = p_config_id
423: -- not being upgraded
424: and not exists