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 1339: mtl_system_items msi,

1335: into l_rev_date
1336: from bom_calendar_dates cal,
1337: mtl_parameters mp,
1338: -- 4162494 wip_parameters wp,
1339: mtl_system_items msi,
1340: oe_order_lines_all oel
1341: where oel.line_id = l_config_line_id
1342: and mp.organization_id = oel.ship_from_org_id
1343: -- 4162494 and wp.organization_id = mp.organization_id

Line 1400: mtl_system_items msi

1396: oe_order_headers_all oeh,
1397: --oe_order_types_v oet,
1398: oe_transaction_types_tl oet,
1399: mtl_sales_orders mso,
1400: mtl_system_items msi
1401: where oel.line_id = l_config_line_id
1402: and oel.open_flag = 'Y'
1403: and item_type_code = 'CONFIG'
1404: and oeh.header_id = oel.header_id

Line 1506: mtl_system_items msi

1502: ***************************************************************/
1503: select oel.line_id, oel.inventory_item_id
1504: into x_config_line_id, x_config_item_id
1505: from oe_order_lines_all oel,
1506: mtl_system_items msi
1507: where oel.link_to_line_id = p_model_line_id
1508: and oel.item_type_code = 'CONFIG'
1509: and oel.inventory_item_id = msi.inventory_item_id
1510: and oel.ship_from_org_id = msi.organization_id