APPS.CTO_UPDATE_CONFIGS_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3622: from mtl_system_items_kfv msi

3618:
3619: l_stmt_num := 30;
3620: select substrb(concatenated_segments,1,50) name
3621: into l_child_model_name
3622: from mtl_system_items_kfv msi
3623: where msi.inventory_item_id = l_child_model_id
3624: and rownum=1;/* Fixed bug 3529482 */
3625:
3626:

Line 3995: mtl_system_items_kfv msi

3991: CURSOR c_success IS
3992: select distinct substrb(concatenated_segments,1,50) name,msi.inventory_item_id
3993: item_id
3994: from bom_cto_order_lines_upg bcolu,
3995: mtl_system_items_kfv msi
3996: where bcolu.config_item_id is not null
3997: and bcolu.config_item_id = msi.inventory_item_id
3998: and bcolu.ship_from_org_id = msi.organization_id
3999: and ((bcolu.config_creation = '3'

Line 4020: mtl_system_items_kfv msi

4016: CURSOR c_error IS
4017: select distinct substrb(concatenated_segments,1,50) name,
4018: msi.inventory_item_id item_id
4019: from bom_cto_order_lines_upg bcolu,
4020: mtl_system_items_kfv msi
4021: where bcolu.config_item_id is not null
4022: and bcolu.config_item_id = msi.inventory_item_id
4023: and bcolu.ship_from_org_id = msi.organization_id
4024: and not exists (select 'exists'

Line 4041: mtl_system_items_kfv msi,

4037: msi.inventory_item_id item_id,
4038: oeh.order_number,
4039: decode(bcolu.status, 'MRP_SRC', 'was successfully processed', 'errored out') status
4040: from bom_cto_order_lines_upg bcolu,
4041: mtl_system_items_kfv msi,
4042: oe_order_lines_all oel,
4043: oe_order_headers_all oeh
4044: where bcolu.config_item_id is not null
4045: and bcolu.config_item_id = msi.inventory_item_id