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;
1055:
1056: if l_inventory_item_id is not null then
1057: select concatenated_segments
1058: into l_item_name
1059: from mtl_system_items_kfv msi
1060: where organization_id = l_organization_id
1061: and inventory_item_id = l_inventory_item_id;
1062: end if;
1063: