[Home] [Help]
184: ( p_item_id IN NUMBER
185: , p_organization_id IN NUMBER
186: ) IS
187: SELECT concatenated_segments
188: FROM mtl_system_items_kfv
189: WHERE inventory_item_id = p_item_id
190: AND organization_id = p_organization_id;
191:
192: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;