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