61: CURSOR loc_cursor IS
62: select inventory_location_id
63: ,concatenated_segments locator
64: ,subinventory_code
65: from mtl_item_locations_kfv
66: where concatenated_segments between
67: decode(p_location_fr,null,concatenated_segments,p_location_fr)
68: and decode(p_location_to,null,concatenated_segments,p_location_to)
69: and subinventory_code between