APPS.CTO_UPDATE_CONFIGS_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3254: from mtl_system_items_kfv msi

3250:
3251: l_stmt_num := 30;
3252: select substrb(concatenated_segments,1,50) name
3253: into l_child_model_name
3254: from mtl_system_items_kfv msi
3255: where msi.inventory_item_id = l_child_model_id
3256: and rownum=1;/* Fixed bug 3529482 */
3257:
3258:

Line 3624: mtl_system_items_kfv msi

3620: CURSOR c_success IS
3621: select distinct substrb(concatenated_segments,1,50) name,msi.inventory_item_id
3622: item_id
3623: from bom_cto_order_lines_upg bcolu,
3624: mtl_system_items_kfv msi
3625: where bcolu.config_item_id is not null
3626: and bcolu.config_item_id = msi.inventory_item_id
3627: and bcolu.ship_from_org_id = msi.organization_id
3628: and ((bcolu.config_creation = '3'

Line 3649: mtl_system_items_kfv msi

3645: CURSOR c_error IS
3646: select distinct substrb(concatenated_segments,1,50) name,
3647: msi.inventory_item_id item_id
3648: from bom_cto_order_lines_upg bcolu,
3649: mtl_system_items_kfv msi
3650: where bcolu.config_item_id is not null
3651: and bcolu.config_item_id = msi.inventory_item_id
3652: and bcolu.ship_from_org_id = msi.organization_id
3653: and not exists (select 'exists'

Line 3670: mtl_system_items_kfv msi,

3666: msi.inventory_item_id item_id,
3667: oeh.order_number,
3668: decode(bcolu.status, 'MRP_SRC', 'was successfully processed', 'errored out') status
3669: from bom_cto_order_lines_upg bcolu,
3670: mtl_system_items_kfv msi,
3671: oe_order_lines_all oel,
3672: oe_order_headers_all oeh
3673: where bcolu.config_item_id is not null
3674: and bcolu.config_item_id = msi.inventory_item_id