APPS.INV_STATUS_PKG dependencies on MTL_ITEM_LOCATIONS

Line 35: MTL_ITEM_LOCATIONS_KFV mil

31:
32: select mms.status_code
33: into x_status_code
34: from mtl_material_statuses mms ,
35: MTL_ITEM_LOCATIONS_KFV mil
36: where mms.status_id = mil.status_id
37: and mil.INVENTORY_LOCATION_ID = p_locator_id
38: and mil.organization_id = p_org_id;
39:

Line 402: update mtl_item_locations

398: IF (l_debug = 1) THEN
399: mdebug('p_loc_status_id: '||p_loc_status_id);
400: END IF;
401: if p_loc_status_id >0 then
402: update mtl_item_locations
403: set status_id = p_loc_status_id
404: , last_updated_by = FND_GLOBAL.USER_ID
405: , last_update_date = SYSDATE
406: , last_update_login = FND_GLOBAL.LOGIN_ID