APPS.EAM_COMMON_UTILITIES_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 229: FROM mtl_system_items_kfv msikfv, mtl_parameters mp

225: l_stmt_num := 70;
226:
227: SELECT msikfv.inventory_item_id
228: INTO l_inventory_item_id
229: FROM mtl_system_items_kfv msikfv, mtl_parameters mp
230: WHERE msikfv.organization_id = mp.organization_id
231: AND mp.maint_organization_id = l_organization_id
232: AND msikfv.concatenated_segments = l_concatenated_segments
233: AND rownum = 1;

Line 1058: from mtl_system_items_kfv msi

1054:
1055: if l_inventory_item_id is not null then
1056: select concatenated_segments
1057: into l_item_name
1058: from mtl_system_items_kfv msi
1059: where organization_id = l_organization_id
1060: and inventory_item_id = l_inventory_item_id;
1061: end if;
1062: