230: END IF;
231:
232: OPEN x_replenish_count_locator_kff FOR
233: SELECT milk.inventory_location_id
234: , INV_PROJECT.GET_LOCATOR(milk.inventory_location_id, milk.organization_id) -- Bug 6798138
235: , milk.description
236: FROM mtl_item_locations_kfv milk
237: WHERE milk.organization_id = p_organization_id
238: AND milk.subinventory_code = p_subinventory
306: END IF;
307:
308: OPEN x_replenish_count_locator_kff FOR
309: SELECT milk.inventory_location_id
310: , INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id)
311: , milk.description
312: FROM mtl_item_locations_kfv milk
313: WHERE milk.organization_id = p_organization_id
314: AND milk.subinventory_code = p_subinventory