APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_SYSTEM_ITEMS_B

Line 411: update mtl_system_items_b msic

407:
408: If p_upgrade_mode = 2 Then
409: WriteToLog('Updating ATP attributes for configs in existing orgs');
410:
411: update mtl_system_items_b msic
412: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
413: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
414: from mtl_system_items_b msim
415: where msim.inventory_item_id = msic.base_item_id

Line 414: from mtl_system_items_b msim

410:
411: update mtl_system_items_b msic
412: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
413: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
414: from mtl_system_items_b msim
415: where msim.inventory_item_id = msic.base_item_id
416: and msim.organization_id = msic.organization_id)
417: where msic.inventory_item_id in
418: (

Line 425: from mtl_system_items_b msim1

421: where status = 'BCSO'
422: and config_item_id is not null
423: )
424: and exists (select 'x'
425: from mtl_system_items_b msim1
426: where msim1.inventory_item_id = msic.base_item_id
427: and msim1.organization_id = msic.organization_id);
428:
429: WriteToLog('Number of Configs updated for ATP attributes ='||sql%rowcount);

Line 2942: insert into mtl_system_items_b

2938:
2939: --perf bugfix 4905887 (sql id 16105473)
2940: --Removed comments to extent possible
2941:
2942: insert into mtl_system_items_b
2943: (inventory_item_id,
2944: organization_id,
2945: last_update_date,
2946: last_updated_by,

Line 3595: mtl_system_items_b m, -- model

3591: 2
3592:
3593: from
3594: mtl_parameters mp1,
3595: mtl_system_items_b m, -- model
3596: mtl_system_items_b c, -- config
3597: bom_cto_src_orgs bcso,
3598: bom_cto_order_lines_upg bcolu
3599: where bcolu.config_item_id is not null

Line 3596: mtl_system_items_b c, -- config

3592:
3593: from
3594: mtl_parameters mp1,
3595: mtl_system_items_b m, -- model
3596: mtl_system_items_b c, -- config
3597: bom_cto_src_orgs bcso,
3598: bom_cto_order_lines_upg bcolu
3599: where bcolu.config_item_id is not null
3600: and bcolu.status = 'BCSO'

Line 3618: from mtl_system_items_b

3614: and m.organization_id = mp1.organization_id
3615: and mp1.organization_id = bcso.organization_id
3616: and NOT EXISTS
3617: (select NULL
3618: from mtl_system_items_b
3619: where inventory_item_id = bcolu.config_item_id
3620: and organization_id = mp1.organization_id);
3621:
3622: WriteToLog('Items created::'||sql%rowcount, 2);

Line 3686: insert into mtl_system_items_b

3682: --perf bugfix 4905887 (sql id 16105473)
3683: --Removed comments to extent possible
3684:
3685: lStmtNumber := 20;
3686: insert into mtl_system_items_b
3687: (inventory_item_id,
3688: organization_id,
3689: last_update_date,
3690: last_updated_by,

Line 4339: mtl_system_items_b m, -- model

4335: 3,
4336: 2
4337:
4338: from
4339: mtl_system_items_b m, -- model
4340: mtl_system_items_b config, -- config
4341: bom_cto_src_orgs bcso,
4342: bom_cto_order_lines_upg bcolu
4343: where bcolu.config_item_id is not null

Line 4340: mtl_system_items_b config, -- config

4336: 2
4337:
4338: from
4339: mtl_system_items_b m, -- model
4340: mtl_system_items_b config, -- config
4341: bom_cto_src_orgs bcso,
4342: bom_cto_order_lines_upg bcolu
4343: where bcolu.config_item_id is not null
4344: and bcolu.status = 'BCSO'

Line 4360: from mtl_system_items_b

4356: and bcso.line_id = bcolu.line_id
4357: and m.organization_id = bcso.organization_id
4358: and NOT EXISTS
4359: (select NULL
4360: from mtl_system_items_b
4361: where inventory_item_id = bcolu.config_item_id
4362: and organization_id = bcso.organization_id);
4363:
4364: WriteToLog('PC Items created::'||sql%rowcount, 2);