APPS.GMF_CBOM_REP_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 47: FROM mtl_system_items_b

43: -- 02-Nov-07 : if item-uom different from formula uom, scale the
44: -- item quantity to item-uom according to the uom conversion
45:
46: SELECT primary_uom_code into item_primary_uom
47: FROM mtl_system_items_b
48: WHERE inventory_item_id = p_invy_item_id
49: AND organization_id = p_organization_id ;
50:
51: IF (p_prod_ingr_ind = 'P') THEN

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 ;