APPS.INV_UPDATE_ONHAND_STATUS dependencies on MTL_MATERIAL_STATUSES_VL

Line 178: FROM mtl_material_statuses_vl

174: IF (l_count = 0) THEN
175:
176: UPDATE mtl_parameters
177: SET default_status_id = (SELECT status_id
178: FROM mtl_material_statuses_vl
179: WHERE status_code = p_default_status)
180: WHERE organization_id = orgid_list(i);
181: print_debug('Updated Default Material Status at organization level for org: '|| orgid_list(i));
182: ELSE