310: G_Item_Segments.segment10,G_Item_Segments.segment11,G_Item_Segments.segment12,
311: G_Item_Segments.segment13,G_Item_Segments.segment14,G_Item_Segments.segment15,
312: G_Item_Segments.segment16,G_Item_Segments.segment17,G_Item_Segments.segment18,
313: G_Item_Segments.segment19,G_Item_Segments.segment20
314: FROM mtl_system_items
315: WHERE inventory_item_id = p_inventory_item_id
316: AND organization_id = l_org_id;
317:
318: END;