DBA Data[Home] [Help]

APPS.GMF_SUBLED_REP_PKG dependencies on MTL_ITEM_FLEXFIELDS

Line 144: FROM mtl_item_flexfields mif

140: FUNCTION get_item_desc (p_item_id IN NUMBER, p_org_id IN NUMBER) RETURN VARCHAR2 IS
141: l_ItemDesc VARCHAR2(500) := '';
142: BEGIN
143: SELECT mif.item_number ||' - '||mif.description INTO l_ItemDesc
144: FROM mtl_item_flexfields mif
145: WHERE mif.inventory_item_id = p_item_id
146: AND mif.organization_id = p_org_id ;
147:
148: RETURN l_ItemDesc;