308: REM| |
309: REM+=========================================================================+
310: */
311: FUNCTION get_item_name(v_item_id IN NUMBER) RETURN VARCHAR2 IS
312: l_item mtl_system_items_b_kfv.CONCATENATED_SEGMENTS%TYPE := '';
313: BEGIN
314: SELECT unique CONCATENATED_SEGMENTS INTO l_item
315: FROM mtl_system_items_b_kfv where inventory_item_id = v_item_id;
316: RETURN l_item ;
311: FUNCTION get_item_name(v_item_id IN NUMBER) RETURN VARCHAR2 IS
312: l_item mtl_system_items_b_kfv.CONCATENATED_SEGMENTS%TYPE := '';
313: BEGIN
314: SELECT unique CONCATENATED_SEGMENTS INTO l_item
315: FROM mtl_system_items_b_kfv where inventory_item_id = v_item_id;
316: RETURN l_item ;
317: EXCEPTION
318: WHEN NO_DATA_FOUND THEN
319: RETURN l_item ;