DBA Data[Home] [Help]

APPS.GMF_CBOM_REP_PKG dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 312: l_item mtl_system_items_b_kfv.CONCATENATED_SEGMENTS%TYPE := '';

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 ;

Line 315: FROM mtl_system_items_b_kfv where inventory_item_id = v_item_id;

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 ;