76: else
77:
78: select msi.concatenated_segments
79: into ret_val
80: from mtl_system_items_kfv msi
81: where rowid = ri;
82:
83: return(ret_val);
84: end if;
203: else
204: begin
205: select 'T'
206: into ret_val
207: from mtl_system_items_kfv msi
208: where msi.inventory_item_id = x_item_id
209: and msi.organization_id = x_org_id
210: and msi.bom_item_type = 4
211: and msi.base_item_id is not null
231: else
232:
233: select msi.concatenated_segments
234: into ret_val
235: from mtl_system_items_kfv msi
236: where inventory_item_id = x_item_id and
237: organization_id = x_org_id;
238:
239: return(ret_val);