APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MRP_SR_ASSIGNMENTS

Line 366: delete from mrp_sr_assignments

362:
363: --
364: -- Copy sourcing from CTO to MRP Default Assignment Set
365: --
366: delete from mrp_sr_assignments
367: where assignment_set_id = l_mrp_aset_id
368: and inventory_item_id in
369: (select config_item_id
370: from bom_cto_order_lines_upg

Line 378: insert into mrp_sr_assignments(

374: or (p_changed_src = 'N' and nvl(config_creation,'1') = '3')));
375:
376: WriteToLog('Rows deleted from MRP Default Assignment Set::' ||sql%rowcount, 2);
377:
378: insert into mrp_sr_assignments(
379: ASSIGNMENT_ID,
380: ASSIGNMENT_TYPE,
381: SOURCING_RULE_ID,
382: SOURCING_RULE_TYPE,

Line 417: mrp_sr_assignments_s.nextval, --ASSIGNMENT_ID,

413: ATTRIBUTE15,
414: CUSTOMER_ID,
415: SHIP_TO_SITE_ID)
416: select
417: mrp_sr_assignments_s.nextval, --ASSIGNMENT_ID,
418: ma.ASSIGNMENT_TYPE,
419: ma.SOURCING_RULE_ID,
420: ma.SOURCING_RULE_TYPE,
421: l_mrp_aset_id,

Line 454: from mrp_sr_assignments ma

450: ma.ATTRIBUTE14,
451: ma.ATTRIBUTE15,
452: ma.CUSTOMER_ID,
453: ma.SHIP_TO_SITE_ID
454: from mrp_sr_assignments ma
455: where ma.assignment_set_id = l_cto_aset_id
456: and ma.inventory_item_id in (
457: select distinct bcolu.config_item_id
458: from bom_cto_order_lines_upg bcolu

Line 480: delete from mrp_sr_assignments

476:
477: --
478: -- Delete rows from CTO assignment set
479: --
480: delete from mrp_sr_assignments
481: where assignment_set_id = l_cto_aset_id;
482:
483: WriteToLog('Rows deleted from CTO Seeded Assignment Set::' ||sql%rowcount, 2);
484: