DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on MTL_ITEM_LOCATIONS_KFV

Line 3395: FROM mtl_item_locations_kfv

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:

Line 3623: FROM mtl_item_locations_kfv

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: