128: return null;
129: end if;
130: select concatenated_segments
131: into item_text
132: from mtl_system_items_kfv
133: where organization_id = arg_org_id
134: and inventory_item_id = arg_item_id;
135:
136: return item_text;
149: return null;
150: end if;
151: select description
152: into item_desc
153: from mtl_system_items_kfv
154: where organization_id = arg_org_id
155: and inventory_item_id = arg_item_id;
156:
157: return item_desc;