409: BEGIN
410:
411: SELECT CONCATENATED_SEGMENTS
412: INTO x_item_number
413: FROM MTL_SYSTEM_ITEMS_KFV
414: WHERE INVENTORY_ITEM_ID = p_item_id AND
415: ROWNUM=1;
416:
417: EXCEPTION WHEN OTHERS THEN
547: BEGIN
548:
549: SELECT CONCATENATED_SEGMENTS
550: INTO x_item_name
551: FROM MTL_SYSTEM_ITEMS_KFV
552: WHERE INVENTORY_ITEM_ID = p_item_id AND
553: ROWNUM=1;
554:
555: EXCEPTION WHEN OTHERS THEN