DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on MTL_ITEM_LOCATIONS_KFV

Line 3310: FROM mtl_item_locations_kfv

3306: IS
3307: /* get the locator id */
3308: CURSOR c_get_locator(v_org_id NUMBER,v_sub_inv VARCHAR2) IS
3309: SELECT inventory_location_id locator_id
3310: FROM mtl_item_locations_kfv
3311: WHERE organization_id = v_org_id
3312: AND subinventory_code = v_sub_inv
3313: AND concatenated_segments = p_locator_code;
3314:

Line 3536: FROM mtl_item_locations_kfv

3532: IS
3533: /* get the locator id */
3534: CURSOR c_get_locator(v_org_id NUMBER,v_sub_inv VARCHAR2,v_locator VARCHAR2) IS
3535: SELECT inventory_location_id locator_id
3536: FROM mtl_item_locations_kfv
3537: WHERE organization_id = v_org_id
3538: AND subinventory_code = v_sub_inv
3539: AND concatenated_segments = v_locator;
3540: