3391: IS
3392: /* get the locator id */
3393: CURSOR c_get_locator(v_org_id NUMBER,v_sub_inv VARCHAR2) IS
3394: SELECT inventory_location_id locator_id
3395: FROM mtl_item_locations_kfv
3396: WHERE organization_id = v_org_id
3397: AND subinventory_code = v_sub_inv
3398: AND concatenated_segments = p_locator_code;
3399:
3619: IS
3620: /* get the locator id */
3621: CURSOR c_get_locator(v_org_id NUMBER,v_sub_inv VARCHAR2,v_locator VARCHAR2) IS
3622: SELECT inventory_location_id locator_id
3623: FROM mtl_item_locations_kfv
3624: WHERE organization_id = v_org_id
3625: AND subinventory_code = v_sub_inv
3626: AND concatenated_segments = v_locator;
3627: