318: G_Item_Segments.segment10,G_Item_Segments.segment11,G_Item_Segments.segment12,
319: G_Item_Segments.segment13,G_Item_Segments.segment14,G_Item_Segments.segment15,
320: G_Item_Segments.segment16,G_Item_Segments.segment17,G_Item_Segments.segment18,
321: G_Item_Segments.segment19,G_Item_Segments.segment20
322: FROM mtl_system_items
323: WHERE inventory_item_id = p_inventory_item_id
324: AND organization_id = l_org_id;
325:
326: END;