APPS.OE_CONFIG_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 4526: FROM MTL_SYSTEM_ITEMS_KFV

4522:
4523: BEGIN
4524: SELECT concatenated_segments
4525: INTO l_line_rec.ordered_item
4526: FROM MTL_SYSTEM_ITEMS_KFV
4527: WHERE inventory_item_id = l_line_rec.inventory_item_id
4528: AND organization_id = l_validation_org;
4529: EXCEPTION
4530: WHEN NO_DATA_FOUND THEN

Line 6448: mtl_system_items msi

6444:
6445: SELECT distinct 1
6446: INTO l_valid
6447: FROM oe_order_lines_all oel,
6448: mtl_system_items msi
6449: WHERE oel.line_id = p_line_id
6450: AND oel.inventory_item_id = msi.base_item_id
6451: AND msi.inventory_item_id = p_config_item_id;
6452:

Line 8040: from mtl_system_items mtl

8036:
8037: BEGIN
8038: select 'Y'
8039: into l_serviceable_item
8040: from mtl_system_items mtl
8041: where mtl.inventory_item_id = p_line_tbl(I).inventory_item_id
8042: and mtl.organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
8043: and mtl.serviceable_product_flag='Y'
8044: and rownum = 1;