APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_SYSTEM_ITEMS_B

Line 451: update mtl_system_items_b msic

447:
448: If p_upgrade_mode = 2 Then
449: WriteToLog('Updating ATP attributes for configs in existing orgs');
450:
451: update mtl_system_items_b msic
452: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
453: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
454: from mtl_system_items_b msim
455: where msim.inventory_item_id = msic.base_item_id

Line 454: from mtl_system_items_b msim

450:
451: update mtl_system_items_b msic
452: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
453: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
454: from mtl_system_items_b msim
455: where msim.inventory_item_id = msic.base_item_id
456: and msim.organization_id = msic.organization_id)
457: where msic.inventory_item_id in
458: (

Line 465: from mtl_system_items_b msim1

461: where status = 'BCSO'
462: and config_item_id is not null
463: )
464: and exists (select 'x'
465: from mtl_system_items_b msim1
466: where msim1.inventory_item_id = msic.base_item_id
467: and msim1.organization_id = msic.organization_id);
468:
469: WriteToLog('Number of Configs updated for ATP attributes ='||sql%rowcount);

Line 3114: insert into mtl_system_items_b

3110:
3111: -- Bug 9223457.added additional attribute columns added in 12.1
3112: -- for mtl_sys_items.pdube
3113:
3114: insert into mtl_system_items_b
3115: (inventory_item_id,
3116: organization_id,
3117: last_update_date,
3118: last_updated_by,

Line 3807: mtl_system_items_b m, -- model

3803: 2
3804:
3805: from
3806: mtl_parameters mp1,
3807: mtl_system_items_b m, -- model
3808: mtl_system_items_b c, -- config
3809: bom_cto_src_orgs bcso,
3810: bom_cto_order_lines_upg bcolu
3811: where bcolu.config_item_id is not null

Line 3808: mtl_system_items_b c, -- config

3804:
3805: from
3806: mtl_parameters mp1,
3807: mtl_system_items_b m, -- model
3808: mtl_system_items_b c, -- config
3809: bom_cto_src_orgs bcso,
3810: bom_cto_order_lines_upg bcolu
3811: where bcolu.config_item_id is not null
3812: and bcolu.status = 'BCSO'

Line 3830: from mtl_system_items_b

3826: and m.organization_id = mp1.organization_id
3827: and mp1.organization_id = bcso.organization_id
3828: and NOT EXISTS
3829: (select NULL
3830: from mtl_system_items_b
3831: where inventory_item_id = bcolu.config_item_id
3832: and organization_id = mp1.organization_id);
3833:
3834: WriteToLog('Items created::'||sql%rowcount, 2);

Line 3898: insert into mtl_system_items_b

3894: --perf bugfix 4905887 (sql id 16105473)
3895: --Removed comments to extent possible
3896:
3897: lStmtNumber := 20;
3898: insert into mtl_system_items_b
3899: (inventory_item_id,
3900: organization_id,
3901: last_update_date,
3902: last_updated_by,

Line 4591: mtl_system_items_b m, -- model

4587: 3,
4588: 2
4589:
4590: from
4591: mtl_system_items_b m, -- model
4592: mtl_system_items_b config, -- config
4593: bom_cto_src_orgs bcso,
4594: bom_cto_order_lines_upg bcolu
4595: where bcolu.config_item_id is not null

Line 4592: mtl_system_items_b config, -- config

4588: 2
4589:
4590: from
4591: mtl_system_items_b m, -- model
4592: mtl_system_items_b config, -- config
4593: bom_cto_src_orgs bcso,
4594: bom_cto_order_lines_upg bcolu
4595: where bcolu.config_item_id is not null
4596: and bcolu.status = 'BCSO'

Line 4612: from mtl_system_items_b

4608: and bcso.line_id = bcolu.line_id
4609: and m.organization_id = bcso.organization_id
4610: and NOT EXISTS
4611: (select NULL
4612: from mtl_system_items_b
4613: where inventory_item_id = bcolu.config_item_id
4614: and organization_id = bcso.organization_id);
4615:
4616: WriteToLog('PC Items created::'||sql%rowcount, 2);