APPS.CTO_MATCH_AND_RESERVE dependencies on MTL_SYSTEM_ITEMS

Line 421: from mtl_system_items_kfv

417: oe_debug_pub.add('Top Model is not Eligible for MR iid is ' || l_top_model_item_id , 1);
418:
419:
420: select concatenated_segments into v_model_item_name
421: from mtl_system_items_kfv
422: where inventory_item_id = l_top_model_item_id
423: and rownum = 1 ;
424:
425: oe_debug_pub.add('Top Model is not Eligible for MR name is ' || v_model_item_name , 1);

Line 895: from mtl_system_items msi

891:
892: l_stmt_num := 170;
893: select msi.primary_uom_code
894: into l_primary_uom_code
895: from mtl_system_items msi
896: where msi.inventory_item_id = x_config_id
897: and msi.organization_id = l_org_id;
898:
899: /*------------------------------------------------------

Line 1332: mtl_system_items msi,

1328: into l_rev_date
1329: from bom_calendar_dates cal,
1330: mtl_parameters mp,
1331: -- 4162494 wip_parameters wp,
1332: mtl_system_items msi,
1333: oe_order_lines_all oel
1334: where oel.line_id = l_config_line_id
1335: and mp.organization_id = oel.ship_from_org_id
1336: -- 4162494 and wp.organization_id = mp.organization_id

Line 1391: mtl_system_items msi

1387: oe_order_headers_all oeh,
1388: --oe_order_types_v oet,
1389: oe_transaction_types_tl oet,
1390: mtl_sales_orders mso,
1391: mtl_system_items msi
1392: where oel.line_id = l_config_line_id
1393: and oel.open_flag = 'Y'
1394: and item_type_code = 'CONFIG'
1395: and oeh.header_id = oel.header_id

Line 1489: mtl_system_items msi

1485: ***************************************************************/
1486: select oel.line_id, oel.inventory_item_id
1487: into x_config_line_id, x_config_item_id
1488: from oe_order_lines_all oel,
1489: mtl_system_items msi
1490: where oel.link_to_line_id = p_model_line_id
1491: and oel.item_type_code = 'CONFIG'
1492: and oel.inventory_item_id = msi.inventory_item_id
1493: and oel.ship_from_org_id = msi.organization_id