APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MRP_SR_ASSIGNMENTS

Line 378: /*delete from mrp_sr_assignments

374: --
375: -- Copy sourcing from CTO to MRP Default Assignment Set
376: --
377: --Bugfix 8894392
378: /*delete from mrp_sr_assignments
379: where assignment_set_id = l_mrp_aset_id
380: and inventory_item_id in
381: (select config_item_id
382: from bom_cto_order_lines_upg

Line 389: delete from mrp_sr_assignments msa

385: and (p_changed_src = 'Y'
386: or (p_changed_src = 'N' and nvl(config_creation,'1') = '3')));*/
387:
388: --1st delete.. Removing assignments for configs that have cto assignment created
389: delete from mrp_sr_assignments msa
390: where msa.assignment_set_id = l_mrp_aset_id
391: and msa.inventory_item_id in
392: (select config_item_id
393: from bom_cto_order_lines_upg bcol

Line 398: FROM mrp_sr_assignments ma

394: where sequence = p_seq
395: and status = 'BOM_BULK'
396: and bcol.config_item_id is not null
397: and EXISTS ( SELECT 'exists'
398: FROM mrp_sr_assignments ma
399: WHERE ma.assignment_set_id = l_cto_aset_id
400: AND ma.inventory_item_id = bcol.config_item_id
401: )
402: );

Line 409: delete from mrp_sr_assignments msa

405:
406: --2nd delete.. Removing those configs that do not have cto assignments and their base model
407: --doesn't have mrp assignments
408:
409: delete from mrp_sr_assignments msa
410: where msa.assignment_set_id = l_mrp_aset_id
411: and msa.inventory_item_id in
412: ( select config_item_id
413: from bom_cto_order_lines_upg bcol

Line 418: FROM mrp_sr_assignments ma

414: where sequence = p_seq
415: and status = 'BOM_BULK'
416: and bcol.config_item_id IS NOT null
417: and NOT EXISTS ( SELECT 'cto assg exists for config'
418: FROM mrp_sr_assignments ma
419: WHERE ma.assignment_set_id = l_cto_aset_id
420: AND ma.inventory_item_id = bcol.config_item_id
421: )
422: and NOT EXISTS ( SELECT 'mrp assg exists for model'

Line 423: FROM mrp_sr_assignments ma

419: WHERE ma.assignment_set_id = l_cto_aset_id
420: AND ma.inventory_item_id = bcol.config_item_id
421: )
422: and NOT EXISTS ( SELECT 'mrp assg exists for model'
423: FROM mrp_sr_assignments ma
424: WHERE ma.assignment_set_id = l_mrp_aset_id
425: AND ma.inventory_item_id = bcol.inventory_item_id
426: )
427: );

Line 432: insert into mrp_sr_assignments(

428:
429: WriteToLog('Rows deleted from MRP Default Assignment Set after 2nd delete::' ||sql%rowcount, 2);
430: --End bugfix 8894392
431:
432: insert into mrp_sr_assignments(
433: ASSIGNMENT_ID,
434: ASSIGNMENT_TYPE,
435: SOURCING_RULE_ID,
436: SOURCING_RULE_TYPE,

Line 471: mrp_sr_assignments_s.nextval, --ASSIGNMENT_ID,

467: ATTRIBUTE15,
468: CUSTOMER_ID,
469: SHIP_TO_SITE_ID)
470: select
471: mrp_sr_assignments_s.nextval, --ASSIGNMENT_ID,
472: ma.ASSIGNMENT_TYPE,
473: ma.SOURCING_RULE_ID,
474: ma.SOURCING_RULE_TYPE,
475: l_mrp_aset_id,

Line 508: from mrp_sr_assignments ma

504: ma.ATTRIBUTE14,
505: ma.ATTRIBUTE15,
506: ma.CUSTOMER_ID,
507: ma.SHIP_TO_SITE_ID
508: from mrp_sr_assignments ma
509: where ma.assignment_set_id = l_cto_aset_id
510: and ma.inventory_item_id in (
511: select distinct bcolu.config_item_id
512: from bom_cto_order_lines_upg bcolu

Line 535: delete from mrp_sr_assignments

531: /*
532: --
533: -- Delete rows from CTO assignment set
534: --
535: delete from mrp_sr_assignments
536: where assignment_set_id = l_cto_aset_id;
537:
538: WriteToLog('Rows deleted from CTO Seeded Assignment Set::' ||sql%rowcount, 2);
539: */